Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

split data by a dynamic letter

187
8 - Asteroid

Hi there, i have below data

 

19A22
222D33
3333C44

 

how can i get the data like below?

 

19       A     22
222     D     33

3333   C     44

4 REPLIES 4
binuacs
20 - Arcturus

@187 One way of doing this with the Regex Parse method

binuacs_0-1659343414369.png

 

messi007
15 - Aurora
15 - Aurora

@187,

 

Please see below :

 

messi007_0-1659343592700.png

 

Attached the workflow,

Regards

grazitti_sapna
17 - Castor

@187, another way to solve this problem in case you get lowercase letter mixed in the data.

grazitti_sapna_0-1659343634144.png

 

 

Thanks!

 

Sapna Gupta
187
8 - Asteroid

thank you guys!!!! appreciated

Labels