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?
精彩评论