Want to extract specific sentence from long sentence

[Srawat]

Hi,

I want to extract from REF to B/O sentence from the below sentence. Between REF to B\O text and numeric can differ as per below example. I have more scenario. Please advise how I can get as per required result. 

Thanks,

[DataNath · Accepted solution]

@Srawat with the Regex tool in Parse mode you could try something like:

(REF=.+B\/O)

I've tested it on a quick string that I mocked up as you only provided a screenshot rather than actual data.

[JamesCharnley · Accepted solution]

Hi @Srawat,

If you always need to capture whatever is between REF and B/O, you should be able to use Regex to tokenize on the expression REF.*?B\/O , which will find the instance starting in REF and ending in B/O, capturing everything in between.

[Srawat]

Thanks Both. Working fine with both.