Hello somesoni2,
Thank you for your help but it is more complicated because that can be happen that another field3 appear with the same field1 value, for example :
9/25/14 2:05:57.000, PM field1=abc, field2=ghi2
9/25/14 2:05:56.000, PM field1=abc, field2=def2
9/25/14 2:05:55.000, PM field1=abc, field2=abc2, field3=xyz3
9/25/14 2:05:48.000, PM field1=abc, field2=ghi2
9/25/14 2:05:47.000, PM field1=abc, field2=def2
9/25/14 2:05:46.000, PM field1=abc, field2=abc2, field3=pzo3
And with your search, I have this :
9/25/14 2:05:57.000, PM field1=abc, field2=ghi2, field3=pzo3
9/25/14 2:05:56.000, PM field1=abc, field2=def2, field3=pzo3
9/25/14 2:05:55.000, PM field1=abc, field2=abc2, field3=pzo3
9/25/14 2:05:48.000, PM field1=abc, field2=ghi2, field3=pzo3
9/25/14 2:05:47.000, PM field1=abc, field2=def2, field3=pzo3
9/25/14 2:05:46.000, PM field1=abc, field2=abc2, field3=pzo3
And I would like to have this :
9/25/14 2:05:57.000, PM field1=abc, field2=ghi2, field3=xyz3
9/25/14 2:05:56.000, PM field1=abc, field2=def2, field3=xyz3
9/25/14 2:05:55.000, PM field1=abc, field2=abc2, field3=xyz3
9/25/14 2:05:48.000, PM field1=abc, field2=ghi2, field3=pzo3
9/25/14 2:05:47.000, PM field1=abc, field2=def2, field3=pzo3
9/25/14 2:05:46.000, PM field1=abc, field2=abc2, field3=pzo3
Any idea ?
Thanks for your help,
Regards,
... View more