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

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

)