Regular Expression and filenames help

[spac3m0nk3y]

I'm trying to put together a script to copy certain files, but I'm having trouble with my RegExp. I currently have:

\d+-\d+-\d+ (.*?)\.doc

which matches filenames like so:

Johnson 07-17-2007 JDM.doc

Smith 07-12-2007 BKS.doc

I need a RegExp to recognize files like:

Public 07-17-2007 PQRI JDM.doc

Smith 07-17 2007 ADD HRT.doc

Johnson 07-17-2007 2 TRK.doc

Right now, my regexp returns everything after the date and before .doc. I only need the part in red returned.

If somebody could tell me if this is possible, or point me to a good regexp tutorial on how to do it, I would be grateful.

[GMK]

What are some examples of files that would be excluded?

[spac3m0nk3y]

What are some examples of files that would be excluded?

No files would be excluded. All the files in the directory would follow the same filename pattern, just some would have the extra characters before the initials.

Edited July 17, 2007 by spac3m0nk3y

[GMK]

I don't suppose you could just copy all *.doc files?

[spac3m0nk3y]

I don't suppose you could just copy all *.doc files?

No, it's not that simple. I need the initials because I have to copy different files into different folders.

[Outshynd]

If it's always 3 initials, you could just use StringRight to return the 7 pertinent characters (including the .doc). Otherwise, you could StringSplit with a delimiter of " " and read the last value in the array, which would be "XXX.doc". As far as RegExp, I'm sure someone else will be much, much more help than I am.

[spac3m0nk3y]

If it's always 3 initials, you could just use StringRight to return the 7 pertinent characters (including the .doc). Otherwise, you could StringSplit with a delimiter of " " and read the last value in the array, which would be "XXX.doc". As far as RegExp, I'm sure someone else will be much, much more help than I am.

Yeah, I thought about doing it that way, but I was hoping there was a way I could do it with StringRegExp instead. I'm trying to learn a little more about RegExps, but this has me stumped.

[Toady]

why dont u just do. spare the headache...

$string = StringSplit("Public 07-17-2007 PQRI JDM.doc", " ")
MsgBox(0,"",StringRegExpReplace($string[$string[0]],"(.doc)",""))

[spac3m0nk3y]

why dont u just do. spare the headache...

$string = StringSplit("Public 07-17-2007 PQRI JDM.doc", " ")
MsgBox(0,"",StringRegExpReplace($string[$string[0]],"(.doc)",""))

Ok, thanks, I'll give that a try.

[Toady]

Actually...

$string = "Johnson 07-17-2007 2 TRK.doc"
MsgBox(0,"",StringRegExpReplace($string,"(.*?) |(.doc)",""))

Edited July 17, 2007 by Toady

[spac3m0nk3y]

Actually...

$string = "Johnson 07-17-2007 2 TRK.doc"
MsgBox(0,"",StringRegExpReplace($string,"(.*?) |(.doc)",""))

That doesn't return anything. Your first StringRegExpReplace does return the initials though.

[Toady]

Any file extension..

$string = "Johnson 07-17-2007 2 TRK.doc"
MsgBox(0,"",StringRegExpReplace($string,"(.*?) |(\..*)",""))

[Toady]

Dont return anything? It returns for me.

[Xenobiologist]

Hi,

(?<=[ ])\w+(?=\.\w+)

So long,

Mega

[spac3m0nk3y]

Hi,

(?<=[ ])\w+(?=\.\w+)

So long,

Mega

Ummm... thanks... I guess. I have no idea what that does.

[spac3m0nk3y]

Nevermind my last post, i got it.

[Toady]

Your welcome....

[Xenobiologist]

Hi,

it was meant to show your results like this:

#include<Array.au3>
; Filename
Global $str = 'Public 07-17-2007 PQRI JDM.doc Smith 07-17 2007 ADD HRT.doc Johnson 07-17-2007 2 TRK.doc'
Global $re = StringRegExp($str, '(?<=[ ])\w+(?=\.\w+)', 3)
_ArrayDisplay($re)

So long,

Mega