View previous topic :: View next topic |
Author |
Message |
Dragon_Lee Beginner
Joined: 13 Feb 2006 Posts: 31 Topics: 17
|
Posted: Sun Jul 22, 2007 10:52 pm Post subject: How to use PLI to remove first row of different input files? |
|
|
I want to develop a common module with PLI which can read different input files with different record length then output the record without the first row to different output files with different record length.
E.g.
Input: File A or File B or File C
File A
-------
DABC
DHIG
File B
--------
DABCD
DHIGK
File C
-------------
DABCDEFG
DHIGKLMN
Output:
File A
-----
ABC
HIG
File B
-------
ABCD
HIGK
File C
-----------
ABCDEFG
HIGKLMN
Could anyone help on it? Much appreciated. _________________ Dragon |
|
Back to top |
|
 |
bauer Intermediate
Joined: 10 Oct 2003 Posts: 316 Topics: 50 Location: Germany
|
Posted: Mon Jul 23, 2007 1:00 am Post subject: |
|
|
Dragon_Lee,
in your sample the first digit is removed not the first record ?! |
|
Back to top |
|
 |
anbesivam Beginner
Joined: 09 Aug 2006 Posts: 66 Topics: 14
|
Posted: Mon Jul 23, 2007 2:19 am Post subject: |
|
|
Dragon_Lee,
You can specify your different record lengths on the file declaration and you can use SUBSTR function to eliminate the first character. |
|
Back to top |
|
 |
Dragon_Lee Beginner
Joined: 13 Feb 2006 Posts: 31 Topics: 17
|
Posted: Tue Jul 24, 2007 11:39 pm Post subject: |
|
|
anbesivam,
It does help. Thanks a lot! _________________ Dragon |
|
Back to top |
|
 |
|
|