access escape character - HELP

  • Thread starter Thread starter thriveni
  • Start date Start date
T

thriveni

I use access 2000
I have a string "first\\second\\third" and i have a
functiopn that finds the word that i need based on the
delimiter. when i have \\ as the delimiter, and i want the
second word, i get back \second as the word. how do i
escape. single quote does not work.
any help will be appreciated.
 
Hum, not sure what you mean by escape character in this context?

If you have the string of:

dim strTest as string


strTest = "first\\second\\third"

Then:

debug.print split(strTest,"\\")(0) gives "first"
debug.print split(strTest,"\\")(1) gives "second"
debug.print split(strTest,"\\")(2) gives "third"

The above example thus does NOT return any "\" characters at all. Hence, the
split function is most useful for parsing text.

Thus, if you don't return a "\" in your results, then you don't have to
worry about the "\" being ignored in conditions. If by escape char you mean
that the letter case matters when you do a test "=" condition of text, then
you have to use strcomp function.

Right now, all conditions do ignore case in text.
 
If you're still stuck with this, try posting the code for the function, then
we may be able to see what the problem is.
 
thriveni said:
I use access 2000
I have a string "first\\second\\third" and i have a
functiopn that finds the word that i need based on the
delimiter. when i have \\ as the delimiter, and i want the
second word, i get back \second as the word. how do i
escape. single quote does not work.
any help will be appreciated.
Click to expand...
 
Back
Top