Alteryx Designer Desktop Discussions

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

Regex tool

Devika
Asteroide

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 RESPUESTAS 5
binuacs
Polaris

@Devika 

binuacs_0-1647427746603.png

 

Hamza199
Meteoro

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
Polaris

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

binuacs_1-1647427983075.png

 

 

binuacs
Polaris

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

binuacs_0-1647428207077.png

 

EN6924
Bola de fuego

EN6924_0-1647983418528.png

 

Etiquetas
Autores con mayor cantidad de soluciones