Setting CSV files separator. BMS is failing with CSV imports, CSV files have semi-colons instead of commas

Created by Greg Lock - Innovative Solutions, Modified on Fri, 10 Oct at 12:24 AM by Greg Lock - Innovative Solutions

Product: Excel, BMS


Problem: CSV files are not delimiting with a comma, instead a semi-colon is used which is causing import issues into BMS.


Possible causes: The computers Region settings are applying the semi-colon as the delimiter.


Solution: Change the List Separator and Decimal symbol under Region Settings. Following this article: https://www.ablebits.com/office-addins-blog/change-excel-csv-delimiter/



Innovative Solutions

www.innovativesolutions.co.za

support@innovativesolutions.co.za

+27 61 542 7262


Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article