Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
homersimpson
Not applicable

Whitespace problem - findOneOf

Hi,

i don´t understand this phenomenon. The first expression shows 0, the second 5. Please, see attachement.

//FindOneOf('text ',':&%$ !"§/') // = 0

FindOneOf('text ',':&%$ !"§/') // = 5

I copy the whitespace from the first expression into notepad++ and "show all character", but there is nothing to see what could explain it.

Does somebody has any idea?

Regards,

sam

1 Solution

Accepted Solutions
rubenmarin
Not applicable

Re: Whitespace problem - findOneOf

Hi, that space is the ascii code 160, you can use:

FindOneOf('text ',':&%$$(=Chr(160))!"§/'

And Ord('CopyCharacterHere') to retrieve the ascii code of a character

2 Replies
rubenmarin
Not applicable

Re: Whitespace problem - findOneOf

Hi, that space is the ascii code 160, you can use:

FindOneOf('text ',':&%$$(=Chr(160))!"§/'

And Ord('CopyCharacterHere') to retrieve the ascii code of a character

homersimpson
Not applicable

Re: Whitespace problem - findOneOf

Thanks a lot!

Regards,

Sam