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

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

I realize you probably won't use this solution, but COBOL has an UNSTRING opcode:

unstring longfield delimited by "~" into fielda, fieldb, fieldc, fieldd on overflow perform wrong-nbr-of-flds.

The CPYFRMIMPF seems like the logical thing to use if you don't want to get an EDI package that will do this for you.

HTH

Peter Dow
Dow Software Services, Inc.
909 425-0194 voice
909 425-0196 fax

----- Original Message -----

From: Stone, Joel

To: 'MIDRANGE-L@midrange.com'

Sent: Monday, February 07, 2000 8:05 AM

Subject: Tilde delimited fields in a PC file - how to upload & convert fields 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 mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.