Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
dirk1955
Contributor

Searching for ' - ' in a string.

Hi,

To split some data in a string, i'm using "FindOneOf(RefIDWL,' - ',1)".

Everything works wel except that the function does not only find ' - ' but also '-'.

Is there a solution?

Greetings 

Dirk.

Labels (3)
1 Solution

Accepted Solutions
Highlighted

Re: Searching for ' - ' in a string.

I think what you really need is Index() function

Index(RefIDWL, ' - ', 1)

View solution in original post

2 Replies
Highlighted
Marcos_rv
Contributor II

Re: Searching for ' - ' in a string.

try this:
FindOneOf(replace( RefIDWL , ' ' , '@' ) ,'@-@',1)
Highlighted

Re: Searching for ' - ' in a string.

I think what you really need is Index() function

Index(RefIDWL, ' - ', 1)

View solution in original post