Using RegExMatch on file obtained from Loop Topic is solved

[jarhead]

I have a folder of files. In this folder, I need to obtain the name of the one Excel spreadsheet (*.xlsx). The name of the spreadsheet will change depending on when the script I'm trying to create runs so I'm using Loop to obtain the file name. Although the name of the spreadsheet will change, it will always be named using Last Name, First Name File 4-16-2021 so, for example, Smith, John File 4-16-2021.

Once the Loop obtains the file name, I'm attempting to run RegExMatch on A_LoopFileName to obtain just the Smith, John portion of the file name. I'm using the following regex successfully in other scripts that returns the Smith, John portion of the file name:

Code: Select all

.+\\\K.+?, \w+

Long story short, the following script does not work. It is breaking down at the RegExMatch portion of the script as a MsgBox returns nothing when attempting to use the newly created VName variable.

So when I type ;ca and hit space, it should insert the following text → New File Created - Smith, John

Any help is appreciated.

Code: Select all

:o:;ca::
Loop, Files, %A_Desktop%\MyFolder\*.xlsx
RegExMatch(A_LoopFileName, ".+\\\K.+?, \w+", VName)
SendInput, {Text}New File Created - %VName%
return

[boiler]

Code: Select all

FileName := "Smith, John File 4-16-2021.xlsx"
RegExMatch(FileName, ".*(?= File \d+-\d+-\d+\.\w+)", VName)
MsgBox, New File Created - %VName%

[mikeyww]

Try:

Code: Select all

RegExMatch(A_LoopFileName, ".+(?= File [\d-]+)", VName)

Edit: (Followed @boiler, similar idea)

[jarhead]

Code: Select all

FileName := "Smith, John File 4-16-2021.xlsx"
RegExMatch(FileName, ".*(?= File \d+-\d+-\d+\.\w+)", VName)
MsgBox, New File Created - %VName%

Works great! Thanks.

[jarhead]

Try:

Code: Select all

RegExMatch(A_LoopFileName, ".+(?= File [\d-]+)", VName)

Edit: (Followed @boiler, similar idea)

Also works. Thanks!