Discussion board where members can get started with QlikView.
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
View solution in original post
replace(replace(FieldC, chr(13), ''),chr(10),'') as FieldC,
both are correct, btw i had to use chr 194 and 160, i dunno what combination is