Join the Alteryx Community’s Maveryx Summer Cup event! Compete, network with others, and earn your gold through a series of challenges from July 24th to August 11th. Learn more about the event here.

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