RE: EXCEL 2002 importing fixed width files

  • From: "Jason Boston" <jwb3301@xxxxxxxxxx>
  • To: <jfw@xxxxxxxxxxxxx>
  • Date: Wed, 3 Dec 2003 22:33:50 -0600

no delimiters, and not always white space either. just have to know the
column widths or your screwed.

Jason


-----Original Message-----
From: jfw-bounce@xxxxxxxxxxxxx [mailto:jfw-bounce@xxxxxxxxxxxxx]On
Behalf Of Reinhard Stebner
Sent: Wednesday, December 03, 2003 8:42 PM
To: jfw@xxxxxxxxxxxxx
Subject: RE: EXCEL 2002 importing fixed width files


What and how are the files formatted to start with?  Do they have
deleminaters?  Or are they just separated by white space?


-----Original Message-----
From: jfw-bounce@xxxxxxxxxxxxx [mailto:jfw-bounce@xxxxxxxxxxxxx] On =
Behalf
Of Jason Boston
Sent: Wednesday, December 03, 2003 7:33 AM
To: jfw@xxxxxxxxxxxxx
Subject: RE: EXCEL 2002 importing fixed width files


No, because in many of the files 5 or more fields will be right next to =
each
other with no spaces, commas, etc. I can't go in an put these in by hand
either, because we are talking about files that may be 500 to 2000
characters wide and 10000 to 1000000 lines long.

Thanks,
Jason


-----Original Message-----
From: jfw-bounce@xxxxxxxxxxxxx [mailto:jfw-bounce@xxxxxxxxxxxxx]On
Behalf Of Anna K Byrne
Sent: Tuesday, December 02, 2003 10:14 PM
To: jfw@xxxxxxxxxxxxx
Subject: Re: EXCEL 2002 importing fixed width files


Can you set it as delimited, using ~ or some such thing to separate the
columns?
At 09:02 PM 12/2/2003, you wrote:
>Hi all, I'm using JFW5 and Excel 2002.
>
>I need to import a fixed width ASCII file. However, the import wizard =
wants
>me to move the arrows on the screen to set the column widths for each
>column. How can I do this with Jaws? Surely there's an alternative =
method.
>
>Thanks,
>Jason
>
>
>To post a message to the list, send it to jfw@xxxxxxxxxxxxx
>To unsubscribe from this mailing list, send a message to
>jfw-request@xxxxxxxxxxxxx with the word unsubscribe in the subject =
line.



To post a message to the list, send it to jfw@xxxxxxxxxxxxx
To unsubscribe from this mailing list, send a message to
jfw-request@xxxxxxxxxxxxx with the word unsubscribe in the subject line.



To post a message to the list, send it to jfw@xxxxxxxxxxxxx
To unsubscribe from this mailing list, send a message to
jfw-request@xxxxxxxxxxxxx with the word unsubscribe in the subject line.



To post a message to the list, send it to jfw@xxxxxxxxxxxxx
To unsubscribe from this mailing list, send a message to
jfw-request@xxxxxxxxxxxxx with the word unsubscribe in the subject line.


To post a message to the list, send it to jfw@xxxxxxxxxxxxx
To unsubscribe from this mailing list, send a message to 
jfw-request@xxxxxxxxxxxxx with the word unsubscribe in the subject line.

Other related posts: