I have a text file with thousands of lines like this...
c:\documents and settings\administrator\my documents\$user\ab\aa - backup\test.txt
using vb or vbscript how can i find the last "\" on each line and delete it and all preceding text on that line ?
(just want to be left with the filename and extension on each line)
I have access or excel if its easier to use these..?