get rid of 

Hi,

How do I get rid of  ????

example:

"+R3" has to be "+R3"
How can I do this ???

This mail looked differend.
the "" are small squares

R@emdonck

[Edited by R@emdonck on 08-30-2000 at 04:08 AM]

I am not really sure what you are after. If you always want the first 3 characters, you can use the Left$() function to return the first 3 characters.

Code:

---

strNew = left$("+R3", 3)

---

If this isn't what you are after, post again with a little more information.

Ok VB-world is messing my post up now :(

In a DAO recordset I get the result of a stored procedure from an SQL7 server.
There is a field that returns those little squares, somekind of symbol.
I can paste them in this forum, but when I submit, the are changed by this forum to "#61567"
I need to get rid of them, somehow ...

R@emdonck

That still does not help much. I want to know if there is a pattern to the codes. Is it always the first three characters you want, is it less sometimes, or more?

Does it matter? :rolleyes:

Code:

---

sMyString = "+R3ĕĕĕĕ" ' Or whatever...
sMyString = Replace(sMyString, "ĕ", vbNullString)

---

This SHOULD work with VB6. However, I have VB5 and can't test it. :(
I'm pretty sure that's the correct syntax, though.

Well, there's the forum changing it for you. :rolleyes:
The little fi thing should be &-#-61567-;
(Without the dashes)
I think it's HTML changing it. :(

Isn't

Code:

---

  left$("+R3",instr("+R3", "&")-1)

---

a better solution ?

If you want to preserve the little square symbols, Replace (as in: Replace function) the &-#-61567-; (dashless) thing with: ChrW(61567) :rolleyes: