Bayesatthemoon
New Member
- Joined
- Oct 21, 2015
- Messages
- 7
I want to extract a product code from an image url. Typical image url: http://s19.postimage.org/h3lmxzcar/RB2132_710.jpg in which the product code is RB2132_710
RB2132_710 has ten characters including the _, other product codes are longer or shorter. However, each image url begins with 35 characters ("http://s19.postimage.org/h3lmxzcar/") and ends with ".jpg"
So I want a mid function which extracts all characters after the 35th character and before the value ".jpg"
Any gurus out there who can help me please?
RB2132_710 has ten characters including the _, other product codes are longer or shorter. However, each image url begins with 35 characters ("http://s19.postimage.org/h3lmxzcar/") and ends with ".jpg"
So I want a mid function which extracts all characters after the 35th character and before the value ".jpg"
Any gurus out there who can help me please?