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

Splitting a text in two 4 parts.

sriniprad08
11 - Bolide

Hi Team,

Hope you are well.

I have column with list of codes. I would like to split into 4 parts/columns.

 

Please find below the text

1) BBVAUS33XXX 

2) INGBNL2A

 

 

Output - Text 1

Column A - BBVA

Column B - US

Column C - 33

Column 4 - xxx

 

 

Output - Text 2

Column A - INGB

Column B - NL

Column C - 2A

Column 4 - Blank

 

Please let me know how to go about htis,

 

cheers,

Sri

 

6 REPLIES 6
ShankerV
17 - Castor

Hi @sriniprad08 

 

One way of doing this.

ShankerV_0-1678701807978.png

ShankerV_0-1678701853830.png

 

Many thanks

Shanker V

 

ShankerV
17 - Castor

Hi @sriniprad08 

 

The column name can be changed, here to reflect in the output.

 

ShankerV_0-1678702180801.png

 

ShankerV_1-1678702199626.png

 

Many thanks

Shanker V

 

sparksun
11 - Bolide

sparksun_0-1678702444384.png

 

sriniprad08
11 - Bolide

Hi @ShankerV 

Hope you are doing well. Thank you for the help.

When i am trying to apply this on another code its not splitting it into 4 parts.

 

Please find attached and let me know if i am missing anything,

 

Thanks

 

 

sriniprad08_0-1678781543643.png

 

ShankerV
17 - Castor

Hi @sriniprad08 

 

Hope you are expecting the results like below highlighted in yellow.

 

ShankerV_0-1678854671211.png

(\u{4})(\u{2})(.{0,2})(.{0,3})

 

ShankerV_2-1678854688230.png

 

Many thanks

Shanker V

sriniprad08
11 - Bolide

Hi @ShankerV ,

 

Thank you so much. Worked perfectly. Appreciate that.

 

Cheers,

Sri

Labels