Guest Posted February 15, 2021 Share Posted February 15, 2021 How about something like this: TABLE FILE CAR PRINT COUNTRY CAR MODEL ON TABLE HOLD FORMAT DFIX DELIMITER , ENCLOSURE " PRESERVESPACE YES END Link to comment Share on other sites More sharing options...
Brad Gronli Posted February 15, 2021 Author Share Posted February 15, 2021 I have a couple of .fex which in 7.7 were creating the output as LOTUS, with no column headers. Now in 8.2, we had to switch these to .csv, but I need to figure out how to create the output without a column header row. Any ideas Link to comment Share on other sites More sharing options...
Patrick Huebgen Posted February 16, 2021 Share Posted February 16, 2021 Had this challenge as well - thats the perfect FORMAT string -DATASET is important as it will determine the file that is downloaded ON TABLE PCHOLD AS EXPORT.CSV FORMAT DFIX DELIMITER , ENCLOSURE " HEADER YES DATASET EXPORT.CSV Link to comment Share on other sites More sharing options...
Brad Gronli Posted February 16, 2021 Author Share Posted February 16, 2021 Thank you both. I did apply Patricks suggestion and it looks to have worked. I will know better when the customers schedule runs tomorrow and they pick up the output. In this case, the schedule runs the program and FTPs the file as .txt to our server, where they then retrieve the file. Oh, the only change I had to make was to change YES to NO, since we did not want the column titles. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now