| Author |
Message |
Topic: Get count of field value occurrences for a Group |
guhanath
Replies: 10
Views: 5783
|
Forum: Utilities Posted: Mon Apr 09, 2018 12:45 am Subject: Get count of field value occurrences for a Group |
Hi Kolusu,
Thanks for the suggestion and i have implemented without DCB. The code is working well. Thank You.
Thanks,
Nath. |
Topic: Get count of field value occurrences for a Group |
guhanath
Replies: 10
Views: 5783
|
Forum: Utilities Posted: Mon Apr 02, 2018 9:35 am Subject: Get count of field value occurrences for a Group |
Hi Kolusu,
Thanks for solution.
why do you need an ICETOOL code? You do realize that ICETOOL under the covers calls DFSORT? so what exactly are you trying to achieve ?
I would like to re-ord ... |
Topic: Get count of field value occurrences for a Group |
guhanath
Replies: 10
Views: 5783
|
Forum: Utilities Posted: Fri Mar 30, 2018 8:50 am Subject: Get count of field value occurrences for a Group |
Hi,
How can i use KEYBEGIN suppose my input file is like below for the same output.
Input file
FL1 FL2 FL3 (REC Length 13, Fixex Block)
--- ---- ----
PPP NKY1 KEY1
PPP NKY2 K ... |
Topic: Get count of field value occurrences for a Group |
guhanath
Replies: 10
Views: 5783
|
Forum: Utilities Posted: Fri Mar 30, 2018 1:10 am Subject: Get count of field value occurrences for a Group |
Hi Kolusu,
Thanks, its working for me.
Can i get this code in ICETOOL instead of SORT? I can use CTL1CNTL cards in that than SORT to re-sorting the records.
Thanks,
Nath. |
Topic: Get count of field value occurrences for a Group |
guhanath
Replies: 10
Views: 5783
|
Forum: Utilities Posted: Thu Mar 29, 2018 8:46 am Subject: Get count of field value occurrences for a Group |
Hi Arun Raj,
Yes. It's may be the order as you mention. But first duplicate record should have 1 and remaining duplicate records should be 0.
Thanks,
Nath |
Topic: Get count of field value occurrences for a Group |
guhanath
Replies: 10
Views: 5783
|
Forum: Utilities Posted: Thu Mar 29, 2018 4:59 am Subject: Get count of field value occurrences for a Group |
Hi,
I have modified my output file. Please find below the expected output file.
Output file
FL1 FL2 FL3 (REC Length 8, Fixex Block)
--- ----- ----
PPP AAA1 1
PPP AAA2 1
QQ ... |
Topic: Get count of field value occurrences for a Group |
guhanath
Replies: 10
Views: 5783
|
Forum: Utilities Posted: Thu Mar 29, 2018 4:18 am Subject: Get count of field value occurrences for a Group |
Hi,
I am having a requirement like below and would like to do in DFSORT in one step. Please help me on this.
Input file
FL1 FL2 (REC Length 8, Fixex Block)
--- ---
PPP AAA1
PPP A ... |
Topic: Split HTML record using tags |
guhanath
Replies: 11
Views: 9034
|
Forum: Utilities Posted: Mon Sep 12, 2016 12:16 am Subject: Split HTML record using tags |
Hi Magesh,
Thanks for coding on SORT. I will check this and post you if any thing either work or not.
@Kolusu,
Thanks. Yes, I can understand the business rules. Any how i will check it in S ... |
Topic: Split HTML record using tags |
guhanath
Replies: 11
Views: 9034
|
Forum: Utilities Posted: Sat Sep 10, 2016 7:34 am Subject: Split HTML record using tags |
Hi Kolusu,
Thanks for your help. I have tried with your code but got RC=12 with below error message.
SYT000I SYNCTOOL RELEASE 1.7.0 - COPYRIGHT 2008 SYNCSORT INC.
SYT001I ... |
Topic: Split HTML record using tags |
guhanath
Replies: 11
Views: 9034
|
Forum: Utilities Posted: Fri Sep 09, 2016 3:55 am Subject: Split HTML record using tags |
Hi Kolusu,
Sorry for confusion. My input file record length is 300 (FB) and each record contains the string '</TD>'. I want to break the record after '</TD>' string.
Suppose one rec ... |
Topic: Split HTML record using tags |
guhanath
Replies: 11
Views: 9034
|
Forum: Utilities Posted: Thu Sep 08, 2016 12:19 pm Subject: Split HTML record using tags |
Hi Magesh,
Thanks for looking into this.
Yes. The Rec1 and Rec2 are in a single line (Single Record) with LRECL=300. |
Topic: Split HTML record using tags |
guhanath
Replies: 11
Views: 9034
|
Forum: Utilities Posted: Thu Sep 08, 2016 8:16 am Subject: Split HTML record using tags |
Hi,
I am having an input file which is in format of html tags.I would like to split each record from input file after by '</TD>' string. Below given the sample input and required output file ... |
| |