ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   VERY new user with CSV woes (https://www.excelbanter.com/new-users-excel/211390-very-new-user-csv-woes.html)

phoenixxinOz

VERY new user with CSV woes
 
I've been struggling with Wxcel and CSV for ages. Is there a simply-worded
tutorial somwhere? All I'm trying to do is make some changes to an Excel/CSV,
but when I am asked if I want to save the changes, I get 2 different
questions, which if I answer"yes" to, changes the file so much I can't upload
it because of the error: "Cannot fetch headers. CSV-delimiter not defined."
I'm the first to admit I have no idea what I'm doing with this, and have
just been trying to "wing it", by trial and error...but it's ALL errors.
I hope this makes sense to someone, and thanks for any advice/help.
--
T.A.N.S.T.A.A.F.L.

Ron@Buy

VERY new user with CSV woes
 
Try a web search!
This may help:
http://www.creativyst.com/Doc/Articl...tm#ExampleData

"phoenixxinOz" wrote:

I've been struggling with Wxcel and CSV for ages. Is there a simply-worded
tutorial somwhere? All I'm trying to do is make some changes to an Excel/CSV,
but when I am asked if I want to save the changes, I get 2 different
questions, which if I answer"yes" to, changes the file so much I can't upload
it because of the error: "Cannot fetch headers. CSV-delimiter not defined."
I'm the first to admit I have no idea what I'm doing with this, and have
just been trying to "wing it", by trial and error...but it's ALL errors.
I hope this makes sense to someone, and thanks for any advice/help.
--
T.A.N.S.T.A.A.F.L.


phoenixxinOz

VERY new user with CSV woes
 
LOL I've been trying websearhc, been all over the place. I guess my search
terms weren't right. Am off to look at the link you provided...thanks.
--
T.A.N.S.T.A.A.F.L.


"Ron@Buy" wrote:

Try a web search!
This may help:
http://www.creativyst.com/Doc/Articl...tm#ExampleData

"phoenixxinOz" wrote:

I've been struggling with Wxcel and CSV for ages. Is there a simply-worded
tutorial somwhere? All I'm trying to do is make some changes to an Excel/CSV,
but when I am asked if I want to save the changes, I get 2 different
questions, which if I answer"yes" to, changes the file so much I can't upload
it because of the error: "Cannot fetch headers. CSV-delimiter not defined."
I'm the first to admit I have no idea what I'm doing with this, and have
just been trying to "wing it", by trial and error...but it's ALL errors.
I hope this makes sense to someone, and thanks for any advice/help.
--
T.A.N.S.T.A.A.F.L.


JLatham

VERY new user with CSV woes
 
If that article doesn't do the job for you, let us know. We can try to
answer questions about CSV and Excel specifically here.

Some things to understand about a CSV file:
Most people will tell you that it stands vor Comma Separated Values. Not
entirely true. More accurately it could be said that it stands for Character
Separated Values because there are several "standard" characters that may be
used to separate the value groups in such a file. Commonly those are the
[Tab] character, the comma [,], the semi-colon [;] and the pipe [|] symbol.
In any given CSV file, only one of those characters will be used as the
separator within it.

A CSV file may or may not have the names of the columns of data as the first
record in the file. It does not have to.

CSV files also need to be able to define text and this is done by defining a
text delimiting character (a character used at both ends of a text string).
Usually, but not always that delimiter is the " character. Sometimes it can
be the ' character.

A CSV file is a simple ASCII file. This means that they can be created,
edited and viewed with a simple editor like Notepad or Wordpad (but be sure
you save as ASCII text, not as some special formatted text file).

"phoenixxinOz" wrote:

LOL I've been trying websearhc, been all over the place. I guess my search
terms weren't right. Am off to look at the link you provided...thanks.
--
T.A.N.S.T.A.A.F.L.


"Ron@Buy" wrote:

Try a web search!
This may help:
http://www.creativyst.com/Doc/Articl...tm#ExampleData

"phoenixxinOz" wrote:

I've been struggling with Wxcel and CSV for ages. Is there a simply-worded
tutorial somwhere? All I'm trying to do is make some changes to an Excel/CSV,
but when I am asked if I want to save the changes, I get 2 different
questions, which if I answer"yes" to, changes the file so much I can't upload
it because of the error: "Cannot fetch headers. CSV-delimiter not defined."
I'm the first to admit I have no idea what I'm doing with this, and have
just been trying to "wing it", by trial and error...but it's ALL errors.
I hope this makes sense to someone, and thanks for any advice/help.
--
T.A.N.S.T.A.A.F.L.



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

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com