I was actually using multiple characters as a separator for fields so I just changed the characters.
My real question comes with high bit characters (> ASCII 128) I would prefer to use them, but they do not seem to work at all.
I wonder if they can be escaped? Hmmmm. I will test that when I have time.
Also, Is there a list of the special characters that need to be escaped. I VBA/Access I more or less know this stuff by heart.
I was just looking at your code again - are you saying '][' is the special character but '[' and ']' separately are not?