View previous topic :: View next topic |
Author |
Message |
cyberuser Beginner
Joined: 15 Oct 2005 Posts: 29 Topics: 12
|
Posted: Thu Sep 20, 2007 9:18 am Post subject: Erase the entire line content |
|
|
Hello !
is possible with dfsort to produce this :
fb/133 in
kjakdjkasjdkjsdjPGM=xxxykajsdkjaskdjksjdkasjd
kjakdjdj PGM=xxxxxyykajsdkjaskdjksjdkasjd
kjakdjdjPGM=xxxxyyy,kajsdkjaskdjksjdkasjd
fb/133 out
PGM=xxxy
PGM=xxxxxyy
PGM=xxxxyyy
Thanks !!! |
|
Back to top |
|
 |
cyberuser Beginner
Joined: 15 Oct 2005 Posts: 29 Topics: 12
|
Posted: Thu Sep 20, 2007 9:20 am Post subject: |
|
|
a better view of input file :
Code: | fb/133 in
kjakdjkasjdkjsdjPGM=xxxykajsdkjaskdjksjdkasjd
kjakdjdj PGM=xxxxxyy kajsdkjaskdjksjdkasjd
kjakdjdjPGM=xxxxyyy,kajsdkjaskdjksjdkasjd |
|
|
Back to top |
|
 |
kolusu Site Admin

Joined: 26 Nov 2002 Posts: 12378 Topics: 75 Location: San Jose
|
Posted: Thu Sep 20, 2007 9:23 am Post subject: |
|
|
cyberuser,
How do you know where to end for the pgm name? Is the last character of the pgm name always a 'Y'?
Kolusu _________________ Kolusu
www.linkedin.com/in/kolusu |
|
Back to top |
|
 |
cyberuser Beginner
Joined: 15 Oct 2005 Posts: 29 Topics: 12
|
Posted: Thu Sep 20, 2007 9:23 am Post subject: |
|
|
just found a workaround for this report ! appreciate the attention.
this post can be deleted. Thanks !! |
|
Back to top |
|
 |
cyberuser Beginner
Joined: 15 Oct 2005 Posts: 29 Topics: 12
|
Posted: Thu Sep 20, 2007 9:26 am Post subject: |
|
|
i'll do the reverse.... i'll provide the programs names and retrieve them with ifthen... Thank you ! |
|
Back to top |
|
 |
Frank Yaeger Sort Forum Moderator

Joined: 02 Dec 2002 Posts: 1618 Topics: 31 Location: San Jose
|
Posted: Thu Sep 20, 2007 11:26 am Post subject: |
|
|
Quote: | i'll do the reverse.... i'll provide the programs names and retrieve them with ifthen |
Please show us the control statements you're using for that.
I suspect DFSORT's PARSE function might be a better way to do this but it's not clear what you want to do. Is there a rule for determining where the program name ends as Kolusu asked or is it just a matter of determining which of a list of program names is in each record and extracting it? _________________ Frank Yaeger - DFSORT Development Team (IBM)
Specialties: JOINKEYS, FINDREP, WHEN=GROUP, ICETOOL, Symbols, Migration
DFSORT is on the Web at:
www.ibm.com/storage/dfsort |
|
Back to top |
|
 |
|
|