Please see below
Hope this helps
If this solve the need please mark it as solved, it will help others,
Attached the workflow,
Regards
Hey - that deletes the text before and after but not the ID number in between.
Any updates on this @emiafshar ?
Apologies for the delay in getting back to you - the formula didn't work unfortunately. Output is the same as the input.
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.