SEARCH function stopped working suddenly

[some]

Hi we have this search function:

kalkPreis = LEFT(NurLagerMitPksID[PKS_ID],SEARCH("∼∼",NurLagerMitPksID[PKS_ID])-1)

this function worked online and in desktop until yesterday! now it throws the error, that the searched text can not be found.

we changed nothing here is an example of the data searched:

5.08~waXrAghi26phUWb0e6Pc

I also tried it with UNICHAR() but that also doesn't work.

The error is thrown for every row.

Br

[some · Accepted solution]

I solved it by copying the symbol from one row. It seems to be a slightly different tilde than the normal one but now it works again.

[mlsx4]

Hi @some 

I don't know if it makes sense but you have two characters here "∼∼" and in the searched value you only have one 

[some]

Hi, yes I have. When you search for tildes you need to use two. Because the tilde character is the masking charater in the search function 

[mlsx4]

Hi @some 

It could seem very weird but I tried to rewrite the two tildes within the formula and now works...