Advanced Split Function for Data Import..
Posted on 2004-11-08
I was wondering what is a simple but fast way to extract data from a comma delimitad string.
A simple split will not work since certain fields have a String enclosed in a "" and the comma
within the string should not be used as a delimiter.
Below is a sample of a srting i would like to break down correctly
PB/NB,CA, AS3EM, EON INCLUDED BRONZE EVC 501-1000M,OPT-E-MAN,Y,"1J,3J",K,,,U,L,,