Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Wrap Text

I am bringing in an excel document that I want to touch as little as possible but one of the cells has wrapped text in it and I don't know how to get rid of the extra letters it causes.

1 Solution

Accepted Solutions
swuehl
MVP
MVP

I am just guessing, but you probably want to remove some special characters like a LF character, so maybe try

LOAD

     FIELD,

    Purgechar(FIELD, chr(10)&chr(13) ) as FIELD_PURGED,

     ...

FROM ...;

View solution in original post

6 Replies
swuehl
MVP
MVP

You can use Keepchar() to keep only characters you want to show or Purgechar() to explicitely drop some characters from your string.

Have a look at the HELP page of both functions.

String functions ‒ Qlik Sense

Anonymous
Not applicable
Author

Will that work on just the one problem cell ?

swuehl
MVP
MVP

Can you detail how your input file / data looks like or post a sample file?

Anonymous
Not applicable
Author

So I tried it but it got rid of all the corresponding letters not just the phrase I needed removed

swuehl
MVP
MVP

I am just guessing, but you probably want to remove some special characters like a LF character, so maybe try

LOAD

     FIELD,

    Purgechar(FIELD, chr(10)&chr(13) ) as FIELD_PURGED,

     ...

FROM ...;

Anonymous
Not applicable
Author

I may just have to touch the data after all. Thank you for your help!