Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Customers, Partners & Luminaries only: You're invited to a Data Analytics Roadmap session. Read More
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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

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

View solution in original post

3 Replies
Highlighted
MVP & Luminary
MVP & Luminary

LOAD

     FieldA,

     FieldB,

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

     ...etc

FROM ...


talk is cheap, supply exceeds demand

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

View solution in original post

Highlighted
Not applicable

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