If this is really "CSV" format and you simply split on "," you will not obtain a valid set of data, as commas could be embedded in your data. Using one of the CSV UDFs will prevent this. The CSV() UDF that I wrote converts a CSV string to an array, or an array to a CSV string with proper formatting for embedded quotes and commas. If you tightly control your data and can insure that no special chars (quotes, commas, etc) are part of the data fields, then a simple split will work. I think you're asking for trouble assuming that you'll never have special chars in your data, though.
Glenn
_________________________
Actually I
am a Rocket Scientist!
