Hi Everyone

I need to write the file including column header with comma(,) or pipe(|) delimiter from the table using webfocus.

for example output should be:

S.No|S_Name|S_Address1|S_Address2|S_Phone_no
1|xxxx|dvhv|dhvg|98840
2|yyyy|fsgf|cfhsdjf|30788

Please help me, we are struggling more on this

This message has been edited. Last edited by: FP Mod Chuck,

Use ON TABLE HOLD FORMAT DFIX

You can search for DFIX on the help files - here

T

Well, FORMAT COMT gives you a bogstandard .csv file with the titles.

If you need something more exotic, and you need to use some masking then you might want to look at
http://forums.informationbuild...1057331/m/9391009003

Actually, what Tony there said DFIX is the way to go:

TABLE FILE CAR
PRINT *
ON TABLE PCHOLD FORMAT DFIX DELIMITER | ENCLOSURE " HEADER YES
END

Or what was in your example, you can leave that ENCLOSURE " away.

This message has been edited. Last edited by: Hank W.,