multiple delimiter in text to column tool

[Sshasnk]

Hi I want to split a string into multiple row but I have more than one delimiter to split it, The Split criteria is Space and "_"  (I am trying to do with one text to columns because there could be multiple delimiters except these two)

String

YE 2023_12 Marry

the above one should be split like below

String

YE

2023

12

Marry

[binuacs]

@Sshasnk one way of doing this

[ShankerV]

Hi @Sshasnk 

There is only way as @binuacs shared using Text to Columns tool.

Please use the \s_ as the delimiter. 

\s - White space

\t - Tab

\n - New line

Hope this helps!!!!

Many thanks

Shanker V

[grazitti_sapna]

Hey Sshasnk

You can refer below workflow.