I am trying to use PFI process flow to create a tab delimited file. Using SQL to pull data. What do I use for the tab delimiter? Is there something I can use in the SQL node to string together all the data? Tried \t including assigning it to a variable. Also tried + char(9) + to string data along as well.
Thoughts?
Thanks!
Hi cwilliam,
I'm not sure how you would do within a SQL query, but you could certainly do this within a File node or MessageBuilder node. JavaScript recognizes '\t' as tab, so you can assign that to a variable and then insert it between your fields in the File or MB nodes. The only trick is that you have to wrap it with single quotes.
Attached are some screenshots, as well as a sample flow that shows this along with a sample output file.
I hope this helps.
Kelly
EDIT: replaced incorrect sample flow...