Prevent a sentence with commas from getting separated during formatting

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.

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.