So I currently have a bunch of data coming from a woo commerce store, one of which is categories from the site which are all plural. I need to swap them out for the singular versions. what's the best way to do it?
Best answer
Removing plural words for non plural
- Beginner
Best answer by Troy Tessalone
Hi
Some options to try…
Formatter > Utilities > Lookup Table: https://zapier.com/help/doc/how-use-formatter-functions#using-the-lookup-table
Code step using the replace() function:
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.
+14- Zapier Orchestrator & Solution Partner
Hi
Can you post actual examples for us to evaluate and advise?
- Beginner
I have 5 categories on the website Monuments, Arenas, Maps, Lobbies and Prefabs I just need to swap them to arena, map, lobby and prefab. They are all inside the categories name input
+14- Zapier Orchestrator & Solution Partner
- Answer
Hi
Some options to try…
Formatter > Utilities > Lookup Table: https://zapier.com/help/doc/how-use-formatter-functions#using-the-lookup-table
Code step using the replace() function:
- Beginner
+14- Zapier Orchestrator & Solution Partner
Code step will be able to do the text transformations in 1 Zap step.
+14- Zapier Orchestrator & Solution Partner
If the only ‘s’ in your Category options is the last letter that makes each work plural, then you can try using this: Formatter > Text > Replace
- Beginner
The lookup table seems to be the best option, it lets me remove the capitals too, all in one step. Code probably would be the best option but I cant code.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.