Can't you just export as csv, then open and change the separator to pipe?

Trying to automate sending to BI database.