Character Extraction

[SVIGGIANO]

This should be easy for an Alteryx person but for sum reason have a difficult time tonight.  I have a string (example:RPD4_Boot_to_Kernel) and I just want to extract the 4th character from all like strings to get the key number ( in this case 4.  In Excel for formula is easy (=MID(C4,4,1)), I don't know regular expressions, but I thought with all the amazing thigs I can do with Alteryx, this one should have been easy.  Your help would be greatly appreciated.

[Qiu]

@SVIGGIANO 
Formula for RegEx for your pick.

[atcodedog05]

Hi @SVIGGIANO 

Substring of Alteryx works similar to excel Mid. See the formula below.

substring([Field1],3,1)

 Output:

Hope this helps 🙂

If this post helps you please mark it as solution. And give a like if you dont mind 😀👍