Splitting a text in two 4 parts.

[sriniprad08]

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

[ShankerV · Accepted solution]

Hi @sriniprad08 

One way of doing this.

Many thanks

Shanker V

[ShankerV]

Hi @sriniprad08 

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

Many thanks

Shanker V

[sparksun · Accepted solution]

[sriniprad08]

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

[ShankerV · Accepted solution]

Hi @sriniprad08 

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

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

Many thanks

Shanker V

[sriniprad08]

Hi @ShankerV ,

Thank you so much. Worked perfectly. Appreciate that.

Cheers,

Sri