Part of a text field

[Ant S]

I have a field containing a file name e.g. My Pictuer_25.jpg where "My
Pictuer" is the title of an image, and "25" is a membership number. I would
like to automatically populate a strTitel field with just the title part of
the file name e.g all left most letters up to but not including the
underscore. I am thinking along the lines of =Left(FileName,???) but don't
know how to "express up to _"

Thanks for any help

 

[Stuart McCall]

I have a field containing a file name e.g. My Pictuer_25.jpg where "My
Pictuer" is the title of an image, and "25" is a membership number. I
would like to automatically populate a strTitel field with just the title
part of the file name e.g all left most letters up to but not including the
underscore. I am thinking along the lines of =Left(FileName,???) but don't
know how to "express up to _"

Thanks for any help

=Left(FileName, Instr(1, FileName, "_") - 1)

The Instr function returns the point in the string where the underscore is.
Then 1 is subtracted from that and the result passed to the Left function.

 

[Ant S]

Thanks Stuart, that worked as did your help with loading file names last
week! almost done now and ready to deploy!

 

[Stuart McCall]

Thanks Stuart, that worked as did your help with loading file names last
week! almost done now and ready to deploy!

Good luck. Hope the client is happy.