multiple delimiter in text to column tool

Question

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)

StringYE 2023_12 Marry

the above one should be split like below

StringYE202312Marry

grazitti_sapna · Answer

Hey Sshasnk

You can refer below workflow.

Text To column.yxzp

ShankerV · Answer

Hi @Sshasnk

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

Please use the \s_ as the delimiter.

\s - White space

- Tab

- New line

Hope this helps!!!!

Many thanks

Shanker V

binu_acs · Answer

@Sshasnk one way of doing this