hi, i can't quite solve this, wonder if anyone
has a solution. FM7, but i need to upgrade to 8
soon, so FM8 are also welcome.
PHOTOS contains such data as: [55 (C); 999 (B), 1000]
PHOTOS IN HTML is a calculation:
"http://address.com/DSC0"; & Substitute ( Photos ;
[ " " ; "" ] ; [";" ;
".jpg¶http://address.com/DSC0";] ; [ "(B)" ; "" ]
; [ "(C)" ; "" ] ) & ".jpg"
i need zeros added to values stored in PHOTOS
that are <1000 (to make them all 4-digit numbers)
so that a script to open the related web address
runs properly. i also use the list found in
PHOTOS IN HTML for inclusion in text
documentation and emails, so i need to keep each
value (html address) on separate lines.
i guess there would be two possible solutions:
- add the needed zeros directly in PHOTOS
- add the needed zeros in the PHOTOS IN HTML calc
i really prefer the second, since searching in
the field with the first solution would require
also typing the zeros.
cheers,
jef
