Remove all content after FIRST special character

Question

Hi All,

I am trying to remove all content after the first special character (there are several '-' included in each string). For example:

6 - Craft Workers (EE - US-United States of America)

1.2 - Mid-Level (EE - IE-Ireland)

4 - Sales (EE - CA -Canada)

I just want to extract everything before the first dash.

Thank you for your help with this!

pedrodrfaria · Answer

Hi @LiamC

As @Qiu and @messi007  showed, you actually have many different ways of doing it. Text to Columns, Left + findstring function, substring function, even Regex if you feel like having some nerdy fun, etc..

I added below an example using the substring function:

Pedro.

Remove all content after FIRST special character.yxmd

Qiu · Answer

@LiamC 
It is easier when you say first Dash character.

Returns the 0-based index of the first occurrence of (Target) in (String). Returns -1 if no occurrence.

0107-LiamC.yxmd

messi007 · Answer

@LiamC,

Please see below:

Attached the workflow,

If this solves your issue please mark the answer as correct, it will help others!

Regards,

FirstDash.yxmd