hi
i have input file in this format
E102|0|1-23-1994|0|12-5-1994|E003|A|10450|charan,devupalli|5000

how to convert this into outfile
E102,0,1-23-1994,0,12-5-1994,E003,A,10450,charan,devupalli,5000

i wann the output in excel sheet.........that is why i am converting into csv..
but i have the name file as firstname, lastname and it should be present in one column charan,devupalli

Pls send me asap.


thanks in advance
cherry