Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

Alteryx Designer Desktop Discussions

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

Regex tool

Devika
8 - Asteroid

Hello ,

 

Please help me use the regex tool for the below output 

 

Input 

 

I10257700007
I13493600001
I64961600001
I07698300001

I03660900002

Output 

I10257700007I10257700007
I13493600001I13493600001
I64961600001I64961600001
I07698300001I07698300001
I03660900002I03660900002
5 REPLIES 5
binuacs
21 - Polaris

@Devika 

binuacs_0-1647427746603.png

 

Hamza199
7 - Meteor

Hi,

 

I am interested in why you have two values in your brackets for digits? Initially, I assumed you need 1 number to signify the length of digits e.g. d{6}= 6 digits. What does d{6,6,} mean?

binuacs
21 - Polaris

@Devika  you can also use the string functions if you know the length of your outputs

binuacs_1-1647427983075.png

 

 

binuacs
21 - Polaris

@Hamza199 in this use case \d{6} should work, please see the explanation of the {6,6} below 

binuacs_0-1647428207077.png

 

EN6924
10 - Fireball

EN6924_0-1647983418528.png

 

Labels