Hi there,

I'm currently using objFile.Name in a quick indexing script that prints out each file name on a new row. It's very simple, literally just
Please Login or Register  to view this content.
.

The file names I'm using work along a YYYY-MM-DD TITLE REVXX.EXT naming procedure. An example would be 2012-07-10 AwesomeFile REV03.txt.

What I'd like to do is remove everything BUT the YYYY-MM-DD after I print the file name in the cell. This is always the first ten characters.

Secondly, I'd like to search the file name for certain titles and then delete everything in the cell but that title. In my earlier example, this would leave only AwesomeFile in that cell. The current script I'm trying is
Please Login or Register  to view this content.
I thought this would simply re-write the cell value with AwesomeFile if I find AwesomeFile and re-write it with nothing if I don't, but it doesn't.

Would anyone be able to help with these two things? It would be greatly appreciated!