Searching for ' - ' in a string.

[dirk1955]

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.

[Marcos_rv]

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

[sunny_talwar · Accepted solution]

I think what you really need is Index() function

Index(RefIDWL, ' - ', 1)