Odd symbol when stripping characters using vba

Status
Not open for further replies.
H

hlock

I'm coming across an odd symbol when I'm trying to strip out the illegal

characters in the subject line of an email. I can't replicate the symbol,

but have a .jpg picture of it. In the email subject line it usually appears

as a blank space. In the vba statement it looks like a vertical line with

horizontal elbow line to the right. If anyone knows what it might be, do you

have any suggestions on how to remove it?

Thanks!
 
How do you remove what?

Best regards

Michael Bauer

Am Tue, 22 Dec 2009 11:50:01 -0800 schrieb hlock:


> I'm coming across an odd symbol when I'm trying to strip out the illegal
> characters in the subject line of an email. I can't replicate the symbol,
> but have a .jpg picture of it. In the email subject line it usually


appears
> as a blank space. In the vba statement it looks like a vertical line with
> horizontal elbow line to the right. If anyone knows what it might be, do


you
> have any suggestions on how to remove it?
> Thanks!
 
What is the character value of that odd symbol? Use the ASC() function to

get a number so we know what you're talking about.

"hlock" <hlock> wrote in message

news:F05A989A-F335-425D-B80A-12AC6458EFFD@microsoft.com...
> I'm coming across an odd symbol when I'm trying to strip out the illegal
> characters in the subject line of an email. I can't replicate the symbol,
> but have a .jpg picture of it. In the email subject line it usually
> appears
> as a blank space. In the vba statement it looks like a vertical line with
> horizontal elbow line to the right. If anyone knows what it might be, do
> you
> have any suggestions on how to remove it?
> Thanks!

>
 
It is a tab character that is showing up in the subject line of some emails.

Ascii character 9. Since we use the subject line as the name of the email

file, I was able to replace it with an underscore. Thank you for your help.
wrote:


> What is the character value of that odd symbol? Use the ASC() function to
> get a number so we know what you're talking about.

> >

>

> "hlock" <hlock> wrote in message
> news:F05A989A-F335-425D-B80A-12AC6458EFFD@microsoft.com...
> > I'm coming across an odd symbol when I'm trying to strip out the illegal
> > characters in the subject line of an email. I can't replicate the symbol,
> > but have a .jpg picture of it. In the email subject line it usually
> > appears
> > as a blank space. In the vba statement it looks like a vertical line with
> > horizontal elbow line to the right. If anyone knows what it might be, do
> > you
> > have any suggestions on how to remove it?
> > Thanks!
> >


> .
>
 
Status
Not open for further replies.

Similar threads

Back
Top