Sage 100

What is the line break character in the extended description file? I need to do a replace in a Crystal report to have all the data on one line for Excel export, but Replace({CI_ExtendedDescription.ExtendedDescriptionText},chr(10) + chr(13),""|"") does not seem to work.

Those should be correct for the line feed and carriage return. I wonder if it doesn't like the Pipe? maybe try ""chr(166)"" instead? (I think!)

I only see 1 Special character. Ascii value is 13. Maybe skip the chr(10) ?

replace({CI_ExtendedDescription.ExtendedDescriptionText},chr(13),chr(124)) should work to remove the carriage feeds and replace it with a pipe.

Thanks for the suggestions. removing chr(10) did it - the pipe works in quotes or as chr(124)