Hi All,

I have a ',' delimited file and i would like concatenate a new value at a specific column.

Example :-
xXXX,XYZ,20071005,ABC,DEF,123
xXXX,XYZ,20071005,ABC,DEF,123
xXXX,XYZ,20071005,ABC,DEF,123


The output that i want is
xXXX,XYZ,20071005001,ABC,DEF,123
xXXX,XYZ,20071005002,ABC,DEF,123
xXXX,XYZ,20071005003,ABC,DEF,123
........
xXXX,XYZ,20071005010,ABC,DEF,123
xXXX,XYZ,20071005011,ABC,DEF,123
and so .... on....

As you see the only difference is in the Column # 3 where i want to add 001, 002, 003 .... till the end of file [ in the above example there are 11 records so last updated value is 20071005011 ], however all other values should remain the same.

Please let me know if you have any doubts about the query.

and thanks for your time.
Amit