delimited File

[David Morrison - Corporate]

Another way to handle this may be to use QUICK to process the data.  

David Morrison

 -----Original Message-----
From: 	Roger L Marcinik [mailto:rmarcinik@juno.com] 
Sent:	Saturday, August 17, 2002 7:10 PM
To:	aarnone@grey.com
Cc:	powerh-l@lists.swau.edu
Subject:	Re: delimited File

One way (may not be easiest) is:
Read file into Excel.
Adjust column lengths to number of characters needed per field.
Save adjusted file as text file (fixed-length).
Upload it to server.
Build dummy subfile with fields and sizes needed (or just make an ASCII
file in dictionary to match format needed).
If using VMS, can use CONVERT to populate the subfile.
Most sites have dummy files of 80 characters (or more) which can also be
used and then parsed.


On Sat, 17 Aug 2002 15:46:53 -0400 "Arnone, Anthony" <aarnone@grey.com>
writes:
> I have a comma Delimited file and I need to read it in Quiz and break 
> out
> each individual field. The Record looks like this:
> 
> 099000,00172,02,07,01,800
> 
> I am not exactly sure what is the best and easiest way to accomplish 
> this.
> 
> 
> 			Anthony
> 
> = = = = = = = = = = = = = = = = = = = = = = = = = = = =
> Mailing list: powerh-l@lists.swau.edu
> Subscribe: "subscribe" in message body to 
> powerh-l-request@lists.swau.edu
> Unsubscribe: "unsubscribe" in message body to 
> powerh-l-request@lists.swau.edu
> http://lists.swau.edu/mailman/listinfo/powerh-l
> This list is closed, thus to post to the list you must be a 
> subscriber.


________________________________________________________________
GET INTERNET ACCESS FROM JUNO!
Juno offers FREE or PREMIUM Internet access for less!
Join Juno today!  For your FREE software, visit:
http://dl.www.juno.com/get/web/.

= = = = = = = = = = = = = = = = = = = = = = = = = = = =
Mailing list: powerh-l@lists.swau.edu
Subscribe: "subscribe" in message body to powerh-l-request@lists.swau.edu
Unsubscribe: "unsubscribe" in message body to
powerh-l-request@lists.swau.edu
http://lists.swau.edu/mailman/listinfo/powerh-l
This list is closed, thus to post to the list you must be a subscriber.