Excel mid formula excel equivalent

[Usamah22]

Hello

i have a column with text such as 1010000001010010.

i need to determine whether the 10th value is 1 and then use that for a conditional statement. What can i use to get this?

[GiuseppeC · Accepted solution]

Hi @Usamah22,

this function in a formula tool will allow you to extract the 10th character from your string, which you can then use in a conditional statement.

Substring([YourStringField],9,1)

Notice 9 to indicate the 10th character because the start of the substring is 0-based (first character is position 0).

Hope this helps!

Giuseppe

[Jonathan-Sherman · Accepted solution]

Hi @Usamah22,

Using the formula:

IF Substring(ToString([String]),9,1) = '1' THEN 'True' ELSE 'False' ENDIF

This will return "True" if the 10th character = 1 and "False" if it does not.

If this solves your issue please mark the answer as correct, if not let me know! I've attached my workflow for you to download if needed.

Regards,

Jonathan

[Usamah22]

thank you!

[zahinrahman]

Substring would be the excel equivalent in Alteryx!