How to eliminate multiple characters from a string in Code by Zapier?

Other Questions Zapier
1

I need assistance in removing several characters from a string that contains phone numbers. The data I’m working with is as follows:

1 305-267-2700, 1 305-762-3890, 1 786-728-3885, 1 305-567-9589, 1 786-619-7070, 1 786-316-3187,

In this string, there may be a ‘+’ symbol, spaces, or dashes that I would like to get rid of or replace with nothing. Specifically, I want to eliminate the following characters:

  • +
  • -
  • (space)

Since Zapier supports JavaScript and Python, which code snippets should I use to achieve this? As I’m new to this, I would appreciate any guidance on how to correctly implement this in Zapier.

2

To clean up your string in Zapier using JavaScript, one straightforward method is to use the .replace() function with a regular expression. Here’s a simple example:

let phoneNumbers = "1 305-267-2700, 1 305-762-3890, 1 786-728-3885, 1 305-567-9589, 1 786-619-7070, 1 786-316-3187,";
phoneNumbers = phoneNumbers.replace(/[+\-\s]/g, '');
console.log(phoneNumbers);

This code removes all instances of ‘+’, ‘-’, and spaces from the string. The replace method uses a regular expression to match any of the specified characters and replaces them with an empty string, effectively deleting them. This script would work well in Zapier’s Code by Zapier feature, making it a viable solution for your problem.