UDF code

[Former Member]

Hi

I need a UDF code to achieve the below requirement

I have a text file with multiple line items and each line item consisting of 4 fields

I have to sort that file on the date ie club all the line items of a particular date together and process them first

eg

ABC 123 2009-05-12 erty

DEF 546 2009-06-23 ghyt

GHT 456 2009-05-12 lyuy

JYT 765 2009-05-23 kjuy i

s the source file and i have to sort it in the below fashion

ABC 123 2009-05-12 erty

GHT 456 2009-05-12 lyuy

DEF 546 2009-06-23 ghyt

JYT 765 2009-05-23 kjuy

i.e clubbing all the records with the same date first and then processing them first and the rest later

Can this be achieved in message mapping .. ?

Code please

thanks

Rohan

[stefan_grube]

> Can this be achieved in message mapping .. ?

No. The graphical mapping tool can only process XML files, not plan text.

You can achieve this with Java mapping, but I think you should sort the file with a script with help of OS commands.

Regards

Stefan