How to handle ' , ' in the data of csv file

Hey...if any of the fields in sql loader script.. eg.. empname is Jain,anisha then how can we handle this ' , ' in Jain,anisha while using csv file in a sql loader

anishajain
Profile Answers by anishajain Questions by anishajain
Mar 7th, 2008
6
5563

Questions by anishajain

Apps Technical

Answer

Showing Answers 1 - 6 of 6 Answers

harishkrishnagowda
Profile Answers by harishkrishnagowda

Apr 4th, 2008

Its better to remove ',' for that column using replace commands
For eg
REPLACE(TRANSLATE(empname, ',{}[]%"?*~&<>$|/@''', ' '),' ')

siddhshah
Profile Answers by siddhshah

Jun 22nd, 2009

One needs to enter the value with double quotes like "Jain, Anisha" to all the values so the comma can be stored in the columns.