[Solved] Convert LO .csv file to SQlite3.csv file

Discuss the spreadsheet application

[Solved] Convert LO .csv file to SQlite3.csv file

Postby pizzipie » Sun Nov 24, 2019 2:14 am

[SOLVED] Dumb me: I never did see that tiny box in the lower left corner that lets you edit the format of the csv file!!! Sorry.

Hi,

I have about 500 records , each with 37 fields, in an address book downloaded from 'thunderbird' in csv format.

The 'thunderbird.csv' needs processing before SQlite3 will work.

Problem I have is that the 'thunderbird.csv' file field separator is a comma and I have a lot of data that includes commas inside the field. I am trying to change the comma separator to a semi-colon with LO Calc with no luck. If, when I save the file, I try to change the separator field from comma to semi-colon the text goes from 37 fields to one long string for each row.

Like to know what am I doing wrong here so I can fix it.

Thanks, R
Last edited by RusselB on Sun Nov 24, 2019 3:09 am, edited 1 time in total.
Reason: Solved tag and green check added. OP self-resolved problem.
Libre Office Version: 6.0.7.3
Build ID: 1:6.0.7-0ubuntu0.18.04.10
pizzipie
 
Posts: 50
Joined: Sat Sep 13, 2008 2:28 am

Return to Calc

Who is online

Users browsing this forum: No registered users and 20 guests