Hi, I would like to save my test.csv with a semicolon as field-delimeter.
Currently looks like this:
Should look like this:
Found nothing within that documentation. Can someone help me out?
asked Aug 14 '14 at 16:00
The CSV object has a Delimiter property - maybe this will do what you need?
From the ActiveX documentation:
Delimiter As String The character that separates fields in a record. It is a comma by default. If the Delimiter property is not explicitly set, the CSV component will detect the delimiter when loading a CSV. (Semicolons are typically used in locales where the comma is used as a decimal point.)
answered Aug 14 '14 at 20:42