Joined: 26 Nov 2002 Posts: 12380 Topics: 75 Location: San Jose
Posted: Thu Jul 09, 2009 12:00 pm Post subject:
kingo,
I assumed that if you input date has a slash(/) then it is MM/DD/CCYY format or else it is CCYY@MM@DD format. Using an IFTHEN we format the date into 8 byte zd date and then sort on that reformatted field and eliminate the dups
Joined: 20 Oct 2006 Posts: 1411 Topics: 26 Location: germany
Posted: Thu Jul 09, 2009 1:26 pm Post subject:
Kingo,
you did a great job of adjusting all the other offsets; i imagine the 24 instead of 25 was a typo, or so concentrated on the 14, you forgot to make it 25.
no problem. I had to go thru kolusu's solution to understand yours, and then I saw that the overlay areas were not the same. _________________ Dick Brenholtz
American living in Varel, Germany
Joined: 26 Nov 2002 Posts: 12380 Topics: 75 Location: San Jose
Posted: Thu Jul 09, 2009 1:36 pm Post subject:
kingo,
Your problem is you have 2 different offsets and that is the reason for your incorrect output. Also remember to change the sort fields also when you changed the offset
Joined: 26 Nov 2002 Posts: 12380 Topics: 75 Location: San Jose
Posted: Thu Jul 09, 2009 1:45 pm Post subject:
Kingo,
You really really need to do a better job of explaining the requirements clearly.
1. You never mentioned your input/output DCB parameters
2. You never mentioned pos or format of the date field to be parsed
3. You never mentioned on what fields the duplicates need to be eliminated
When there isn't enough data we assume and provide you with a solution and then you go back and change it as you think is right and complain it doesn't work . You are just wasting my time as well as your time. Remember we are communicating via web and I have no clue as to what your data looks like or what the requirement is. So please spend time to explain your requirement clearly. _________________ Kolusu
www.linkedin.com/in/kolusu
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum