Search results

Brian and Adam you guys nailed it. I would never of got there by myself. Thanks everyone for your help

sorry lots of reply's in while i was typing my response, give me a minute to try them and i'll be back

Hi sorry i had it slightly wrong the first time I'm using Right([imageName],(InStrRev([imageName],"/")+1)) Which starts off removing the left hand portions of the url and everytime you run it gets closer to the file name but it does not stop at the file name. It keeps removing until only the...

Hi Ken, Thanks for your response an example of one of the URL's is http://media.dorothyperkins.com/wcsstore/DorothyPerkins/images/catalog/17312402_normal.jpg when i run your query it leaves me with a column full of "g" I'm guessing because its the last letter of .jpg

Hi I'm currently an imageURL field in my database. All the url's are different and the image names are different lengths. I'm trying to run an update query to create a field called imageName. In excel it would be fairly easy to just run find and replace using */ which deletes everything to the...