× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.


  1.  Home
  2. MIDRANGE-L
  3. July 1997

Re: File conversion

     It's a little time-consuming, pesky, etc, but you always have the 
     option of sort of MANUALLY building the "delimited" file using Query.  
     For onesie-twosie type files it is bearable.  We haven't had any 
     large-scale projects that required us to build an automated process.  
     In Query, just define 1 big output field and concatenate the fields 
     together with the appropriate delimiters:
     
     output1 = '"'||alpha1||'",||numeric1||','
     
     output2 = output1||'"'||alpha2||'"'
     
     output  = output1||output2
     
     ... and so on.
     
     Otherwise free-up a programmer for a few hours and you should have it.
     
     Mark Stepan
     Merrill/May
     St Cloud, Minnesota
     Mark.Stepan@MerrillCorp.com


______________________________ Reply Separator _________________________________
Subject: File conversion
Author:  "Rob Ward" <rward@mcind.com> at vpn
Date:    07/10/1997 4:30 PM


Does anyone have an RPG program that will convert an AS/400 external file 
to a comma delimited file they would care to share.
     
Thanks,
Rob Ward
M-C Industries, Inc.
(913) 273-3990
rward@mcind.com
http://www.mcind.com
<html><head></head><BODY bgcolor="#FFFFFF"><p><font size=2 color="#000000"
face="Arial">Does anyone have an RPG program that will convert an AS/400
external file to a comma delimited file they would care to
share.<br><br>Thanks,<br>Rob Ward<br>M-C Industries, Inc.<br>(913)
273-3990<br><font color="#0000FF"><u>rward@mcind.com</u><font
color="#000000"><br><font color="#0000FF"><u>http://www.mcind.com</u><font
color="#000000"></p>
</font></font></font></font></font></body></html>

As an Amazon Associate we earn from qualifying purchases.

This thread ...
Follow-Ups:
Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

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.