Cr/Lf delimited field in SQL table

[5lights]

The field contains 1-3 5-char codes delimited by 'cr/lf'.
How can I display the contents on a single line?

 

[vidru]

Try using the Replace function on the string to get rid of the carriage returns. This will replace them with spaces:

Replace({Table.Field}, Chr(13), " ")

-dave

 

[5lights]

Regretfully, I'm forced to use an older version of Crystal(7)....so I'm working with :
If instr({Charges.CPTCodes}, Chr(13)) >0 then
StringSubString ({Charges.CPTCodes},Chr(13),",")

This adds the comma, but I still get the data on two lines..

Any more ideas?

 

[vidru]

Do you have the Search and Replace UFL?

http://support.businessobjects.com/communityCS/FilesAndUpdates/uflrepl.exe.asp

That would be much easier then trying to pick apart the string. The downside is that the .dll would have to be deployed to any/all workstations that you're running the report from.

-dave

 

[5lights]

No, dont have that UFL....am thinking I'll re-format my layout to allow the multiple-line data.
I'm burned out, will finish tomarrow.
Thanks for the suggestions.