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 by Troy Tessalone
View original
+14
Hi
Can you post actual examples for us to evaluate and advise?
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
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:
+14
Code step will be able to do the text transformations in 1 Zap step.
+14
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
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 username or e-mail address. We'll send you an e-mail with instructions to reset your password.
