Data Manipulation in a Flat file

[narasimha]

Awsome :D

Amruta, Thank you for your effort, I really appreciate it.
You guys are great, thanks "all" for your wonderful ideas.

Ken without your initial ideal, I guess it would have been difficult to move in this direction (I guess thats why its called premium content )

I just had to make slight changes to the stage variables
I am writing my changes so it may help somebody

In in Transformer A (To handle ^M on a Unix machine)

Code: Select all

StageVar1 =Str(DSLink2.Field1:char(13):char(10), StageVar+1)

To

Code: Select all

StageVar1 =Str(DSLink2.Field1:char(10), StageVar+1) 

In in Transformer B
(I guess I had put in a file example which had all the consequetive first field different, so it would not handle if the series of numbers had the same first field

Code: Select all

StageVar =RowProcCompareWithPreviousValue(Field(DSLink3.Field1,',',1))  

To

Code: Select all

StageVar =RowProcCompareWithPreviousValue(DSLink3.Field1)