Text between string

Help
1

Hello,
I have a cell with group of string. I want to extract a particular text which is dynamic but is surrounded by statis text. How do i get that dynamic text??

Example:
Company: IBM Value:100
Company: TCS Value:100
I need the valu IBM and TCS from above text.
Thank you

2

Assign String
MyText = "Company: IBM Value:100"

Assign String
Pattern = "Company: (?<company>\w+) Value"

Assign Match
Match = System.Text.RegularExpressions.Regex.Match(MyText, Pattern)

Assign String
Company = Match.Groups("company").ToString

image

3

varMatch = Regex.Match("Company: IBM Value:100","(?<=Company: )(.*?)(?= )"),RegexOptions.IgnoreCase)

IF varMatch
varMyCompany = varMatch.Value