Prevent a sentence with commas from getting separated during formatting
Hi Everyone,
I have table data that I pull from Kintone into Zapier to put into an email I build to notify certain users. In that table is a text area field where the user can enter Customer Impact. Now the user may enter a sentence that has commas in it. Now when I do my formatting to allow to build that table in HTML email, the Impact customer gets caught up and it will split sentence in to line items during the formatting.
How do I prevent a sentence with commas in from getting split up into line items during the formatting stage?
In this example I do not want the Impact Customer sentence test, test1 ,test2, test3 to get split up during formatting. Do I need to do something before this stage to tell zapier not to split the sentence into line items.
Page 1 / 1
Hi @ENUSA
Can you post screenshots showing an example of what you are trying to prevent from for the output of the Zap step?
Hi @Troy Tessalone,
Sure. I have 2 tables in Kintone, I’m basically taking those tables and using the Microsoft 365 step building HTML emails that have those tables in the email. During testing when I created a sentence in the Customer Impact field and added commas to the sentence, they current way I am formatting the table data it will create the Customer Impact into Line items, so currently I am getting this situation because of the delimiter comma.
You can see how on the first line after the Impact to Customer it pushes Inquire to QAS and Damage Noted down a line do to my current setup. I would like Impact to Customer to stay intact with commas if the user puts them in the sentence abut still be able to build the table. I was playing around with formatting and just cant seem to get it to work correctly. It either does the above(or worse) or
This was from my original zap and it was working great until I put commas in the sentence. As you can see it is taking the sentence and breaking it out to line items (as that function does) but I need to put somewhere telling the zap that I do not want the sentence broken out into line items
This causes this to happen (note exactly the above I added more commas to a sentence for testing but the idea is the same)
Thank you for any suggestions you may have.
@ENUSA
One option would be to do something like this logic...
For the Impact to Customer data, replace all commas with something like: ^
Use this Zap action: Formatter > Text > Replace
Then convert the line items to text.
Lastly, replace all of the ^ with , to get back to the original format.
Hi @Troy Tessalone ,
Sounds like a solid plan. I will give that shot. Thank you.
Hi @ENUSA,
Just keep us on the loop so we can assist you further if needed. Thank you.
Hi All @JammerS
@Troy Tessalone recommendation worked very well. I was able to convert the commas in the sentences to ^ then run my formatters to make the table data for the email and then convert the sentences back to have commas. It is working great! Thank you!
Wow! Thank you for confirming that Troy’s resolution got the Zap running. This will significantly help our Community members to have as a reference for the same issue.
