Regular expression requirement

[rnayan]

I am struggling with one requirement where I need to extract a specific string, but I'm unable to get it.

Please help..

String is:

/availability/documents/myfilenamev10.xlsx"targetnew

From above string i want to extract myfilenamev10.xlsx 

Regards,

Rajeev Nayan

[Thableaus]

Hi,

Try REGEX_Replace ([Field1], '.*/(.*?)"', "$1")

Cheers,

[MarqueeCrew]

Did you know that there are file functions?

FileGetFileName(Path): Returns the name portion of the path, without the extension.

OpenExample
FileGetName(C:\Temp\Data\file.csv) returns "file"

FileGetName(C:\Temp\Data) returns "Data"

Try:

Regex_replace([field],".*\/(.*)\".*",'$1')

It just might work too.

Cheers,

Mark

[rnayan]

Thanks Mark,

But Filegetname might not work in this case, because i am extracting this filename from a html response.

Also, the regular expression you provided does not work. It has syntactical error. Please see the screenshot below.

[Thableaus · Accepted solution]

Hi,

Try REGEX_Replace ([Field1], '.*/(.*?)".*', "$1")

Cheers,

[rnayan]

This worked. Thanks alot :)

Cheers,

Rajeev