Hi @John_Appleton ,
If I well understand your problem: you want to replace a substring (e.g., “newdoc”) by nothing in a string (e.g., “newdoc John Testing”) giving with the given example “John Testing”.
There are to way to do this:
- one using “replace” text function:
- the other using the text parser:
Here is the blueprint I used for testing:
Trying to Replace text with nothing.json (9.6 KB)
PBI