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

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Upgrade Alteryx Designer in 10 Steps

Debating whether or not to upgrade to the latest version of Alteryx Designer?

LEARN MORE

Delimiters

Meteor

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