Get String before space

[Vishwanth_Raya (Akhil)]

I have a string
1.CAC - K - 40 Er Match 100.17
2.CC - X0 - 41k Max Eli/c 2,504.32

I need the output as below.

1.CAC - K - 40 Er Match
2.CC - X0 - 41k Max Eli/c

Found it has three spaces between.
I have tried split but its not working, any suggestions.

[Anthony_Humphries]

The strings you want can be retrieved using the following, where MyText is your string:

System.Text.RegularExpressions.Regex.Matches(MyText, ".*-.*-.*(?=\s\d)")

This will contain each of your parsed strings and can be iterated over using a For Each activity.

[Ashish_Verma]

@Anthony_Humphries

.-.-.*(?=\s\d)

How do we learn to create regex expression?

[Anthony_Humphries]

A great resource is rexegg.com, and you can test your regexes at regex101.com.

[Ashish_Verma]

Thank you