Find a full string from the substring

[michaelcash]

Hi

I have given string and substring.

• I need to mach substring to the string and print full word.
• Then add one word before and after the match

String	Substring	Match	+1 right word	+1 left word
Adam Robert Emil Kamil	t em	Robert Emil	Robert Emil Kamil	Adam Robert Emil
Big Platform SA	Platform	Platform	Platform SA	Big Platform
The Big Island	Isla	Island	Island	Big Island
The Group Holding SA	up Hold	Group Holding	Group Holding SA	The Group Holding
Karina Marina Marianna	Marianna	Marianna	Marianna	Marina Marianna

Thanks for you help

[binuacs]

@michaelcash 

[michaelcash]

Hi

Thanks for response.

I think i was not fully clear.

I have only two columns:

String	Substring
Adam Robert Emil Kamil	t em
Big Platform SA	Platform
The Big Island	Isla
The Group Holding SA	up Hold
Karina Marina Marianna	Marianna

Additional columns are just to show the output so I can't use Find/Replace

Match has to be created on finding full word in String based on partial words in Substring

e.g. for the row nr 1, algorithm has to find the pattern and then find the full words around this pattern: Robert Emil

[Jonathan-Sherman]

Hi @michaelcash,

I thought i'd avoid the batch macro route and instead go down the Dynamic Replace tool path:

I've attached my workflow for you to download if needed!

Kind regards,

Jonathan