Thanks a lot for all the reply. I'm generating csv for crystal report. If i replace , with | Crystal report is not identifying a separate column.. All i did is used "=~ s{,}{::comma::}g;" as advised by John BRs