Regular expression to extract filename after a character and without extension

Question

Hello, I am looking for help in how to create a regular expression that extracts a substring from a string that looks like the following:

test123 #AMMA-TestFileName File's.xml

to...

AMMA-TEstFileName File's

Basically, removing the first "#" and everything before it. In addition, removing the ".xml" file extension.

Any help is appreciated as I am just getting started with regex. This is going to be used in a Nintex workflow action that supports the .NET regular expressions API.

Answer 1

The string you are looking for will be in the first group.

/#(.+?)\.xml$/

In C#

String extractFilename(String s) 
{
    Regex r = new Regex(@"#(?<filename>.+?)\.xml$", RegexOptions.Compiled);
    return r.Match(s).Result("${filename}"); 
}

edits: removed escaping the #, added end of line qualifier for extension, and added C# example

Answer 2

Anchor the pattern at the end of the string:

/#(.+)\.xml$/

Answer 3

if you want to take care of extensions other than xml

/#(.+)\..*$/

Answer 4

Edit: obviously this is not Regex, but it is faster than regex for this use so I included it.

Path.GetFileNameWithoutExtension(s.Substring(s.IndexOf('#') + 1));