I get a monthly file txt file with the output below
T454520161112
T454520161212
What I want is
Contract Number
File Date
T4545
20161112
20161212
Thank you! This was just what I was looking for!
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.
