hello, what would be the best approach to split product Code in two fields, using “_” as separator?
Thank you.
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/36256
@Claudiu159 One way of doing this with regex replace function
@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.
Text To Columns
