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

This is not an answer to the questions you asked, but just one more thing
for you to consider.  Are you certain that the data values will never
contain the tilde character?  

Better to ask now than to get burned later.

- Dan Bale

-----Original Message-----
From: Stone, Joel [mailto:StoneJ@GourmetAward.com]
Sent: Monday, February 07, 2000 11: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
+---