In order to match a string I need to add spaces to my incoming search string. When I use Formatter:Replace and [:space:] it seems to trim the spaces away. Her is my Formatter action:
And here are my results:
Thanks for any help.
BK
Best answer
How do I add spaces between words using Formatter?
- Beginner
Best answer by christina.d
Hi 
Thanks so much for reaching out and sharing those details.
I did some digging and it looks like you’re experiencing a known bug with the Formatter app, specifically where Split Text isn’t working with [:space:] Separator 
. I don’t have an ETA for a fix at the moment, but I did add you as an affected user! This will ensure you’re emailed once a solution is available. We’ll also be sure to keep the thread updated as well.
Thanks again for flagging this and welcome to the Community!
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.
- Beginner
I also tried Javascript replace but I got the same results. Something keep taking away my leading and trailing spaces:
+9- Zapier Staff
- Answer
Hi Thanks so much for reaching out and sharing those details.
I did some digging and it looks like you’re experiencing a known bug with the Formatter app, specifically where Split Text isn’t working with [:space:] Separator . I don’t have an ETA for a fix at the moment, but I did add you as an affected user! This will ensure you’re emailed once a solution is available. We’ll also be sure to keep the thread updated as well.
Thanks again for flagging this and welcome to the Community!
+9- Zapier Staff
Totally valid question,
+14- Zapier Orchestrator & Solution Partner
A commonly used entity in HTML is the non-breaking space:
Try this JavaScript Code:
let Term = inputData.Term.replace(/ near /i," near ");
output = [{Term}];
- Beginner
Thanks for your suggestion Troy. But it didn’t work as expected: My results is
Term
Bank near me. Below is my configuration:
+14- Zapier Orchestrator & Solution Partner
That is the expected output: Bank near me
A commonly used entity in HTML is the non-breaking space:
Have you tried using the output value in your next action step?
- Beginner
Sorry Troy. I should have known to do that. Since testing only pulls in one result and I need many I’ve turned it on and should know by late tomorrow morning. I will update you then. Thank you.
+14- Zapier Orchestrator & Solution Partner
How to change your test trigger data: https://zapier.com/help/create/basics/change-the-test-data-in-your-zap-trigger
Can you elaborate about how you are trying to use the output in your next action step, that may help us have more context and advise about potential solutions.
- Beginner
Well it turns out that I didn’t need to do anything to remove the excess spaces in the targeted string. Zapier’s Filter removed them for me. So when a string with more than one space between the words is put in the Filter, the filter removes all but one. How about that for luck. Thanks everyone for their suggestions.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.