Search and find in a string of text

[Dojorgen]

Hey guys hoping you could help me out with this:

String of text:
'CMD/A="RES_ACTIVATE" MID/A="vfei2W0206" MTY/A="C" TID/U4=373 TYPE/A="RECIPE" RES_ID/A="E.299.30" PORT_ID/B=1 MBC_ID1/A="419253901.000" MBC_ID2/A="BLANK"'

Search for:
Line of text looking to pull search for "RECIPE"

If true then results:
then results the "E.299.30"
and next column "419253901.000"

 

[jtakw]

This should handle more than enough extractions based on your most recent description, tested up to 5 extractions.

Assuming data starts at A1, formula in B1 copied down and across as far as needed:

Book1
	A	B	C	D	E	F
1	CMD/A="RES_ACTIVATE" MID/A="vfei2W0206" MTY/A="C" TID/U4=373 TYPE/A="RECIPE" RES_ID/A="E.299.30" PORT_ID/B=1 MBC_ID1/A="419253901.000" MBC_ID2/A="BLANK"	E.299.30	419253901.000
2	CMD/A="RES_ACTIVATE" MID/A="vfei2W0206" MTY/A="C" TID/U4=419 TYPE/A="RECIPE" RES_ID/A="E.242.50" PORT_ID/B=2 MBC_ID1/A="BLANK" MBC_ID2/A="419260011.000"	E.242.50	419260011.000
3	CMD/A="RES_ACTIVATE" MID/A="vfei2W0206" MTY/A="C" TID/U4=419 TYPE/A="RECIPE" RES_ID/A="E.242.50" PORT_ID/B=2 MBC_ID1/A="BLANK" MBC_ID2/A="BLANK"	E.242.50
4	CMD/A="RES_ACTIVATE" MID/A="vfei2W0206" MTY/A="C" TID/U4=419 TYPE/A="RECIPE" RES_ID/A="E.242.50" PORT_ID/B=2 MBC_ID1/A="419253901.000" MBC_ID2/A="419260011.000"	E.242.50	419253901.000	419260011.000
5	CMD/A="RES_ACTIVATE" MID/A="vfei2W0206" MTY/A="C" TID/U4=419 TYPE/A="RECIPE" RES_ID/A="E.242.50" PORT_ID/B=2 MBC_ID1/A="419253901.000" MBC_ID2/A="419260011.000" MBC_ID3/A="012345" MBC_ID4/A="678901"	E.242.50	419253901.000	419260011.000	012345	678901
Sheet325 (2)

Cell Formulas
Range	Formula
B1	=IFERROR(TRIM(MID(SUBSTITUTE(SUBSTITUTE(REPLACE($A1,1,SEARCH("Recipe",$A1)+6,""),"""BLANK""",""),CHAR(34),REPT(" ",255)),(COLUMNS($B1:B1)+COLUMNS($B1:B1)-1)*255,255)),"")

 

[jtakw]

Silly me...just a bit shorter:

Book1
	A	B	C	D	E	F
1	CMD/A="RES_ACTIVATE" MID/A="vfei2W0206" MTY/A="C" TID/U4=373 TYPE/A="RECIPE" RES_ID/A="E.299.30" PORT_ID/B=1 MBC_ID1/A="419253901.000" MBC_ID2/A="BLANK"	E.299.30	419253901.000
2	CMD/A="RES_ACTIVATE" MID/A="vfei2W0206" MTY/A="C" TID/U4=419 TYPE/A="RECIPE" RES_ID/A="E.242.50" PORT_ID/B=2 MBC_ID1/A="BLANK" MBC_ID2/A="419260011.000"	E.242.50	419260011.000
3	CMD/A="RES_ACTIVATE" MID/A="vfei2W0206" MTY/A="C" TID/U4=419 TYPE/A="RECIPE" RES_ID/A="E.242.50" PORT_ID/B=2 MBC_ID1/A="BLANK" MBC_ID2/A="BLANK"	E.242.50
4	CMD/A="RES_ACTIVATE" MID/A="vfei2W0206" MTY/A="C" TID/U4=419 TYPE/A="RECIPE" RES_ID/A="E.242.50" PORT_ID/B=2 MBC_ID1/A="419253901.000" MBC_ID2/A="419260011.000"	E.242.50	419253901.000	419260011.000
5	CMD/A="RES_ACTIVATE" MID/A="vfei2W0206" MTY/A="C" TID/U4=419 TYPE/A="RECIPE" RES_ID/A="E.242.50" PORT_ID/B=2 MBC_ID1/A="419253901.000" MBC_ID2/A="419260011.000" MBC_ID3/A="012345" MBC_ID4/A="678901"	E.242.50	419253901.000	419260011.000	012345	678901
Sheet325 (2)

Cell Formulas
Range	Formula
B1	=IFERROR(TRIM(MID(SUBSTITUTE(SUBSTITUTE(REPLACE($A1,1,SEARCH("Recipe",$A1)+6,""),"""BLANK""",""),CHAR(34),REPT(" ",255)),(COLUMNS($B1:B1)*2-1)*255,255)),"")

Same description as Post 11 above.

 

[Dojorgen]

great thank you works great

 

[jtakw]

You're welcome.