29
Views
2
Comments
Solved
[SQL Sandbox] CSV Export of Text Values that include comma
Question
Forge component by Leonardo Fernandes
17
Published on 24 Aug 2020

Very useful component!

One issue we discovered was that when a text value contained a comma, the CSV export would not render properly in Excel because the comma was treated as a field delimiter.

The solution was to wrap the Text Value in double quotes in the ExportCsv action of the Execute screen. 

Here's a screenshot of the change. Hope it helps.

mvp_badge
MVP
Rank: #24
Solution

Done! ;)

mvp_badge
MVP
Rank: #24

Hey Charles, sorry about the late reply here.

Thank you very much for your feedback. I will be publishing a new version soon with this fix.

mvp_badge
MVP
Rank: #24
Solution

Done! ;)