Parsing a csv-file

[JariV]

Sorry for asking a probably very basic question, but I' didn't find this simple case either in FMPro help or searching the forums.

I'm simply trying to manually parse a csv-file from a number of text, date, time and number fields.

I've tried a number of combinations around the field names, but haven't succeeded to get the "" 's around the values.

GetAsText(DateField1)&","GetAsText(TimeField1)&","GetAsText(NumberField1)&","&TextField1&","&¶

should produce something like (with correct prefixes)

"1.1.2009","12:30","8.5","Abc"

I've tried to put " and "" (among others) around the field names, but there is always something wrong with the result.

I'd be grateful, if someone could point out what I'm missing here.

JariV

[comment]

It seems you want to do the exact opposite of parsing, i.e. synthesize a .csv format. I am not sure why you would need to do this yourself, as Filemaker can export as .csv perfectly well.

In any case, you can try something like:

Let ( [

quot = """ ;

sep = quot & "," & quot

] ;

quot & DateField1 & sep & TimeField1 & sep & NumberField1 & sep & Substitute ( TextField1 ; quot ; quot&quot ) & quot

)