split data by a dynamic letter

[187]

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

[binu_acs · Accepted solution]

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

[messi007]

@187,

Please see below :

Attached the workflow,

Regards

[grazitti_sapna]

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

Thanks!

[187]

thank you guys!!!! appreciated