RE: Tilde delimited fields in a PC file - how to upload & convert fie lds to AS/400 physical file

Ya, then he's have to worry about parsing a lot more than just the "~"....
More work for the contractors.. <bag>

Brad

> -----Original Message-----
> From: Schenck, Don [mailto:Don.Schenck@WL.com]
> Sent: Monday, February 07, 2000 10:59 AM
> To: 'MIDRANGE-L@midrange.com'
> Subject: RE: Tilde delimited fields in a PC file - how to upload &
> convert fie lds to AS/400 physical file
> 
> 
> Too bad it wasn't sent in XML!
> 
> <g,d&r>
> 
> -----Original Message-----
> From: Stone, Brad V (TC) [mailto:bvstone@taylorcorp.com]
> Sent: February 07, 2000 11:37 AM
> To: 'MIDRANGE-L@midrange.com'
> Subject: RE: Tilde delimited fields in a PC file - how to upload &
> convert fie lds to AS/400 physical file
> 
> 
> Looks like X.12.  (Is it?)
>  
> Either you need to do some good old fasioned text parsing, or 
> you may be
> able to use the CPYFRMIMPF command.
>  
> If it is X.12, I would look into a package that will parse 
> this for you.
> 
> Brad
> 
> -----Original Message-----
> From: Stone, Joel [mailto:StoneJ@GourmetAward.com]
> Sent: Monday, February 07, 2000 10:05 AM
> To: 'MIDRANGE-L@midrange.com'
> Subject: Tilde delimited fields in a PC file - how to upload 
> & convert fie
> lds to AS/400 physical file
> 
> 
> 
> An example record: 
> 
> 40354~KMART STORE# 37~3665 HWY
> 6~~DALLAS~TX~77478~~~~~713-980-8888~~~4362~~100~3~0~0~~0~ 
> 
> Are there any utilities to split a file with records as shown 
> above into an
> AS/400 PF?  I would like the tilde's gone, where each tilde 
> acts as the
> delimiter to begin a new field.
> 
> Can Client/Access do this job by itself? 
> 
> What other options to I have.  Does anyone know of a magazine 
> article with a
> free utility program?  Other options? 
> 
> Must I build the DDS by hand?  I have a listing of field 
> names and lengths. 
> 
> The data is from a query tool on a Unix box. 
> 
> Thanks! 
> 
> 
> +---
> | This is the Midrange System Mailing List!
> | To submit a new message, send your mail to MIDRANGE-L@midrange.com.
> | To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
> | To unsubscribe from this list send email to 
> MIDRANGE-L-UNSUB@midrange.com.
> | Questions should be directed to the list owner/operator:
> david@midrange.com
> +---
> +---
> | This is the Midrange System Mailing List!
> | To submit a new message, send your mail to MIDRANGE-L@midrange.com.
> | To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
> | To unsubscribe from this list send email to 
> MIDRANGE-L-UNSUB@midrange.com.
> | Questions should be directed to the list owner/operator: 
> david@midrange.com
> +---
> 
+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---