Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Delimiters

Carolyne
8 - 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

2 REPLIES 2
ShawnM
Alteryx Alumni (Retired)

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
5 - Atom

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

Labels