removing returns

[rseiler]

I'm trying to write a function that will replace all 'hard carriage returns' with ' '. I am using the Replace function, but not sure what to put in the second parameter.

Replace (Procedure,"x" ," " );

Anyone have any ideas for me?

Rick

 

[MSBrady]

You may try the ASCII equivalent for space.

http://www.lookuptables.com

 

[rseiler]

Thanks MSBrady... I will give this a try.

Rick

 

[lbass]

Try something like:

replace(replace(replace({table.procedure},chr(13)," "),chr(10)," ")," "," ")

The last replace ensures there is only one space replacing the return. You might not need to check for chr(10), which is for a line feed, so you should experiment a little.

-LB

 

[rseiler]

lbass,
Thank you very much for the help.... I wasnt sure how to type the carrage return. This work excellent, and was exactly what I was looking for.

Rick