hi, working on a sound media archival project which includes photo
documentation entered into a single field with each image separated
by a semi-colon. i would like to write a calculation that will allow
the user to open up all "; "-separated values in separate browser
windows in one go when clicking on the field label (button). i will
also use the calculation to list all the URLs related to a record on
separate lines in an email to the owner of the archive materials
documented in the record.
is this possible? i wrote a script that goes through the values, but
i am hoping to find a simpler solution, without having to have a
series of If calculations on each line (there can be from 1 to over
15 photos for a single media)
"www" & LeftWords ( Photos ; 1 ) & ".jpg"
"www" & MiddleWords ( Photos ; 2 ; 1 ) & ".jpg"
"www" & MiddleWords ( Photos ; 3 ; 1 ) & ".jpg"
thanks,
jef
--
.jef.chippewa.
mailto:[EMAIL PROTECTED] | http://newmusicnotation.com/chippewa/
.shirling.&.neueweise.
mailto:[EMAIL PROTECTED] | http://newmusicnotation.com