I would like to convert an existing channel field that is a text input fieldtype that has image links in it like:
https://ellislab.com/asset/images/features/sosol-logo.gifInto a file fieldtype, which stores the same file as:
https://ellislab.com/asset/images/features/sosol-logo.gifI have about 500 existing entries with images in the field at the moment and so need to run a search and replace to remove the extra stuff.
So what I need help with is the query and regular expression that covers all the options that I can run through the “Search and Replace” data tool. The field_id is 14.