A Windows XP help forum. PCbanter

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 » PCbanter forum » Microsoft Windows XP » Windows XP Help and Support
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

"Bad file or number"



 
 
Thread Tools Display Modes
  #1  
Old January 23rd 14, 09:36 PM posted to microsoft.public.windowsxp.help_and_support
No_Name
external usenet poster
 
Posts: 76
Default "Bad file or number"

I suspect somehow this file was not properly terminated (eg ctl-z).
it is 5.5 GB and I'm trying to load it into Access. It responds too quickly
to have tried to read the file and found out it was too big.

I am thinking someway to copy binary and add a ^Z file?

It's been 2 decades since i did something like this and I suspect
whatever worked then won't work with 5.5 GB



- = -
Vasos Panagiotopoulos, Columbia'81+, Reagan, Mozart, Pindus, BioStrategist
http://www.panix.com/~vjp2/vasos.htm
---{Nothing herein constitutes advice. Everything fully disclaimed.}---
[Homeland Security means private firearms not lazy obstructive guards]
[Urb sprawl confounds terror] [Phooey on GUI: Windows for subprime Bimbos]




Ads
  #2  
Old January 23rd 14, 10:50 PM posted to microsoft.public.windowsxp.help_and_support
David H. Lipman
external usenet poster
 
Posts: 4,185
Default "Bad file or number"

From:

I suspect somehow this file was not properly terminated (eg ctl-z).
it is 5.5 GB and I'm trying to load it into Access. It responds too
quickly
to have tried to read the file and found out it was too big.

I am thinking someway to copy binary and add a ^Z file?

It's been 2 decades since i did something like this and I suspect
whatever worked then won't work with 5.5 GB


32bit MS Access or 64bit MS Access ?


--
Dave
Multi-AV Scanning Tool - http://multi-av.thespykiller.co.uk
http://www.pctipp.ch/downloads/dl/35905.asp

  #4  
Old January 24th 14, 08:56 AM posted to microsoft.public.windowsxp.help_and_support
No_Name
external usenet poster
 
Posts: 76
Default "Bad file or number"

*+-
*+- It's been 2 decades since i did something like this and I suspect
*+- whatever worked then won't work with 5.5 GB


*+-I seriously doubt you were working with 5.5GB files 20 years ago

Isn't it obvious from the way I said it?


- = -
Vasos Panagiotopoulos, Columbia'81+, Reagan, Mozart, Pindus, BioStrategist
http://www.panix.com/~vjp2/vasos.htm
---{Nothing herein constitutes advice. Everything fully disclaimed.}---
[Homeland Security means private firearms not lazy obstructive guards]
[Urb sprawl confounds terror] [Phooey on GUI: Windows for subprime Bimbos]




  #5  
Old January 24th 14, 11:03 AM posted to microsoft.public.windowsxp.help_and_support
R.Wieser
external usenet poster
 
Posts: 1,302
Default "Bad file or number"

*+-I seriously doubt you were working with 5.5GB files 20 years ago

Isn't it obvious from the way I said it?


Not really.

If its a file from 20 years back (one possible way to read your statement) I
also doubt it. 20 years back (1994, a pre Windows time) even big *drives*
where measured in MB, not GB. And you would have had a quite special
program to work with filesizes at least three times the processors
address-bus width. Heck, even recently (on Fat32) filesizes where limited
to 2 GB.

Taking the other way to read it and assume you just now created/got a
datafile of 5.5 GB you can't read, what makes you think its the ctrl-Z thats
doing it ? It might very well be the (old) program itself not being able
to coope with a file over 2 GB in size ...

I am thinking someway to copy binary and add a ^Z file?


Type "copy /?" for full info. Create a file with a ctrl-Z (type ALT 26 if
I'm not mistaken) in it and use the "/b" option to "+" the files together
(to a new one) :

copy /b Srcfile1 /b Srcfile2 Trgfile

Hope that helps.

Regards,
Rudy Wieser


-- Origional message:
schreef in berichtnieuws
...
*+-
*+- It's been 2 decades since i did something like this and I suspect
*+- whatever worked then won't work with 5.5 GB


*+-I seriously doubt you were working with 5.5GB files 20 years ago

Isn't it obvious from the way I said it?


- = -
Vasos Panagiotopoulos, Columbia'81+, Reagan, Mozart, Pindus,

BioStrategist
http://www.panix.com/~vjp2/vasos.htm
---{Nothing herein constitutes advice. Everything fully disclaimed.}---
[Homeland Security means private firearms not lazy obstructive guards]
[Urb sprawl confounds terror] [Phooey on GUI: Windows for subprime

Bimbos]






  #7  
Old January 25th 14, 03:18 AM posted to microsoft.public.windowsxp.help_and_support
No_Name
external usenet poster
 
Posts: 76
Default "Bad file or number"

Sure. (forgive noisy line)

2GB is mdb (out) limit not csv (in) limit

me hopes
but the bad file error comes
up too fast

ok.. gotta log off-- noise is driving me bats

- = -
Vasos Panagiotopoulos, Columbia'81+, Reagan, Mozart, Pindus, BioStrategist
http://www.panix.com/~vjp2/vasos.htm
---{Nothing herein constitutes advice. Everything fully disclaimed.}---
[Homeland Security means private firearms not lazy obstructive guards]
[Urb sprawl confounds terror] [Phooey on GUI: Windows for subprime Bimbos]




  #10  
Old January 25th 14, 03:15 PM posted to microsoft.public.windowsxp.help_and_support
philo [_3_]
external usenet poster
 
Posts: 984
Default "Bad file or number"

On 01/25/2014 07:29 AM, David H. Lipman wrote:



Since you did not answer my question "how was it created"

no way can I help you further.



He never answered my query.




When people ask for help but ignore questions I assume they are just
trolling.

A 5 GB csv is absurd
  #11  
Old January 25th 14, 04:36 PM posted to microsoft.public.windowsxp.help_and_support
No_Name
external usenet poster
 
Posts: 76
Default "Bad file or number"

No, my line was bad and I was unable to finish.
(It was wierd. It wasn't just noise but I was typing one thing and
getting something else. Hadn't seen THAT in decades since I was
dialing up with my hp2621a terminal alone)

My goal is to add an EOF (ctl-Z) to the end of a 5.6GB file out of hopes of
fixing it.


THe file came as a zip file on a CD from the provider.
THey warn of problems but the first time it was they
who sent a truncated file.
It is possible I could fix it by using a different unzipper,
or read it into openoffice base. Or I can break the file up.

I'm thinking something like
copy -b x.csv+ctlz.cod y.csv
where ctlz.cod just had ctl-z (EOF)

But I don't know how this would behave with 5.6GB

- = -
Vasos Panagiotopoulos, Columbia'81+, Reagan, Mozart, Pindus, BioStrategist
http://www.panix.com/~vjp2/vasos.htm
---{Nothing herein constitutes advice. Everything fully disclaimed.}---
[Homeland Security means private firearms not lazy obstructive guards]
[Urb sprawl confounds terror] [Phooey on GUI: Windows for subprime Bimbos]




  #12  
Old January 26th 14, 07:32 PM posted to microsoft.public.windowsxp.help_and_support
R.Wieser
external usenet poster
 
Posts: 1,302
Default "Bad file or number"

Vip2,

THey warn of problems but the first time it was they
who sent a truncated file.


And pray tell, how do you know that they did send a faulty, truncated file ?

Because of the problem ? That might well be caused by something else ...

In other words: Do not assume a ctrl-Z at the end will solve everything.
Also, most modern programs (DOS v3.3 or later) have no problem with a
textfile just ending, without such a ctrl-Z.

But I don't know how this would behave with 5.6GB


There is only one way to know: try it !

Suggestion: first backup the origional (if you did not save the ZIP-file it
came from), so you can restore it when something goes wrong.

I'm thinking something like
copy -b x.csv+ctlz.cod y.csv
where ctlz.cod just had ctl-z (EOF)


Yeah, that is what I suggested too. As you are responding as if you have
not read it I have no idea if you will actually read this either. :-\
Regards,
Rudy Wieser



schreef in berichtnieuws
...
No, my line was bad and I was unable to finish.
(It was wierd. It wasn't just noise but I was typing one thing and
getting something else. Hadn't seen THAT in decades since I was
dialing up with my hp2621a terminal alone)

My goal is to add an EOF (ctl-Z) to the end of a 5.6GB file out of hopes

of
fixing it.


THe file came as a zip file on a CD from the provider.
THey warn of problems but the first time it was they
who sent a truncated file.
It is possible I could fix it by using a different unzipper,
or read it into openoffice base. Or I can break the file up.

I'm thinking something like
copy -b x.csv+ctlz.cod y.csv
where ctlz.cod just had ctl-z (EOF)

But I don't know how this would behave with 5.6GB

- = -
Vasos Panagiotopoulos, Columbia'81+, Reagan, Mozart, Pindus,

BioStrategist
http://www.panix.com/~vjp2/vasos.htm
---{Nothing herein constitutes advice. Everything fully disclaimed.}---
[Homeland Security means private firearms not lazy obstructive guards]
[Urb sprawl confounds terror] [Phooey on GUI: Windows for subprime

Bimbos]






  #13  
Old January 27th 14, 01:58 AM posted to microsoft.public.windowsxp.help_and_support
No_Name
external usenet poster
 
Posts: 76
Default "Bad file or number"

Someone in the NT batch newsgroup suggestes:

copy x.csv+nul /a

for which I am most gratefule

- = -
Vasos Panagiotopoulos, Columbia'81+, Reagan, Mozart, Pindus, BioStrategist
http://www.panix.com/~vjp2/vasos.htm
---{Nothing herein constitutes advice. Everything fully disclaimed.}---
[Homeland Security means private firearms not lazy obstructive guards]
[Urb sprawl confounds terror] [Phooey on GUI: Windows for subprime Bimbos]




  #14  
Old January 27th 14, 10:29 AM posted to microsoft.public.windowsxp.help_and_support
R.Wieser
external usenet poster
 
Posts: 1,302
Default "Bad file or number"

vjp2,

Someone in the NT batch newsgroup suggestes:

copy x.csv+nul /a

for which I am most gratefule


Nice, appending an "empty file" and depending on the "/a" switch to have the
copy command append a ctrl-z.

One drawback though : If, for whatever reason whatsoever, the CSV contains a
ctrl-z somewhere in the middle you will throw the remainder of the file
away. In other words: check the size of the result. If it apears to be
shorter than the origional something has gone wrong ...

But now the important question: Did adding that ctrl-z actually solve the
problem ? You did not mention anything about it.

Regards,
Rudy Wieser


-- Origional message:
schreef in berichtnieuws
...
Someone in the NT batch newsgroup suggestes:

copy x.csv+nul /a

for which I am most gratefule

- = -
Vasos Panagiotopoulos, Columbia'81+, Reagan, Mozart, Pindus,

BioStrategist
http://www.panix.com/~vjp2/vasos.htm
---{Nothing herein constitutes advice. Everything fully disclaimed.}---
[Homeland Security means private firearms not lazy obstructive guards]
[Urb sprawl confounds terror] [Phooey on GUI: Windows for subprime

Bimbos]






  #15  
Old February 10th 14, 12:01 AM posted to microsoft.public.windowsxp.help_and_support
No_Name
external usenet poster
 
Posts: 76
Default "Bad file or number"

*+-One drawback though : If, for whatever reason whatsoever, the CSV contains a
*+-ctrl-z somewhere in the middle you will throw the remainder of the file

I'm up to my waist in alligators..
but I did another looksee and saw the disk I thought damaged
was the same size and some unzip programs think the file is corrupt and won't
open it and others will only give me half the file.

One other clue, GNU tail won't work, but on the full-sized file, grep finds
everything.


Which unzipper do you prefer? (the XP one is from 2008)


- = -
Vasos Panagiotopoulos, Columbia'81+, Reagan, Mozart, Pindus, BioStrategist
http://www.panix.com/~vjp2/vasos.htm
---{Nothing herein constitutes advice. Everything fully disclaimed.}---
[Homeland Security means private firearms not lazy obstructive guards]
[Urb sprawl confounds terror] [Phooey on GUI: Windows for subprime Bimbos]




 




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 Off
HTML code is Off






All times are GMT +1. The time now is 10:45 AM.


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