Search for a number in a field

[terezagr]

Hi,

In a field I have a string of numbers like this:

0111111011111000000000000000000000000000000000000000

Is there an expression that can help me to find that in this row the number 1 is on 2nd, 3rd etc place in this string?

Thank you for your help!

T.

[Gysbert_Wassenaar · Accepted solution]

You can try using the mid function. To check if the second character is a 1: if(mid(MyString, 2,1)='1', 'Match', 'No Match')

Or to check three 1's starting from position two:  if(mid(MyString, 2,3)='111', 'Match', 'No Match')

[terezagr]

Thank you! Works great!