Page 1 of 1

To manipulate date using SORT

PostPosted: Tue May 26, 2009 11:55 pm
by praveen_nayak17
:?: Hi All,

Could anyone help to subtract one day from a date filed(in YYYYMMDD format) in input file and write it in output file using sort???

Below is the sample file having date:
20090526
20090525

Expected output file should have records as
20090525
20090524

Thank you ...
Praveen Nayak

Re: To manipulate date using SORT

PostPosted: Wed May 27, 2009 12:13 am
by Alissa Margulies
Hello Praveen.

At this time, SyncSort does not have a special function to perform arithmetic on input date fields. We can only provide offsets to the current system date. However, I would be happy to speak with development to see if this can be incorporated into a future release of the product.

Regards,

Re: To manipulate date using SORT

PostPosted: Wed May 27, 2009 12:28 am
by arcvns
I would be happy to speak with development to see if this can be incorporated into a future release of the product.
Looking forward to see that one in SyncSort. :)