get rid of 

[R@emdonck]

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]

[Iain17]

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.

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

[R@emdonck]

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

[Iain17]

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?

[Yonatan]

Does it matter?

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.

[Yonatan]

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

[AKA]

Isn't

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

a better solution ?

[Yonatan]

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