In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

Alteryx Designer Desktop Discussions

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

Regex tool

BRRLL99
11 - Bolide

Hi

I have following dataset

 

Input 

0.4DB

2,99,99,00CR

0.00

4.2DB

26,700CR

0

150.00DB

 

EXPECTED OUTPUT  all strings and numbers should be shown in seperate column, since i have multiple columns i would like use formula or regex tool

 

0.4                  DB

2,99,99,00     CR

0.00    

4.2                 DB

26,700          CR

0

150.00          DB

 

3 REPLIES 3
flying008
15 - Aurora

Hi, @BRRLL99 

 

FYI.

 

录制_2024_03_13_15_02_55_217.gif

BRRLL99
11 - Bolide

is it possible to parse without using text to columns

just using formula tool to create numbers and string as separate columns

flying008
15 - Aurora

Hi, @BRRLL99 

 

Of course it can be done!

录制_2024_03_13_15_28_44_761.gif

 

or use parse mode by regex tool:

 

^([^a-z]+)([a-z]*)$

录制_2024_03_13_15_40_35_146.gif

 

Labels
Top Solution Authors