Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Purgechar(Field, chr(10)&chr(13)) as Field
LOAD
FieldA,
FieldB,
replace(replace(FieldC, chr(13), ''),chr(10),'') as FieldC,
...etc
FROM ...
Purgechar(Field, chr(10)&chr(13)) as Field
both are correct, btw i had to use chr 194 and 160, i dunno what combination is