We use the report results export via API quite often. We have some users who want fields that include text delimiters in the field value. Fields like issue summary, issue labels or issue last comments.
What is the best way around this? Can I set the delimiter to something else? Can change the column format to “ignore” the text delimiters?
Hey @Chuckcox12
Could you please provide some details?
I just tried with the latest eazyBI version using the report results export API to export a table report with an issue summary (with a comma inside of text) to a CSV file.
Attachments below.
The field values with commas were put inside double quotes " in the exported file, which means eazyBI knows how to handle these values. So there shouldn’t be problems with default delimiter (comma).
What delimiter would you want to use, and what is the exact use case?
Martins / eazyBI
Hey Martins! Always good to hear from you. Yes, you are correct. I didn’t think to check the csv file as a text file. EazyBi is handling this correctly. Keep on rocking on!!