CAN YOU EXPORT A PIPE DELIMITED FILE FROM CRXI?

[deborahyr]

Using Crystal Report XI, can I create a pipe delimited file?

 

[MrBillSC]

You should be able to do it by creating a text formula similar to this:
//formula: MyData
Trim({Table.TextField1}) + "|" +
Trim({Table.TextField2}) + "|" +
ToText({Table.NumField3}) + "|" +
etc.
Then display this as the only field in the report and export it into a text file.

MrBill

 

[IanWaterman]

When you go to Export file, in drop down list you can select CSV.

This opens another dialog box where you can define delimiter and whether text is enclosed or not.

Ian