community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.

Delimiters

Highlighted
Asteroid

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

Alteryx
Alteryx

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.

Labels