Hello,
In the attached sample dataset, I'm trying to parse column "Field 1". I'd like to parse out the T100 #s. Some may be null because it does not exist. The final output column should have T100-#####.
Thanks!
That was easier than I was making it.. Thank you!
If the target IDs are always that consistent 10-character T100-X, then this ought to work:
IIF(FindString([Field 1], 'T100-')>-1,Substring([Field 1],FindString([Field 1], 'T100-'),10),null())
Just to add a layer of capability for other users trying to do the same, I find this site great to test and develop more complicated Regex to feed the tool: regex101: build, test, and debug regex
