Custom Formula to Find a Specific Character

Question

I have an account field that is always 7 digits long.  I need to find where the 5th digit is a 7.  The number 7 could be anywhere in the account field, but I don't want to capture those.  So the StartsWith, EndsWith and RegEx won't work for me.  Does anyone have any other suggestions for how to locate these accounts.

So in the 4 examples below, I would only want to return the first 3 accounts.

4300701430075540407884470000

Thank you!

Leigh

CharlieS · Accepted Answer

Hi @lwolfram

Without RegEx, this expression could be used in a Formula tool:

IF Right(left(tostring([Account]),5),1)=='7' THEN 'true' ELSE 'false' ENDIF

Thableaus · Accepted Answer

Hi @lwolfram

You could use this formula:

IF Substring(ToString([Field1]),4,1) = "7" THEN "Yes" ELSE "No" ENDIF

Substring function can get a start and a length to find strings.

Cheers,