RE: Tab delimited... again

   Here's something I found on DBG/400.  I think you have to install DBG/400,
   but it looks like a good file editor.   It's got some commands you need to
   remove the blanks from the file. 

   http://www.dbg400.net/crtcsv.html

    

   Tim Chrysler
   Ultimate Data Information Systems, Inc.
   651.246.4228
   timc@xxxxxxxxxxxxxxxx
   ----Original Message Follows----
   From: "John Cunha" <JOHN.CUNHA@xxxxxxxxxxxx>
   Reply-To: RPG programming on the AS400 / iSeries <RPG400-L@xxxxxxxxxxxx>
   To: "RPG programming on the AS400 / iSeries" <RPG400-L@xxxxxxxxxxxx>
   Subject: RE: Tab delimited... again
   Date: Thu, 17 Jul 2003 12:01:24 -0400
   Hi Matt,
   Thanks for answering...
   Yes, CPYTOIMPF works... but it does not remove blank space in the
   fields. It uses the original field length as the delimiter.
   e.g.
   Record#
   ....5...10...15...20...25...30...35...40...45...50...55...60...65
   1 RS|A|450100010 |45-01-999 |3 |3 |SECONDS
   2 RS|A|450101563 |45-01-999 |3 |3 |NT
   T-NECK
   3 RS|A|450102719 |45-01-999 |3 |4 |LADIES'
   W.
   4 RS|A|450102729 |45-01-999 |3 |3 |NR PRT
   MOC
   5 RS|A|450102784 |45-01-999 |3 |3 |C.E
   NATURA
   |___ _____|
   \/
   DEAD SPACE
   Should look like this
   1 RS|A|450100010|45-01-999|3|3|SECONDS
   2 RS|A|450101563|45-01-999|3|3|NT T-NECK
   3 RS|A|450102719|45-01-999|3|4|LADIES' W.
   4 RS|A|450102729|45-01-999|3|3|NR PRT MOC
   5 RS|A|450102784|45-01-999|3|3|C.E NATURA
   Regards,
   John
   -----Original Message-----
   From: Haas, Matt [mailto:Matt.Haas@xxxxxxxxxxxxxxxxxxx]
   Sent: July 17, 2003 11:02 AM
   To: RPG programming on the AS400 / iSeries
   Subject: RE: Tab delimited... again
   Doesn't CPYTOIMPF do this?
   Matt
   -----Original Message-----
   From: John Cunha [mailto:John.Cunha@xxxxxxxxxxxx]
   Sent: Thursday, July 17, 2003 10:34 AM
   To: rpg400-l@xxxxxxxxxxxx
   Subject: Tab delimited... again
   Hello.
   I would like to thank Scott Klement [klemscot@xxxxxxxxxxxx] for the
   great help he gave me.
   Once again... Thanks Scott!
   Now my challenge:
   We have to send files which "MUST" be tab delimited to a third party
   vendor.
   We have a way of doing that; however it entails writing separate RPG
   programs for every file,
   since they all have different record layouts/fields/lengths.
   Does anyone have or know of a generic utility that can do this for any
   file?
   Thanks for the help!
   John Cunha
   Northern Group Retail Ltd
   _______________________________________________
   This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing
   list
   To post a message email: RPG400-L@xxxxxxxxxxxx
   To subscribe, unsubscribe, or change list options,
   visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
   or email: RPG400-L-request@xxxxxxxxxxxx
   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@xxxxxxxxxxxx
   To subscribe, unsubscribe, or change list options,
   visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
   or email: RPG400-L-request@xxxxxxxxxxxx
   Before posting, please take a moment to review the archives
   at http://archive.midrange.com/rpg400-l.

     ----------------------------------------------------------------------

   Protect your PC - Click here for McAfee.com VirusScan Online