Using search() in calculate

Hi @RAFTA
search function works more with text values so it handles options like:

  • contains
  • startswith
  • endswith
  • matches

so your case might be not possible to achieve but who knows maybe there is someone on this forum who was able to do something like that somehow, from my experience: never say never so I'm also curious.

When it comes to search function here you can find a good video about it: https://www.youtube.com/watch?v=eEXa8GK4yE4