Recent content by Daigriff

Thanks Brian, Left(yourstringname,Len(yourstringname)-3) removes the last 3 Right(yourstringname,Len(yourstringname)-3) removes the first 3 Can you tell me how I could join both of these expressions to remove the first and last 3 characters of a string in one go? Thanks again, daigriff

Hi, I would like to remove the numbers form a field in access e.g. abcd123 to give abcd xyz789 to give xyz Thanks in advance daigriff

Hi, thanks for the advice Mid([File name],InStrRev([File name],".")+1) works a treat daigriff:)

Hi, I need to extract the file extension from a full file name. Unfortunaltly some of the file names have multiple . in the file name e.g. C:\Filename.test.dvd.doc So in the example above I need to extract "doc". Also the length of the file extension varies so I can not just look for the last...