RegEx which removes parent directory + trailing text from Filepath

[KaFu 193]

Hiho Forum,

I'm trying to find a regex to do this transformation with StringRegExpReplace().

Input:

"c:\temp\test\_PCs\file_1.avi_PC.jpg"

Output:

"c:\temp\test\file_1.avi"

- Trailing text "_PC.jpg" is removed from string

- Parent directory "\_PCs\" is removed from string too

Can anybody help me out on this one ?

[AZJIO 125]

$test=StringRegExpReplace($test, '^(.*)[^]*(.*)_.*$', '12')

[KaFu 193]

Perfect, thanks a lot !