View previous topic :: View next topic
|
Author |
Message |
gileshpg
New User
Joined: 22 May 2008 Posts: 27 Location: Bangaluru
|
|
|
|
Hi,
I have an input as below (length=80bytes)
AAAA 20140101 20140131
AAAA 20140201 20140228
AAAA 20140301 20140330
Required output is (length=80bytes)
AAAA 20140101 20140330
I need to get the date1 from first record and date2 from 2nd record.
Is it can be done using ICETOOL? The number of records can be varying.
Please help
Thanks |
|
Back to top |
|
|
Pandora-Box
Global Moderator
Joined: 07 Sep 2006 Posts: 1592 Location: Andromeda Galaxy
|
|
|
|
Quote: |
I need to get the date1 from first record and date2 from 2nd record. |
Are you sure I see the date2 taken from third record
Quote: |
The number of records can be varying. |
1.How many records do you expect on a high volume flow day?
2.If the records are varying still should the data taken from 1st and 2nd record ( It is first and third here in output is that typo) |
|
Back to top |
|
|
gileshpg
New User
Joined: 22 May 2008 Posts: 27 Location: Bangaluru
|
|
|
|
correction!
I need to get the date1 from first record and date2 from last record.
It can have n number of records.
sorry for the confusion. |
|
Back to top |
|
|
Pandora-Box
Global Moderator
Joined: 07 Sep 2006 Posts: 1592 Location: Andromeda Galaxy
|
|
|
|
Is it always from first two records? |
|
Back to top |
|
|
gileshpg
New User
Joined: 22 May 2008 Posts: 27 Location: Bangaluru
|
|
|
|
no, there it can have n number of records
I need to take the date1 from first record and date2 from last record
Last record can be n'th record |
|
Back to top |
|
|
Bill Woodger
Moderator Emeritus
Joined: 09 Mar 2011 Posts: 7309 Location: Inside the Matrix
|
|
|
|
Have a look at this one to see if you can adapt it to your requirement.
Or you can look at ICETOOL's SELECT with LAST, You'll need a USING file. You might be able to work on this one. |
|
Back to top |
|
|
|