Skip to Content
avatar image
Former Member

UDF code

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Jun 29, 2009 at 09:40 PM

    > 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

    Add comment
    10|10000 characters needed characters exceeded