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...
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.

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...