Set the input to a list of phone numbers obtained from Salesforce, as shown below. At this point, there is a comma in the value, like “,,,090-0000-4444,090-0000-1111”.
When you go to the next step and try to execute, the comma will be missing from the value.
Is there any way to treat this as data with commas?
Best answer by SamBBest answer by SamB
Hey @Suzuki 👋
It seems that part of the issue is that the commas that appear aren’t really there, they’re just how line items are visually separated in the Zap editor. And the other part is that with Formatter, null (empty) line items are ignored which is why you’re only seeing two values separated by a & in that Output Text field.
There was a workaround shared in the Community a while back that should allow you to convert those empty line items into a &:
It seems that part of the issue is that the commas that appear aren’t really there, they’re just how line items are visually separated in the Zap editor. And the other part is that with Formatter, null (empty) line items are ignored which is why you’re only seeing two values separated by a & in that Output Text field.
There was a workaround shared in the Community a while back that should allow you to convert those empty line items into a &:
It seems that part of the issue is that the commas that appear aren’t really there, they’re just how line items are visually separated in the Zap editor. And the other part is that with Formatter, null (empty) line items are ignored which is why you’re only seeing two values separated by a & in that Output Text field.
There was a workaround shared in the Community a while back that should allow you to convert those empty line items into a &: