Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join us for a live Q&A! September 21, 10 AM ET - Onboarding Fast in Qlik Sense SaaS! REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Remove CR LF in LOAD statement

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?

1 Solution

Accepted Solutions
MarcoWedel

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

View solution in original post

3 Replies
Gysbert_Wassenaar

LOAD

     FieldA,

     FieldB,

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

     ...etc

FROM ...


talk is cheap, supply exceeds demand
MarcoWedel

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

View solution in original post

Not applicable
Author

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