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

Joel,

Our Alliance CrossData/400 product can import delimited files to an
AS/400 database file. More information here: http://www.patownsend.com.
You can download a trial and give it a try if you like.

Patrick
-- 
IBM AS/400 communications, FTP automation, and network security
software and consulting services.

http://www.patownsend.com


> "Stone, Joel" wrote:
> 
> 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
+---