Hi,
I am using a CCK component for Joomla. Users can upload images, but the
CCK stores the internal path for the images and I need to export the
web URLs via vData Feed.
Source records e.g.:
"/home/xxx/public_html/etc/xxx.jpg"
"/home/xxx/public_html/etc/xx2.jpg"
Need to export:
"
www.xxx.com/public_html/etc/xxx.jpg
"
"
www.xxx.com/public_html/etc/xx2.jpg
"
In "Profiles" I experimented with the column field with "As defined"
and tried several @vdsql and @vdphp functions with substr_replace etc to replace
the string "/home...", but failed to have the expected result, as the string
would be completely replaced.
Any help for the right function would be so much appreciated.
cheers
