PDA

View Full Version : csv issues.



caroundw5h
04-27-2004, 04:47 PM
I have a text file that when i convert to a csv file and open it up, some of the information is missing. it seems to be only a number or two, but its annoying. i a string is supposed to be nine digits sometimes one or 2 digits might be missing. This only happens with the numbers by the way. Why are some truncated and how can i avoid this?

Thank you?

Lurker
04-27-2004, 05:37 PM
How are you converting it? Your own program? Commercial program? Do I care?

XSquared
04-27-2004, 05:41 PM
>Do I care?
God. Someone's in a ..........ty mood today. Try to keep it to yourself, OK?

Lurker
04-27-2004, 05:43 PM
At least I gave him some questions to consider :) .

Actually, I'm in a pretty good mood. Occasionally, my mind decides to make me a jerk. I wonder if there's some mental disease that does that?

caroundw5h
04-27-2004, 06:23 PM
we're all entitled to our bad days. its all good bi**h!!! :D

anyways the way i convert it is simple select the text file then save it as a .csv file. all the info in it is comma delimited. but as i said when i open it up, it seems to truncate some of the sequences

Lurker
04-27-2004, 06:55 PM
OK, so you take a .txt file, simply rename it to .csv, open it in Notepad, and it is different from the .txt file? Doesn't seem very likely; am I missing something here?

BillBoeBaggins
04-28-2004, 10:23 AM
You never stated what program your doing the "Save as" in. If you are using Excel and you are losing numbers like 0 per say, make sure you convert the format to TEXT so the Program (Excel in this instance) knows to put qoutes around it.

CSV files are simple.
They are rows of information like Excel; if the information is text it has quotes, if it is not then it doesn't.

Secondly you never mentioned what program you are trying to open up the CSV in. Because if you use Jacks Cracked Excel he might of screwed up on his import proc... :o