Quote from Vadim on July 2, 2021, 2:16 pm

@s7shanbe

Maybe I didn't understand the question. I usually use a vertical line as a separator. If you want to try a space, you could try using the special character [#32] instead of the obvious space character. But I haven't tried using a space as a separator.

Quote from s7shanbe on July 3, 2021, 6:18 pm

@vadim

I would use ; character As a separator.

Quote from Vadim on July 3, 2021, 6:24 pm

@s7shanbe

As far as I know, any separator should work. Do you have a semicolon as a separator that doesn't work?

Quote from s7shanbe on July 3, 2021, 6:58 pm

@vadim

Yes, exactly

semicolon as a separator that doesn't work.

Quote from s7shanbe on July 3, 2021, 7:18 pm

@vadim

test this Action:

dbpExportToCSV "db" "mems" "[pubDir]export.csv" "Range=All;Delimiter=;;IncludeFieldNames=No;ForceQuotes=Yes"

Quote from Vadim on July 3, 2021, 8:58 pm

@s7shanbe

Yes, it really is! I didn't know.
But you can easily get around that by making up any delimiter for a while (in my example &&&) and replacing everything automatically:

dbpExportToCSV "LAUNCH" "People" "[pubDir]export.csv" "Range=All;Delimiter=&&&;IncludeFieldNames=No;ForceQuotes=No"
FileToVar "[pubDir]export.csv" "[old]"
StrReplace "[old]" "&&&" ";" "[new]" ""
FileWrite "[PubDir]export.csv" "All" "[new]"

Quote from Gaev on July 4, 2021, 1:15 am

@s7shanbe
@vadim

The most likely reason Delimiter=; does NOT work is because the semicolon is also the delimiter for the various options in the third parameter ... try using the ascii value for semicolon i.e. [#59] ... like this ...

dbpExportToCSV "db" "mems" "[pubDir]export.csv" "Range=All;Delimiter=[#59];IncludeFieldNames=No;ForceQuotes=Yes"