Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
To GS Re .csv Commas
Hello,
I tried to append this to my recent Post, but couldn't seem to. Anyway, thanks so much for help. I tried out your explanation in a blank spreadsheet, saved it as a .csv, and you are right. But, here is a bit from the .csv spreadsheet I created (Excel 2007) that I am having all the problems with. Why is there no comma after the 600, which is the last cell used in each row ? Shouldn't there be per your reply ? Am hoping that I am just doing something dumb, as usual, and that this is my problem, and easily correctable. (each row starts, e.g., the first three rows, with 243000000, 118500000, and 124600000. And ends with the 600) Much thanks, nice of you to take the time to help, Bob 243000000,243000000,Air Emergency,AM,Voice,,,0,0,Blackman-Harris,12500,400,1,50,600 118500000,118500000,Hanscom Tower,AM,Voice,,,0,0,Blackman-Harris,12500,400,1,50,600 121850000,121850000,Hanscom Clr. Delivery,AM,Voice,,,0,0,Blackman-Harris,12500,400,1,50,600 124600000,124600000,Hanscom ATIS,AM,Voice,,,0,0,Blackman-Harris,12500,400,1,50,600 122950000,122950000,Hanscom UNICOM,AM,Voice,,,0,0,Blackman-Harris,12500,400,1,50,600 121700000,121700000,Hanscom Ground,AM,Voice,,,0,0,Blackman-Harris,12500,400,1,50,600 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
To GS Re .csv Commas
Hi Bob,
Am Wed, 12 Dec 2012 12:47:19 -0500 schrieb Bob: But, here is a bit from the .csv spreadsheet I created (Excel 2007) that I am having all the problems with. Why is there no comma after the 600, which is the last cell used in each row ? Shouldn't there be per your reply ? is it possible that you have spaces in the other cells? Regards Claus Busch -- Win XP PRof SP2 / Vista Ultimate SP2 Office 2003 SP2 /2007 Ultimate SP2 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
To GS Re .csv Commas
On Wed, 12 Dec 2012 12:47:19 -0500, Bob wrote:
But, here is a bit from the .csv spreadsheet I created (Excel 2007) that I am having all the problems with. Why is there no comma after the 600, which is the last cell used in each row ? Shouldn't there be per your reply ? Am hoping that I am just doing something dumb, as usual, and that this is my problem, and easily correctable. CSV stands for "Comma *Separated* Values", not "Comma Delimited Values". There is not supposed to be a comma at the end... |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
To GS Re .csv Commas
Bob presented the following explanation :
Why is there no comma after the 600, which is the last cell used in each row ? Shouldn't there be per your reply ? As my reply states, there is no comma after the 2nd "x" because (as joeu2004 points out thoroughly well) it's the last piece of data in the row. As Claus states, if there's any of the characters he mentions in cells following the cell containing '600' then you will see more commas. As Bruce states, the values are *separated* by commas meaning the commas act as deliminators of the data fields. Delimiters separate the fields in the file! (Contrary to Bruce's assertion that a CSV is NOT a comma delimited values file; when in fact it is<g) So here's an example that sums up what everyone is trying to convey... x,x,,,x ...where there are 5 data fields of which only the first 2 and last 1 contain data. Say, for example, you have the following data table... FirstName,LastName,Address1,Address2,State/Prov,Zip,Phone1,Phone2,Fax,Email ...which is the headings row of the data table. Note there are 9 commas, and the last field doesn't have a comma. Now look at a sample record from the data table... John,Doe,123 Main St.,Apt 101,CA,12345-6789,1234567890,,1234567891, ...where the data fields for Phone2 and Email are empty. This demos the 'proper' construction (headings row followed by records) of a CSV (or any delimited data file) atored as plain text. This structure will enable DAO/ADO and any other ODBC tools to read the data from the file same as if it was reading it from a database. -- Garry Free usenet access at http://www.eternal-september.org Classic VB Users Regroup! comp.lang.basic.visual.misc microsoft.public.vb.general.discussion |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
.csv Commas ? | Excel Discussion (Misc queries) | |||
between commas | Excel Programming | |||
between commas | Excel Programming | |||
So many commas | Excel Worksheet Functions | |||
help commas before data | Excel Discussion (Misc queries) |