topic Wrap Text in App Development

Wrap Text

Anonymous — Wed, 11 Oct 2017 20:17:42 GMT

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.

Re: Wrap Text

swuehl — Wed, 11 Oct 2017 20:25:48 GMT

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

Re: Wrap Text

Anonymous — Wed, 11 Oct 2017 20:39:55 GMT

Will that work on just the one problem cell ?

Re: Wrap Text

swuehl — Wed, 11 Oct 2017 20:43:22 GMT

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

Re: Wrap Text

Anonymous — Wed, 11 Oct 2017 20:58:26 GMT

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

Re: Wrap Text

swuehl — Wed, 11 Oct 2017 21:04:40 GMT

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 ...;

Re: Wrap Text

Anonymous — Thu, 12 Oct 2017 13:07:18 GMT

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