Parse Constant String from a Column

[MysticalAz]

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!

[MilindG · Accepted solution]

[MysticalAz]

That was easier than I was making it.. Thank you!

[DataNath]

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())

[srvas17]

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