String parse 2

[nastar1]

I have captured the filename from a hyperlink textbox that has a full c: drive path and filename, into another textbox.

This has resulted in a trailing "#" and I'd like to remove it before applying the FileCopy function to it.

I think I know how to capture a string extract using the Right function:
strFileName = Right(txtTaskD.Value, Len(txtTaskD.Value) - InStrRev(txtTaskD.Value, "\"))
, but have not found sample code out here that shows how to strip any of the trailing characters.

I've tried Right(txtIdrv, 1) - 1, but get a type mismatch error.

 

[TheAceMan1]

How are ya nastar1 . . .

Have a look at the [blue]HyperLinkPart[/blue] Method!

See Ya! . . . . . .

Be sure to see thread181-473997
Also faq181-2886

 

[ProgramError]

strFileName = left(strFileName,len(strFileName)- numberofcharacterstostrip)

Ian Mayor (UK)
Program Error
Always make your words sweet and nice. Because you never know when you may have to eat them.

 

[nastar1]

ProgramError,

The Left function did the trick. Thank you.


Aceman, thanks for the hyperlinkpart hint. I may be able to use that in another area.