splitting a column in 2

[Claudiu159]

hello, what would be the best approach to split product Code in two fields, using “_” as separator?

Thank you.

[MilindG]

You have several options to do that but take a look at the workflow. I used Text to column tool which prob is the easiest.

Below is more info on the Text to column tool

https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Tool-Mastery-Text-To-Columns/ta-p/3...

[binu_acs]

@Claudiu159 One way of doing this with regex replace function

[Emmanuel_G]

@Claudiu159 

The text to columns tool allows you to achieve to this result easily.

Please do not hesitate to mark this answer as solution if helped.

[pmyers]

Text To Columns