Clip off a String 1

[A1Pat]

Hi,

I know I saw someone in here show how to do this before which is collecting a string of text without the last particular # of character(s) of that string

for ie: Hello World!

and I only want to display
Hello World
(w/o an exclaimation) and I want to use the technique for all other cases that I don't know the length of that string.

Thanks!

 

[Sheco]

You can do a lot with the following functions:
Len()
Mid()
Left()
Right()
InStr()
InStrRev()

 

[A1Pat]

thank you for reminding me of utilizing Len() to get any string LEN and use MID(1,Len-#) to do just that.

Good job!

 

[ChrisHirst]

You're probably thinking of

thread333-882989


Chris.

Indifference will be the downfall of mankind, but who cares?
Woo Hoo! the cobblers kids get new shoes.
People Counting Systems

So long, and thanks for all the fish.