string problem

[JazzLeg]

Hi,

I would like to remove the 5th and 6th characters from a string.

Therefore "helloo" to "hell"

How can I do this?

Thanks

 

[FesterSXS]

If the original string is always going to be 6 characters then you can do this simply by using:

strString = "helloo"
strString = Left(strString,4)

If your string will be longer than 6 characters and you wish to remover characters 5 and 6 - eg) "helloohelloo" to become "hellhelloo" then you need to do the following:

strString = "helloohelloo"
strLeft = Left(strString,4)
strRight = Right(strString,Len(strString-6))

strString = strLeft & strRight

Tony

http://www.phoenix-paints.co.uk/portfolio

 

[mwolf00]

Another way to do this is to use the MID function.


myStr = "helloohelloo"
editStr = MID(myStr,1,4) + MID(myStr,7)

I don't know if this is any better than then FesterSXS's answer - it just gives you another option...