I get a monthly file txt file with the output below
T454520161112
T454520161212
What I want is
Contract Number | File Date |
T4545 | 20161112 |
T4545 | 20161212 |
Solved! Go to Solution.
I've attached a solution that uses the RegEx Parse tool. This tool can be used to recognized patterns in a string column and parse our specific text based on those patterns. The current configuration of this tool in the attached workflow assumes that the field is going to end with 8 digits representing the date, and that the contract number will be a single letter followed by a series of numbers.
Thank you! This was just what I was looking for!