ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests Early 2026. Make sure to check your account preferences in my.alteryx.com to make sure you have filled out your security questions. Learn more here
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
解決済み

Regex tool

Devika
アステロイド

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件の返信5
binu_acs
ポラリス

@Devika 

binuacs_0-1647427746603.png

 

Hamza199
メテオール

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?

binu_acs
ポラリス

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

binuacs_1-1647427983075.png

 

 

binu_acs
ポラリス

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

binuacs_0-1647428207077.png

 

EN6924
ファイアボール

EN6924_0-1647983418528.png

 

ラベル
トップのソリューション投稿者