Systematic Community

klandry · ‎06-27-2024

I am creating CSV files (technically TAB delimited) using Compose CSV. I am using a List for the source.
I have the option to Force Quotes Set to NO, yet for any fields where I am not supplying a value (as they are not required), double quotes are being inserted.

This does not seem to be correct to me as I should be able to have no values between delimiters without Quotes.
eg: 1 000[TAB]102095[TAB][TAB]DP[TAB][TAB]March

Instead, I am getting this:
1000[TAB]102095[TAB]""[TAB]DP[TAB]""[TAB]March

shivakumara · ‎06-28-2024

Hi @klandry ,

We have found a solution to the problem you are having. The problem comes from the array values you pass to create the CSV.
1. If the field value is empty, ""(double Quote) problem occurs because the empty value is called "" (double quotes).
In this case, we operate differently at the source or target level.

Example: 1000 NoValue 102095 NoValue DP

In this case you can use Value.present?? Value: skip

Here is an example of a recipe screenshot. Please check it out and let me know if you need help..
CSV data_1.png CSV data_2.png CSV data_3.png CSV data_4.png

View solution in original post

shivakumara · ‎06-28-2024

Thank you for the confirmation @klandry and have a good day.

Systematic Community

CSV file includes quotes