Following is the CSV file, separated by ","
100,sunil,$1,000,mumbai
101,amit,$10,000,mumbai
102,sailesh,$10,000,00,mumbai
I want the following output:
100,sunil,$1000,mumbai
101,amit,$10000,mumbai
102,sailesh,$1000000,mumbai
Note: I know the number of fields in the file in advance. In this case it is 4.
Any help is highly appreciated.
Thanks,
SK