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.
@SVIGGIANO
Formula for RegEx for your pick.
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 😀👍