>Hi All,
>
>
>I want to process a comma delimited file with text qualifier of quotes(") - I have a line like so
>
>"112.89","Mike Shotz","123,1222.90","12,234.90"
>
>Is there any control I can use to process this string besides the split doesn't work as well in this situation.
>
>Thanks!
Carl -- would something like this work? I am basically replacing the comma with a different delimiter. Of course, I am only replacing the commas that fall between quotes.
aTest = Split(Replace(strTest, """,""", """%_DELIMITER_%"""), "%_DELIMITER_%")
This code keeps the quotes on there, too.... I am not sure if that is desirable or not. You could always take them off in your calling code....
The whole problem with the world is that fools and fanatics are always so certain of themselves, but wiser people so full of doubts. - Bertrand Russell