Remove words if certain words in field
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Please see below
Hope this helps
If this solve the need please mark it as solved, it will help others,
Attached the workflow,
Regards
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hey - that deletes the text before and after but not the ID number in between.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Any updates on this @emiafshar ?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Apologies for the delay in getting back to you - the formula didn't work unfortunately. Output is the same as the input.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @emiafshar, The formula provided was close, but it was missing a non-greedy indicator (?), which works like "until" in this case. I also added a $ to the end of the find string as this indicates the end of the line being evaluated. Without the $ record 6 would display the word "version" instead of being blank as the find string would only delete through the first instance of "version" and not the last. Let us know if this works.
