Quote Originally Posted by snb View Post
I had no intention to present an alternative approach to all the functionality you provided.
As far as I can see the main difference is in which part to replace the delimiter: in your code you replace 'inside' the quotation marks; I do that 'outside' the quotation marks.
You use 2 different replacers: chr(0) & chr(1); I only use 1
That saves some additional replacements.
Sorry about the delay in getting back to you on this. The part I highlighted in red is an excellent observation... when I first developed the code (many years ago now), my thought was I had to actively protect the text inside the quotes, but as your postings indicate... I do not have to do it that way... rather, simply changing the non-quoted delimiters and then directly manipulating those replacements makes the code tighter and more efficient. Thank you for your incites on this... much appreciated. By the way, I have changed the code in my original posting to reflect the changes you suggested.