Jef
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.
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 - eg.
Filter(PhotoTag; "0123456789;,") would give you numbers plus the two
delimiters indicated.
hope this is useful...
Stephen
On Feb 5, 2008, at 7:54 AM, jef chippewa wrote:
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
-------
This to send for electrónico post office is really private. If vocês
n'êtes not it addressee or a spouse of the addressee or d'un
authorized addressee of this message, any distribution, copying, the
publication, I sing, polissage, making to cook, the painting, to
reformulate or l'utilisation of this information for n'importe which
objectivo another one that the objectivo that is the objectivo is
forbidden excluded where empty for law. They want to inform
l'expéditeur for poney immediately propositadamente and seguidamente
they suppress or they redistribute this message as it amuses them.
