Hi - I need some help to create a regular expression that will parse a line of comma separated values. The problem is that, some of the values have embedded commas that I want to ignore. Here's an example...
100,to_date('18-Jan-2001','dd-mon-yyyy'),-6,0,1,0,1,'M','Male',10,'2','M'
Look at the value starting to_date...., I don't want the embedded comma to act as a value separator.
Can anyone help with a Regex I can use on String.split to get an array of the values?
Thanks
Dave.