Hi

I am fairly new to vb and have been trying to write some scripts to do some monotonous tasks at work. This is the scenario:-

Every month we get a list of about 400 users from our HR department. This txt file is basically a list of profiles which need to be deleted for users that have left the company. Below is an example of the list

\\severname\Profiles$\Username
\\severname\Profiles$\Username
\\severname\Profiles$\Username
\\AN\ANDFS\HOMEDIRS4\C0202484\Profile
\\AN\ANDFS\HOMEDIRS6\E1149536\Profile

Now the lines with \\severname\Profiles$\Username are fine but what i need to do is change the lines that are like \\AN\ANDFS\HOMEDIRS6\E1149536\Profile so that they no longer have \Profile at the end. The HOMEDIRS dir and the folder after it change depending on the users ID and we have over 30,000 staff worldwide. I have done a bit of reading on RegExp and it seems the way to go but it totally confuses me. So please please any help would be appreciated.

RB