hi stephen,
For FMP 8.5+ (maybe earlier - I don't recall
when it was added) you can use FILTER function
to strip chars you don't want...
yep, also in FM7, thanks, simplifies the calc.
right("0000" & PhotoNumber;4) will give you 4
digits where PhotoNumber < 1000. You will need
a little data parsing dance if your data
includes multiple numbers as indicated.
great, thanks! now i just have to find out how to
use your suggestion "Right ( "0000" & Photos ; 4
)"
or is there any way of using the Replace (or
Substitute) function in the calculation below to
locate all occurences within the resulting calc
(Photos in html) of words starting with "DSC0"
and having >8 characters? then instead of "DSC0"
i could prefix "DSC0000" to all values and strip
the appropriate character(s) starting at the 5th
character in all relevant words.
"http://address.com/DSC0"; &
Substitute ( Filter ( Photos ; "0123456789;" ) ;
";" ; ".jpg¶http://address.com/DSC0"; ) &
".jpg"
