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
+---