How can I get text a before a certain string of word?

[Shaira_Janine_Torio (Shaira Torio)]

Hello guys, I need some help.
How can I get text a before a certain string of word?
For example,

“BOP AUTO STATUS” and the answer is “BOP”
“BCRC PER WRITE AUTO STATUS 06042020” and the is answer “BCRC PER WRITE”

I already found the answer in this topic How can I get text after certain string of word...can anyone help in this regard - #3 by saneeth_kandukuri

But Idk how to modify the IndexOf. Also, I can’t reply to the related topic bc it was closed.

[Yoichi]

Hi,

Can you try the following expression?

System.Text.RegularExpressions.Regex.Match(strData,".*(?=\s*AUTO STATUS)").Value

Regards,

[Pradeep_Shiv]

@Shaira_Janine_Torio

“BOP AUTO STATUS” and the answer is “BOP”
“BCRC PER WRITE AUTO STATUS 06042020

.*(?=AUTO STATUS)

you can try this!
@Shaira_Janine_Torio

[Shaira_Janine_Torio (Shaira Torio)]

It’s working! Thank you so much

[Shaira_Janine_Torio (Shaira Torio)]

This is also working! Thank you so much!

[Steven_McKeering]

@Shaira_Janine_Torio

BOP AUTO STATUS

Save this link for next time regex101: build, test, and debug regex

Regex101.com is a great place to test out and understand Regex solutions especially when changing to suit your needs

[Shaira_Janine_Torio (Shaira Torio)]

Noted on this. Thanks!