Remove CR LF in LOAD statement

[#1]

Hi, i have a field in a LOAD statement which sometimes ends with a CR LF character, how can i remove it in the LOAD statement?

[Gysbert_Wassenaar]

LOAD

     FieldA,

     FieldB,

     replace(replace(FieldC, chr(13), ''),chr(10),'') as FieldC,

     ...etc

FROM ...

[MarcoWedel · Accepted solution]

Purgechar(Field, chr(10)&chr(13)) as Field

[#4]

both are correct, btw i had to use chr 194 and 160, i dunno what combination is