Remove all content after FIRST special character

[LiamC]

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!

[messi007]

@LiamC,

Please see below:

Attached the workflow,

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

Regards,

[Qiu]

@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.

---

[pedrodrfaria]

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.