Remove text within quotes in a string
I am reading file values by position with comma-separated string and it gives me incorrect values on the below line because there is a comma within double quotes within a string.
I would like to remove any text that has quotes with object script or alternatively separate each value with pipe-delimited so that I can return position 8 as code and position 9 as a description
s description = $P(line,",","9")
s code = $P(line,",","8")
12162,CHAPTER I,Certain infectious and parasitic diseases (A00-B99),003 (A20-A28),Certain zoonotic bacterial diseases,A28,"Other zoonotic bacterial diseases, not elsewhere classified",A28,"Other zoonotic bacterial diseases, not elsewhere classified",N,N,N,N,N,,,,,,,,,,