CSV - Decimal Question

Hello,

I am currently generating a csv file from a Qlik qvd.
During the transformation I should recognise if there is a comma number inside and then put this number under inverted commas.

QVD:
LNCompany,Unit,Description,Physical Quantity,Rounding Factor,ISO Code
1010,BA,Tonne (VPE),2,10,TNE
1010,BE,Bündel/Gebinde,2,0,001,

CSV
LNCompany,Unit,Description,Physical Quantity,Rounding Factor,ISO Code
1010,BA,Tonne (PU),2,10,TNE
1010,BE,Bündel/Gebinde,2,"0,001",

I have tried different variants.
Can you please give me a type?

Thank you
Thomas

Hi Thomas

There are multiple ways of doing it.
1 Quote all fields. this is the easiest option.
2 Use script calculation
3 Use contains transformation, this will quote field only if it has a comma inside.

Here is an example of contains transformation.

Thomas,

If you have any control over QLIK QVID output , at least from basic google search it seems there are options available , see 1st result

Your output will look like 
"1010","BE","Bündel/Gebinde","2,0,001"

You can then suggest text qualifier as Mike suggested
 

Thanks guys