A Microsoft Excel forum. ExcelBanter

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » ExcelBanter forum » Excel Newsgroups » Excel Discussion (Misc queries)
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

What does CSV files stand for??



 
 
Thread Tools Display Modes
  #1  
Old June 18th 08, 04:29 PM posted to microsoft.public.excel.misc
TexasDude
external usenet poster
 
Posts: 1
Default What does CSV files stand for??

All I would like to know is what does CSV mean literally and how do you use
it and do you do it?? -- Thx/Darrell
Ads
  #2  
Old June 18th 08, 04:43 PM posted to microsoft.public.excel.misc
David Biddulph[_2_]
external usenet poster
 
Posts: 8,651
Default What does CSV files stand for??

Perhaps I could introduce you to 2 useful facilities?
One is Google, and the other is Excel help.
--
David Biddulph

"TexasDude" > wrote in message
...
> All I would like to know is what does CSV mean literally and how do you
> use
> it and do you do it?? -- Thx/Darrell



  #3  
Old June 18th 08, 05:44 PM posted to microsoft.public.excel.misc
Gary''s Student
external usenet poster
 
Posts: 11,059
Default What does CSV files stand for??

It stands for "comma separated values"
Usually a text file with commas between the fields of data
--
Gary''s Student - gsnu200793


"TexasDude" wrote:

> All I would like to know is what does CSV mean literally and how do you use
> it and do you do it?? -- Thx/Darrell

  #4  
Old June 18th 08, 06:51 PM posted to microsoft.public.excel.misc
Bob I
external usenet poster
 
Posts: 2,819
Default What does CSV files stand for??

In reality, nowadays it should be "character" separated values
(originally it was only commas though)

Gary''s Student wrote:

> It stands for "comma separated values"
> Usually a text file with commas between the fields of data


  #5  
Old June 18th 08, 08:03 PM posted to microsoft.public.excel.misc
JLatham
external usenet poster
 
Posts: 3,366
Default What does CSV files stand for??

TexasDude -
Another thing or three about CSV files:
They are output as plain ASCII text files - you can actually open them up
with something like Notepad or Wordpad and look at them and work with them.
This has the advantage of making them platform independent. That is, just
about any computer operating system has the ability to read a plain ASCII
file. So with the ability to read that type of file and knowing that data
fields are separated with a particular character (as comma, semi-colon, pipe
| or Tab or other) then you have a fairly versatile way of exchanging data
between applications and computers.

Yes - I do use them or their brother type of file: fixed field length files.
Again, these are plain ASCII files with the data fields occupying specific
character positions within a record that is usually either 80 or 128
characters long. This works well also, but often at the expense of a lot of
wasted space to fill out fields that can be long, but are short in some
cases, with blanks to get the proper field positioning within a record.

As for how do I use it - one way that it gets used where I work is to
transfer data from an on-line timekeeping system into the company's
accounting system. Another more generic way to use it might be in this
scenario: presume you have a database program and a spreadsheet program.
They can't talk directly to one another because they don't know the other's
native file format. But both can write and read CSV files. So the CSV file
becomes a vehicle for data exchange between the two applications.


"Gary''s Student" wrote:

> It stands for "comma separated values"
> Usually a text file with commas between the fields of data
> --
> Gary''s Student - gsnu200793
>
>
> "TexasDude" wrote:
>
> > All I would like to know is what does CSV mean literally and how do you use
> > it and do you do it?? -- Thx/Darrell

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
What is URL ? Does it stand for something? Actionbob Excel Discussion (Misc queries) 3 April 19th 08 06:11 PM
What does $ stand for in an excel formula ally Excel Worksheet Functions 2 June 23rd 07 08:35 PM
Stand alone VBA script files tishoo Excel Discussion (Misc queries) 6 December 29th 06 06:02 PM
Stand alone VBA script files tishoo Setting up and Configuration of Excel 6 December 29th 06 06:02 PM
What does the ! stand for in formulas? ! Excel Worksheet Functions 1 March 14th 05 08:15 PM


All times are GMT +1. The time now is 03:40 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.
Copyright ©2004-2013 ExcelBanter.
The comments are property of their posters.