Hive removing special delimiter in cloumn

hive

#1

in Hive one of the column have data like below how can i remove special delimiter in column data.
My dataset set is as below:

700,Angus (1995),Comedy

702,Faces (1968),Drama

703,Boys (1996),Drama

704,“Quest, The (1996)”,Action|Adventure

705,Cosi (1996),Comedy

747,“Stupids, The (1996)”,Comedy

Since the rows have comma separated values, the records like 704,“Quest, The (1996)”,Action|Adventure returns Quest as title, instead of Quest,The (1996).

And Genre value is shown as The(1996) instead of Action|Adventure.

How to load such data correctly by escaping the delimiter in the value ?

Could you please elaborate to resolve this issue.