Carriage Return, Line Feed

[scclem]

I am pulling data from an Oracle database that is a varchar(300) text field. I have gotten around the size of the field by creating a view that breaks the data into smaller part so I can use Crystal formulas to check the data.

The main application creating this data allows for a CR/LF to be input in the text box. I need to remove these from within the Crystal report fields for a couple different reasons.

Is there a way to search these text string for the ASCII strings that represent the CR/LF and then remove them or replace them?

Scott

 

[mbarron]

There is a replace function but I don't know if it will help in your case. I got it to work with a formula field that had chr(13)'s in it.

basic format is:
replace(where to look,what you're looking for,with this)


replace({your field},chr(13),"the text you want to replace the chr(13)&quot

Mike

 

[scclem]

Thanks, Mike. I ended up with this statement

replace({fieldname}, chr(13)+ CHR(10), " &quot

and it works great.


Scott