Using Regex need to Extract a string between 2 different delimiters without multicolumns

[sakshim]

I have a problem, I want to extract a string between 2 different delimiters preferably with regex and without creating multiple columns .

For example, I have a substring which is like  '"ACTO": IMPID-452673";" at any place in the sentence.

I just need to extract IMPID-452673 (Kindly note the length of numbers can be more or less ). In every sentence, IMPID is followed by ";"  , 2nd delimiter. 1st Delimiter is  ""ACTO":")

[binu_acs · Accepted solution]

@sakshim one way of doing this

[sakshim]

Many Thanks .... this is wonderful. also, Can I request for a reference to RegEX Table

[binu_acs]

@sakshim try https://regex101.com/, where you can test and learn regex

[sakshim]

This doesnt work if we  its in the middle of the sentence

[binu_acs]

Can give me a sample text