Forum Discussion

some's avatar
some
New Member
3 years ago
Solved

SEARCH function stopped working suddenly

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
Need Help
  • some's avatar
    some
    3 years ago

    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.

4 Replies

  • some's avatar
    some
    New Member
    3 years ago

    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's avatar
    mlsx4
    Memorable Member
    3 years ago

    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's avatar
      some
      New Member
      3 years ago

      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's avatar
        mlsx4
        Memorable Member
        3 years ago

        Hi some 

         

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