Is anyone can help me to remove default comma in the output? And change it to newline without using code or replace. Because most of the output is number, so I need to remove the default comma in the first place of the string.
Remove specific commas from list
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.
Userlevel 7
+11
- Community Manager
- 4542 replies
-
31 March 2023
Hey
You’d likely still need to use a Code by Zapier or Formatter (Text > Replace) action here to convert the commas into newlines. But for Formatter you’d want to add an additional character to the Find field so it’s able to find a match on just the first instances of the commas. For example if there was always a space character prior to the comma you could use “ ,” instead of just “,” so it doesn’t replace every comma.
That said, where are those commas being added? Are they added in Quickbooks or PandaDoc directly, or is there an action within the Zap itself that’s adding them? It may be that you can tweak the settings in the apps directly or in the Zap to remove those unwanted commas. Do you think that could work?
Looking forward to hearing from you!
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.