Reverentjim kindly gave me this code the other day that worked well. There are two more things i am trying to do but cant get my head around it.
1) I want to be able to extract the text after the second \ and before the period
2) if exists, I want to change the text to lower after the period
dim str as String = "C:\Users\profile.DOMAIN"str = str.Substring(0, 1).ToLower & str.Substring(1)