Linux - Newbie This Linux forum is for members that are new to Linux.
Just starting out and have a question?
If it is not in the man pages or the how-to's this is the place! |
Notices |
Welcome to LinuxQuestions.org, a friendly and active Linux Community.
You are currently viewing LQ as a guest. By joining our community you will have the ability to post topics, receive our newsletter, use the advanced search, subscribe to threads and access many other special features. Registration is quick, simple and absolutely free. Join our community today!
Note that registered members see fewer ads, and ContentLink is completely disabled once you log in.
Are you new to LinuxQuestions.org? Visit the following links:
Site Howto |
Site FAQ |
Sitemap |
Register Now
If you have any problems with the registration process or your account login, please contact us. If you need to reset your password, click here.
Having a problem logging in? Please visit this page to clear all LQ-related cookies.
Get a virtual cloud desktop with the Linux distro that you want in less than five minutes with Shells! With over 10 pre-installed distros to choose from, the worry-free installation life is here! Whether you are a digital nomad or just looking for flexibility, Shells can put your Linux machine on the device that you want to use.
Exclusive for LQ members, get up to 45% off per month. Click here for more info.
|
|
04-21-2017, 01:09 PM
|
#1
|
Senior Member
Registered: Mar 2014
Location: Illinois
Distribution: Xubuntu
Posts: 2,034
Rep:
|
converting .ods to .csv file in LibreOffice Calc question
I have email lists in .csv files. Sometimes I need to copy email addresses from the .csv into a new Calc text document, which is .ods. When I "save as" it gives me the option to save as a .csv. But when I do the actual saving it gives me this popup window (screenshot) giving me the options to change the "field delimiter" and "text delimiter." I tracked this down https://help.libreoffice.org/Calc/Im...ting_CSV_Fileshttps://help.libreoffice.org/Calc/Im...ting_CSV_Files but it doesn't say what the options mean. This is my first experience with this and I just want to make sure when I send the list to the Mailchimp provdier the email lists function properly. My guess is to just go with the default, but I'd really rather not be guessing about this. Thanks.
|
|
|
04-21-2017, 01:15 PM
|
#2
|
LQ Guru
Registered: Apr 2005
Distribution: Linux Mint, Devuan, OpenBSD
Posts: 7,578
|
As you see, you can separate the cells with a comma or other characters like a tab. Which does the provider require?
Also, since the resulting file is text, you can view it in an editor and actually see what it has used.
|
|
1 members found this post helpful.
|
04-21-2017, 01:18 PM
|
#3
|
LQ Veteran
Registered: Jul 2006
Location: London
Distribution: PCLinuxOS, Salix
Posts: 6,185
|
The default is the normal for CSV: commas between fields, text in double quotes. As you see, you can separate fields with tabs, or use single quotes, etc: it's up to you.
|
|
1 members found this post helpful.
|
04-21-2017, 01:53 PM
|
#4
|
Senior Member
Registered: Mar 2014
Location: Illinois
Distribution: Xubuntu
Posts: 2,034
Original Poster
Rep:
|
Thanks guys. It's still kind of confusing, though. Sometimes when I make changes in a .csv file and just click the save button it saves it as a .csv. Other times it gives me the popup window with the options to choose the text and field delimiters.
And there are no commas or quotation marks in any of my .csv files. And it just seems like lines separate the fields.
Second, when I experimented and changed the field and text delimiters I didn't notice any difference.
What am I missing?
|
|
|
04-21-2017, 02:05 PM
|
#5
|
LQ Guru
Registered: Apr 2005
Distribution: Linux Mint, Devuan, OpenBSD
Posts: 7,578
|
The quotes only get used when there is something questionable in a cell that would confuse the parser otherwise. For example, if you have a comma separating the fields and then if you have a cell containing a comma, the quotes will be used around that cell, but probably skipped for all other cells.
|
|
1 members found this post helpful.
|
04-21-2017, 02:34 PM
|
#6
|
Senior Member
Registered: Mar 2014
Location: Illinois
Distribution: Xubuntu
Posts: 2,034
Original Poster
Rep:
|
Quote:
Originally Posted by Turbocapitalist
The quotes only get used when there is something questionable in a cell that would confuse the parser otherwise. For example, if you have a comma separating the fields and then if you have a cell containing a comma, the quotes will be used around that cell, but probably skipped for all other cells.
|
Thanks for the explanation, Turbo. I experimented and put some commas in the email addresses and they weren't surrounded by quotation marks but they were gray-highlighted to make them stand out.
I think for my purposes though I'm okay just going with the default (when it comes to saving the.ods as a .csv).
Appreciate your help.
|
|
|
04-22-2017, 11:49 AM
|
#7
|
LQ Veteran
Registered: Jul 2006
Location: London
Distribution: PCLinuxOS, Salix
Posts: 6,185
|
I haven't tried, but I think the quotes would only be used if there was at least one numeric field. The CSV mark-up is intended for import, where the application has to know what the fields are: you can mark the text with quotes, but it's difficult to see how the numbers could be identified.
|
|
1 members found this post helpful.
|
04-22-2017, 01:40 PM
|
#8
|
LQ Addict
Registered: Dec 2013
Posts: 19,872
|
Quote:
Originally Posted by Gregg Bell
And there are no commas or quotation marks in any of my .csv files. And it just seems like lines separate the fields.
|
are you sure you are looking at these csv files in a plain text editor?
|
|
1 members found this post helpful.
|
04-22-2017, 01:48 PM
|
#9
|
LQ Newbie
Registered: Aug 2012
Location: Eugene, OR
Distribution: Fedora 21
Posts: 3
Rep:
|
CSV file
Quote:
Originally Posted by DavidMcCann
I haven't tried, but I think the quotes would only be used if there was at least one numeric field. The CSV mark-up is intended for import, where the application has to know what the fields are: you can mark the text with quotes, but it's difficult to see how the numbers could be identified.
|
Provide us with a screen shot please of the CSV file's first 5 lines.
|
|
1 members found this post helpful.
|
04-22-2017, 04:39 PM
|
#10
|
LQ Guru
Registered: Jan 2005
Location: USA and Italy
Distribution: Debian testing/sid; OpenSuSE; Fedora; Mint
Posts: 5,524
|
Considering csv stands for "comma separated variables", it's difficult to imagine a csv file without any commas.
|
|
1 members found this post helpful.
|
04-23-2017, 12:54 AM
|
#11
|
Senior Member
Registered: Mar 2014
Location: Illinois
Distribution: Xubuntu
Posts: 2,034
Original Poster
Rep:
|
Quote:
Originally Posted by DavidMcCann
I haven't tried, but I think the quotes would only be used if there was at least one numeric field. The CSV mark-up is intended for import, where the application has to know what the fields are: you can mark the text with quotes, but it's difficult to see how the numbers could be identified.
|
Thanks David. I think I over-complicated this. The default works just fine.
|
|
|
04-23-2017, 12:54 AM
|
#12
|
Senior Member
Registered: Mar 2014
Location: Illinois
Distribution: Xubuntu
Posts: 2,034
Original Poster
Rep:
|
Quote:
Originally Posted by ondoho
are you sure you are looking at these csv files in a plain text editor?
|
No, I was looking at in LibreOffice Calc.
|
|
|
04-23-2017, 12:56 AM
|
#13
|
Senior Member
Registered: Mar 2014
Location: Illinois
Distribution: Xubuntu
Posts: 2,034
Original Poster
Rep:
|
Quote:
Originally Posted by defconmatrix
Provide us with a screen shot please of the CSV file's first 5 lines.
|
I really can't because it has people's email addresses. I'm pretty satisfied with the default anyway and am going to mark this thread as solved.
|
|
|
04-23-2017, 12:57 AM
|
#14
|
Senior Member
Registered: Mar 2014
Location: Illinois
Distribution: Xubuntu
Posts: 2,034
Original Poster
Rep:
|
Quote:
Originally Posted by AwesomeMachine
Considering csv stands for "comma separated variables", it's difficult to imagine a csv file without any commas.
|
I thought so too! But the ones with the email addresses only have:
1)The email address
2) The first name
3) The last name.
Hence no commas anywhere.
|
|
|
04-23-2017, 12:59 AM
|
#15
|
Senior Member
Registered: Mar 2014
Location: Illinois
Distribution: Xubuntu
Posts: 2,034
Original Poster
Rep:
|
Calling this one solved. I was over-analyzing this. The default is working fine for me.
|
|
|
All times are GMT -5. The time now is 01:13 AM.
|
LinuxQuestions.org is looking for people interested in writing
Editorials, Articles, Reviews, and more. If you'd like to contribute
content, let us know.
|
Latest Threads
LQ News
|
|