Hi,

I see in the documentation that you can do a:

ON TABLE PCHOLD FORMAT DIF

to create a comma-delimted file but it appears to just create an Excel file.

I need to create a delimited file (with comma, |, or period) so I can:

1). Automate this file creation
2). Import into a DB using "LOAD DATA INFILE 'e:\\SAPrepository\\download\\ta_west_po.txt'"

I can't export out of Excel to CSV because that involves me manually touching the file. Any help would be appreciated.

Thanks

This will bring it back as a comma seperated file.

ON TABLE PCHOLD FORMAT COMMA

... or if you want column titles then use FORMAT COMT

T

Thanks Lucas.... That worked!