Manipulating strings.. Get everything after 4 place!

[AT76]

Hi,

I'm trying ignore the 1st 4 characters in a string and capture the rest. I've used the Left and Right Functions before but I'm not sure how to ignore the a specified amount. Any help would be greatly appreciated!

 

[PHV]

Mid(yourString, 5)

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[RoyVidar]

Mid function?

[tt]mid$(strYourString, 5)[/tt]

Roy-Vidar

 

[Remou]

I think this is one for Mid.
Mid(strString,5)

 

[EBGreen]

strTest = "1234567890"

strAnswer = Right(strTest, Len(strTest)-4)

[red]"... isn't sanity really just a one trick pony anyway?! I mean, all you get is one trick, rational thinking, but when you are good and crazy, oooh, oooh, oooh, the sky is the limit!" - The Tick[/red]

 

[Remou]

Um Snap?

 

[EBGreen]

Because I like being different.

[red]"... isn't sanity really just a one trick pony anyway?! I mean, all you get is one trick, rational thinking, but when you are good and crazy, oooh, oooh, oooh, the sky is the limit!" - The Tick[/red]

 

[AT76]

Wow!! Thanks!

 

[PHV]

EBGreen, your code raises an error if strTest is less than 4 characters ...

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[EBGreen]

Now you're just being picky.

[red]"... isn't sanity really just a one trick pony anyway?! I mean, all you get is one trick, rational thinking, but when you are good and crazy, oooh, oooh, oooh, the sky is the limit!" - The Tick[/red]