Hello,
I have a form that collects a series of notes which is then passed to Zapier to upload to our CRM via an API. This works well until the notes contain certain characters such as “ / *.
The notes are broken down into multiple fields, eg. General Notes, Exercise Notes, Strategy Notes, etc...
Is it possible to have zapier filter multiple fields for these characters or do I have to use a find/replace formatter for each one.
Appreciate any help and happy to provide further details if needed.
Best answer
How can I filter out special characters in multiple fields using Zapier for CRM data upload?
- Beginner
Best answer by GetUWired
You could use a Zapier code block, this example is JavaScript. The code uses regular expressions to remove special characters from a text string. Modify the regex string to fit your needs.
// Input Data
const bodyTxt = inputData.bodyTxt;
// bodyTxt contains "Hello / what are * you doing? .. What .."
//Regular expression to remove special characters (excluding spaces)
let regex = /[^a-zA-Z0-9\s]/g;
let modTxt = bodyTxt.replace(regex, '');
output = [{bodyTxt: bodyTxt, modTxt: modTxt}];
bodyTxt
Hello / what are * you doing? .. What ..
modTxt
Hello what are you doing What
Zap Support
GetUWIred
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.
+12- Zapier Solution Partner
- Answer
You could use a Zapier code block, this example is JavaScript. The code uses regular expressions to remove special characters from a text string. Modify the regex string to fit your needs.
// Input Data
const bodyTxt = inputData.bodyTxt;
// bodyTxt contains "Hello / what are * you doing? .. What .."
//Regular expression to remove special characters (excluding spaces)
let regex = /[^a-zA-Z0-9\s]/g;
let modTxt = bodyTxt.replace(regex, '');
output = [{bodyTxt: bodyTxt, modTxt: modTxt}];
bodyTxt
Hello / what are * you doing? .. What ..
modTxt
Hello what are you doing What
Zap Support
GetUWIred
+11- Community Manager
That’s fantastic news
Please do reach back out in Community again if you need any further help at all. In the meantime, happy Zapping! ⚡
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.