Export delimited text ""

[captnk]

I am having a problem exporting in the manner I need.
Fields with a value are exported as:
"name","make","etc",
However where I have an empty text field it is seperated only by a comma:
"name", , ,"make",
I need to get the empty text field to read as follows
"name","","","make",
How can I get the exclamation marks to appear in the exported text file
Tks
Captnk

 

[jeremie_ingram]

The "" are only text identifiers in the output. The , is the actual delimiter. If you have one , for every field, then you have everything represented.

If the records contain the fields
AGE
FName
LName

Then your records should export as

39, "John", "Doe"
,,"Smith"
,,"Allen"
24, "Jim",

Anywhere you have ,, represents and null field. If you TRULY need the "" to appear, change the default value of the fields to "" rather than Null.