Hi
I am sure people must have done this before and do not want to reinvent wheel, but I cannot located succinct answer.
I wish to parse quote qualified string into fields so can obtain nth field. Although sometimes, may not be quote qualified. Looking for plsql function to get nth field
eg input strings
"abc","123","def","456" where 3rd field is def
abc,123,def,456 where 4th field is 456
"abc","123,321","def","456" where 2nd field is 123,321
apex_string.split nearly does this, but does not handle quote qualified.
Any assistance appreciated.