Find a full string from the substring
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
michaelcash
5 - Atom
‎12-29-2021
07:20 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
Labels:
- Labels:
- Regex
3 REPLIES 3
binuacs
21 - Polaris
‎12-29-2021
08:44 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
‎12-29-2021
11:31 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
15 - Aurora
‎12-30-2021
02:49 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
