Thank you for putting that so kindly. I feel a bit stupid now, and shall crawl back into my corner! (it took me a while to find position of the inches/quote character, and I just assumed this would be even harder and tackled it accordingly!)
On 22/10/09 16:35, "John Haley" <[email protected]> wrote: > I think just using a single "/" should work. > > I tried: > Position ( "test/five" ; "/" ; 1 ; 1 ) > an got a result of 5. > > John > Mac OS X.6 FileMaker 10.0v3 > > On Oct 22, 2009, at 10:28 AM, Emma Glaisher wrote: > >> I am manipulating fields which contain data like >> 8.5"/21cm >> 17x25x21" h/44x64x54cm h >> >> I need to find the position of the backslash character (because otherwise >> there isn¹t much consistency). The calculation that seems logical to me: >> >> Position(Dimensions;"//";1;1) >> >> but it returns 0. I¹ve been tearing my hair out trying every combination of >> // and /\ and \/ and //// and \\\\ <smb:////> ! Nothing works. >> >> Surely this can be done? >> >> Thanks >> Emma >> > > > > > > Inbound email scanned by Mimecast <http://www.mimecast.co.uk> . > > <BR> Emma Glaisher Artworker and Database Development Fourninety Limited <BR> Tel: 0113 238 2447 http://www.fourninety.com/ ----------------------------------------------------------------------------------------------------------------------------------------- Fourninety Limited, a member company of the Media Square plc group. Registered in England No. 3737606. Registered address Clarence Mill, Clarence Road, Bollington, Cheshire. SK10 5JZ Confidentiality Notice: The information in this document and any attachments are confidential. It is intended only for the use of the named recipient. If you are not the intended recipient please notify us immediately and delete this document. The contents on this document must not be disclosed to any other person nor may any copies be taken. The views of the author may not represent the views of the Company. Security Warning: This e-mail has been created in the knowledge that Internet e-mail is not a 100% secure communications medium. All liability for any claims arising as a result of using this medium to transmit information by us or to us is excluded to the extent permitted by law. -----------------------------------------------------------------------------------------------------------------------------------------
