I am trying to use the 'if' expression under the formula tool, but can't figure out how to check the third character of a string
@sehgaln See if this gets you what you're wanting:
iif(REGEX_Replace([Field1], "(..)(.)(.*)", "$2")="c",null(),[Field1])
This checks if the third character is 'c' and makes the value null if so or back to the original value if not.
Hey @sehgaln!
I'm not sure exactly what you're looking to do with your if statement, but the following expression will return the third character of your string.
REGEX_Replace([Field1], "(..)(.)(.*)", "$2")
Hope this helps!
@BarnesK
If I need to do something like this: if third character in string is equal to 'X' then....
Would I still use RegEx?
