Required Text from the Sentence

[Srawat]

Hi,

I want to extract a specific short sentence from the long sentence like this between REF to B/O text can be different for example pls refer below. I have  more scenario between REF to B/O. please advise how I can extract. pls refer the result i needed. 

Description		Required result
2022 11978 1 142;YOUR REF=2022 11978 1;B/O CUSTOME		REF=2022 11978 1;B/O
JUNE INVOICES 158;YOUR REF=88 JUNE INVOICES;B/O CU		REF=88 JUNE INVOICES;B/O
2022 12904 1 142;YOUR REF=2022 12904 1;B/O CUSTOME		REF=2022 12904 1;B/O
1000160739 142;YOUR REF=1000160739;B/O CUSTOMER=FR		REF=1000160739;B/O
FOUR MSA 142;YOUR REF=FOUR MSA;B/O CUSTOMER=GB10HB		REF=FOUR MSA;B/O

Thanks, 

[Felipe_Ribeir0 · Accepted solution]

Hi @Srawat 

One way of doing this

If the provided answer helped you to solve the problem/was correct, please accept it as a solution :)

Thanks.

[Srawat]

Thank you so much!