RE: Query output with Tab delimeted file

["Giri Gopal" <GiriGopal@xxxxxxxxxx>]

No, this cannot be a manual process. The As/400 runs a query using ROBOT,
and when completed a CL script will FTP the output of query to a FTP site as
an TAB delimeted file.



-----Original Message-----
From: rpg400-l-admin@midrange.com [mailto:rpg400-l-admin@midrange.com]On
Behalf Of alan shore
Sent: Monday, March 11, 2002 12:33 PM
To: rpg400-l@midrange.com
Subject: Re: Query output with Tab delimeted file


Are you using Rumba? You can transfer a file from the AS/400 to your PC as a
tab-delimited file, fo r EXEL etc.

>>> "Giri Gopal" <GiriGopal@bcginK.com> 03/11/02 12:38PM >>>
Hello:

I am running a query to output a file. I want to put a tab between each
field. I created a new field, but how do I key in the tab character. Can
some one help me please. I am able to get comma delimeted file, but we have
some fields which have commas as part of the data eg: xyz, inc.  I want to
create this TAB file so users can open this file once downloaded to a pc
with Excel.


Thanks for your help in advance.
GG

_______________________________________________
This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
To post a message email: RPG400-L@midrange.com
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/cgi-bin/listinfo/rpg400-l
or email: RPG400-L-request@midrange.com
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.


_______________________________________________
This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
To post a message email: RPG400-L@midrange.com
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/cgi-bin/listinfo/rpg400-l
or email: RPG400-L-request@midrange.com
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.