Ascii

[DrJimmy]

Hi,

I have some address data in a field that contains carriage return and line feed characters. I want to be able to replace these with comma's so I can export to excel and delimit via comma to seperate the address lines.

Can anyone help?

Cheers

 

[DrJimmy]

Just answered my own question. Using REPLACE (field.name, ASC(#),'new text').