Skip to main content
  • EN

Hi there,

 

I have a spreadsheet where I need to replace a string of text. I have attached the spreadsheet with the original text and what I would like to replace it with. I'm having trouble coming up with the correct syntax in the 'Text To Replace' in the 'Parameters' dialog box.

 

I can get the first string to replace but not the second. Please see attached screenshots.

 

Thank you and have a nice weekend 🙂

I would try instead StringPairReplacer as it looks like the workflow is just replacing a paired fixed list of input substrings with a fixed list of replacement substrings.

Thanks, @bwn​. I tried StringPairReplacer and it did exactly what I wanted.

Reply


Community Stats

30,189
Posts
114,584
Replies
37,854
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.