Delete Specific Strings in a cell in MS Access

[robryanp]

Hello,
I'm trying to update a column which contains the following text
"ProductImages/SAFA/sample_image_name.png"

1st Part: ProductImages/
2nd Part: SAFA/
3rd Part: sample_image_name.png (need to save/keep this text)

The text "ProductImages/" is standard in every row.
While the text "SAFA" is dynamic which is also shown in another field called
Product_Group

Final goal is to update the cell to show only the image name: "sample_image_name.png"

My only way do this so far is via find and replace options of MS Access.
the other way i found so far was using an expression on update query to
Replace("","(ProductImages/)","")

Please help me.
Thank you in advance! Cheers

 

[pbaldy]

Check out the InStrRev() function, and the Mid() to use the position found.

 

[TJPoorman]

You could also use a variant and Split() the string. Then use UBound() of your variant to grab the final string in the array.