PeterClarke
New member
- Nov 12, 2010
- 1
- 0
- 1
Http://www.example.com/1/2/3/aaaa.bmp
Http://www.example2.com/3/2/1/bbbb.bmp
Http://www.example3.com/2/1/1/cccc.bmp
I need to extract just the file name and extension from the above for use in another column and can't figure it out.
The filenames all have 13 characters inclusive of extension, is it possible to work backward and have Open Office delete all characters before the last 13 characters???
Http://www.example2.com/3/2/1/bbbb.bmp
Http://www.example3.com/2/1/1/cccc.bmp
I need to extract just the file name and extension from the above for use in another column and can't figure it out.
The filenames all have 13 characters inclusive of extension, is it possible to work backward and have Open Office delete all characters before the last 13 characters???