Hi I have pulled Shopify customer tags as a list into Zapier separated by commas. I would like to remove items from the list that starts with “fbn”. The order of the items in the list will vary per customer along with the number of items in the list.
So for example I have Shopify tags like this:
blue, large, fbn01, hat
With Zapier how can I remove fbn01 by searching the string for fbn.
Thanks
Best answer by Troy Tessalone
View original
+6
Hi there
Welcome to the Community! 🎉
You can add a Text in Formatter by Zapier - Replace function to remove the “fbn” data in your tags. The setup will look like this:
Here’s the output:
Hopefully, this helps! 😊
+14
Hi
Good question.
You can use a Code step for this: https://zapier.com/apps/code/help
Some guidance:
Thanks Ken.a and Troy! I was trying to exclude items that contain the string so Ken.a’s method didn’t work for that. But ended up finding Troys article here which worked great.
So final code is:
let Set = inputData.Set.split(","); // creates array by splitting Input Data Variable at commas
let FilterBy = inputData.FilterBy; // value to filter the array by
Set = Set.filter(i => !i.includes(FilterBy)); // use ! EXCLUDE values in array
output = [{Set}];
+6
That’s great news
Also, thank you for sharing the code this will be helpful to our other Community members who might run into a similar issue.
If you have any other questions, please don’t hesitate to reach out. We’re always happy to help! 😊
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.