How to export without Double quotes in Tab Separated Text (TTX) file 1

[Rbp1226]

I need export a format as Tab Separated Text (TTX) file from Crystal Report XI, but customer does not like double quotes for the string fields, it is huge size data, and it need take more than 30 minutes manually replace the double quotes, some times stopped process and could not finish the replacment from EDIT-REPLACE, is any one know if there is the function or option to limited the double quotes when exporting?

Example:

“ID” “Employee Title”
2433 “Programmer”
5566 “Manager”
3345 “Team Leader”
3257 “Report Writer”

 

[lbass]

Are you saying you cannot successfully use edit->find/replace? You would just enter " in the find area and nothing in the replace area. Shouldn't take long to process.

-LB

 

[chelseatech]

Export formats in Crystal never quite do what you really want them to do.

Have a look at our Grid Output User Function Library. It creates a text file as the report is processing. It can create a data file that looks exactly the way you want.

Download a trial version from our web site.

Editor and Publisher of Crystal Clear

http://www.chelseatech.co.nz/pubs.htm

 

[Rbp1226]

Thanks LB! I tried use edit->find/replace, it was working fine in the beginning but stopped late on, the file was huge size, and I finally wrote SQL statement and used Toad to save as txt file.

chelseatech, thanks for the info and provide me this web site


Rbp1226