Trim function

[Michael]

Any ideas on how to trim a variable length string such as
123^456^789
The result in this case I need would be 789. However the
length of the string is never constant.
Thanks for your insight!

 

[Guest]

Oh yeah, and those carrots (^) are always there.

 

[Guest]

I'm assuming that the "^" is a delimiter. that is you
want everything after the last "^"...
From what I've seen there is no one command. You may have
to loop through the string (Str) using the InStr function
to find the position of the last occurence of the "^"
(Pos.) Then do a Right(Str, len(Str) - Pos + 1)

Don

 

[Dirk Goldgar]

Oh yeah, and those carrots (^) are always there.

Carets, you mean.

 

[Dirk Goldgar]

Any ideas on how to trim a variable length string such as
123^456^789
The result in this case I need would be 789. However the
length of the string is never constant.
Thanks for your insight!

Dim strSource As String
Dim strWanted As String

strSource = "123^456^789"

strWanted = Split(strSource, "^")(2)

 

[John Vinson]

Carets, you mean.

now, now... don't hit him with a stick. Positive reinforcement works
better!

 

[Dirk Goldgar]

now, now... don't hit him with a stick. Positive reinforcement works
better!

;-)