remove last character from a "string"?

[Gary Smith]

Hello--

Strings -- I hate 'em! Can anyone tell me how to remove
the last character from a string (which as it happens is
always a " )?

I have a variable set equal to a string, and I want to
reset the variable to be equal to itself, minus the last
character. To wit:

Duren or Iwanowski"

becomes...

Duren or Iwanowski

As always, any forthcoming assistance -- much appreciated.

--Gary

 

[Cheryl Fischer]

How about ...

MyString = Left(MyString, Len(MyString)-1)


hth,

 

[Gerald Stanley]

Try

strVariable = Mid(strVariable,1,Len(strVariable) - 1)

Hope This Helps
Gerald Stanley MCSD

 

[Gary Smith]

Cheryl-- I knew it would be obvious once I saw it in
print... Thanks. --Gary

 

[Gary Smith]

Thanks, Gerald. --Gary

-----Original Message-----
Try

strVariable = Mid(strVariable,1,Len(strVariable) - 1)

Hope This Helps
Gerald Stanley MCSD
.

 

[Cheryl Fischer]

You're welcome!