Help with RegExReplace Topic is solved

[Bad husband]

hi, need help in removing two words in a sentence

string := 223344-OPERATIONS 21X700 (Line A)

need to remove OPERATIONS and (Line A)

final result should be 223344- 21X700

The sentence will always start with 6 digits and have a hyphen, but the word OPERATIONS could be short form OPER and the word in the brackets could also be short as well - (LNA) or (LA).

So maybe a rule to remove the word after the hyphen and then the end of the sentence with the brackets?

thanks for reading and helping

[AlphaBravo]

Code: Select all

string := "223344-OPERATIONS 21X700 (Line A)"
MsgBox % RegExReplace(string , "^\d{6}-\K\w+|\([^()]*?\)$")

[Datapoint]

final result should be 223344- 21X700

The sentence will always start with 6 digits and have a hyphen, but the word OPERATIONS could be short form OPER and the word in the brackets could also be short as well - (LNA) or (LA).

So maybe a rule to remove the word after the hyphen and then the end of the sentence with the brackets?

This should basically do what you are describing. Start with six digits, ignore the next word, then get a space and anything up to the (, then ignore the rest of the line.

Code: Select all

MsgBox % RegExReplace("223344-OPERATIONS 21X700 (Line A)", "^(\d{6}-)\w+(\s.+)\(.+", "$1$2")

https://regex101.com/r/6Rp7gB/1

[Bad husband]

both work for my needs

Thanks for your help