Delete all words up to a certain string, etc

[NavyFederalDetta]

I would like to delete all words up to the word "Barcode" and after the 6 digits that follow.
Ex:

"text string describing equipment
BARCODE 123456

Used for description of items"

I have been playing with this formula:

Replace ({POLN.FREEFORM},"BARCODE","")

Obviously it needs an "Upto" command of some sort then an "after" command.
This is a freeform field so the data will almost always be different.

Thank you!!

 

[synapsevampire]

Rather than delete, extract, as in:

mid({table.field},instr({table.field},"Barcode"),14)

-k

 

[NavyFederalDetta]

Thank you!! this was perfect:

if "BARCODE" in {POLN.FREEFORM}
then mid({POLN.FREEFORM},instr{POLN.FREEFORM},"BARCODE"),14)
else ""

Then, I used that formula (@Barcode)to write a second:

right ({@Barcode},6)

This gives me just the 6 digit barcode number.
I was definitely on the wrong track and you steered me right.

Thanks again!!!