Regex tool

[BRRLL99]

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

[flying008]

Hi, @BRRLL99 

FYI.

[BRRLL99]

is it possible to parse without using text to columns

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

[flying008 · Accepted solution]

Hi, @BRRLL99 

Of course it can be done!

or use parse mode by regex tool:

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