开发者

MS-Access 2007, Replace RegEx with data

开发者 https://www.devze.com 2023-02-22 04:44 出处:网络
I have a MS-Access 2007 file and a column, that I am trying to replace for the output, the column contains data like:

I have a MS-Access 2007 file and a column, that I am trying to replace for the output, the column contains data like:

\\sad\images\Components\12\123_4.jpg
\\sad\images\Comp开发者_运维技巧onents\112\1125_3.jpg

My Query is

SELECT REPLACE(Path, "\\(\w*).(jpg)", "") AS FILENAME FROM Paths;

The regex identifies the and returns filename like \123_4.jpg, \1125_3.jpg, etc.

But when I run this query, the output has not changed, any help?

0

精彩评论

暂无评论...
验证码 换一张
取 消