Hi,
I am outputting data to a text file from PROIV. The file is supposed to be tad delimited. How do I include a tab after each field in my PROIV Code?
Thanks,
Create Tab Delimited File
Started by motely, Mar 20 2009 05:34 PM
2 replies to this topic
#2
Posted 20 March 2009 - 05:59 PM
It's covered on here elsewhere. But to cut a long story short a tab is CHAR(9).
So create an Update (or Report to a file) containing a large text field. Then append the fields...
FIELD1 + CHAR(9) + FIELD2 + CHAR(9) etc
If you have numerics in there you may need to put + CHAR(9) + CONV(NUMERICFIELD) + CHAR(9) etc.
So create an Update (or Report to a file) containing a large text field. Then append the fields...
FIELD1 + CHAR(9) + FIELD2 + CHAR(9) etc
If you have numerics in there you may need to put + CHAR(9) + CONV(NUMERICFIELD) + CHAR(9) etc.
Reply to this topic
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users