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
20 - Arcturus

@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
20 - Arcturus

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

binuacs_1-1647427983075.png

 

 

binuacs
20 - Arcturus

@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