vinnyuk 1 Posted January 8, 2017 Report Share Posted January 8, 2017 Hi Ubot Forum Does anyone know a quick fix for this issue? I have a csv file where some of the content is separated with commas So when using the import table from file function some of the data ends up in the wrong columns Does anyone know of a quick fix for issues like this? Quote Link to post Share on other sites
pash 504 Posted January 8, 2017 Report Share Posted January 8, 2017 upload your sample csv file Quote Link to post Share on other sites
Code Docta (Nick C.) 638 Posted January 8, 2017 Report Share Posted January 8, 2017 If you are in Europe your system default delimiter may need to change. or If you have a cell with commas in it they will be separated as well and you would need to use quotes around that data string. "I like to use Facebook, Twitter, G+ and Pinterest"or You may need to change the "Table Delimiter" in "Bot Properties". In the menu bar between View and Tools is a "Bot" button is where you will find the above. Regards,CD Quote Link to post Share on other sites
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.