Devart Forums

Why would CSV (COMMA separate value) file default to a semicolon as the delimiter. Is there any way to change the default for import/export as CSV?

This can be setup in the 'Field separator' section of the 'Options' page of the Data Import/Export wizard.

I think what he is saying is that the DEFAULT setting for CSV is the semi ; not the comma , which makes more sense. I have been using the import wizard a lot and it's odd that the out of the box default setting is not the comma.

Their is a way to load a template for the wizard but have never quite figured out how to make the default settings for the wizard change, not sure if that is the intent of the template on the wizard...

So the question is how to set the default settings such as delimiter for the import wizard?

Sandy

This setting can be saved into a *.dit data import template file for future use. For this, please select the 'Comma' radio-button on the 'Options' page of the Data Import wizard and click the 'Save Template' button at the bottom left corner of the wizard.

Next time you perform data import, you have to select the previously saved *.dit file on the 'Source file' page of the Data Import wizard and complete the wizard as you normally do.

Thanks Alexa - I will give that a shot!