>What if someone uses the [ and ] within the data? Whouldn't I have the same issue that I am having with embedded " and its use as the delimiter as well?
>
>Thanks
>Dean
Yes, you could. But you would only have the problem if they were trying to use all three types in one statement. You could check for the existing type and make the outer delimiters whatever wasn't used.
If data contains ' and " use [] for the outer delimeters.
if data contains ' and [ or ] use " for the delimiters.
if data contains " and [ or ] use ' for the delimiters.
You'd only have problems if they used all 3 and then you are just out of luck!