I’m having difficulties with the text split by a comma the output when I test the zap is split but when I select the “text” output later in the zap it goes back to the full string and not the substring . Pictured below :
This post was edited by a moderator to remove personal information from the images. Please be careful not to share private information as this is a public Community.
Best answer by steph.n
View originalI am having this issue as well. Have you been able to fix it?
I am having this issue as well. Have you been able to fix it?
Yeah i basically just used python code step instead I can send you my code if you want
+8
Mod Edit: 03-21-2022
Hello
The screenshot that you shared shows that the information is in a list - which means that it’s line items. Line items look the same as text with commas in the Zap editor, but they are actually information that’s organised in a specific way. You’ll need to convert the line items to normal text before you can use the split text step.
To do that, add a step in the Zap before the Formatter split text step and choose the Formatter again. Choose the Utilities > Line item to text option and put the HubSpot field as the input to the step. When you test and review that step, the Text field that it outputs will contain what looks like line of text with commas in it.
Then take that output from the Formatter (Line item to text) step and plug it into the Formatter (Split Text) step as the input, set a comma “,” as the Separator and that should split your text the way that you need it 
Please let us know if this worked for you. Thanks!
Same issue here.
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
