开发者

MS-Access 2007, Replace RegEx with data

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

上一篇:

下一篇:

精彩评论

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

最新问答

问答排行榜