Delimiters

[Carolyne]

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

[ShawnM]

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.

[iludeiro · Accepted solution]

Thank you! This was just what I was looking for!