Emma,
You don't have to escape the backslash character. Simply using:
Position(Dimensions;"/";1;1)
should work.
Regards,
Lee.
=================
Binary Assist
220 Gaines Oak Way
Suwanee, GA 30024
Voice: (678) 313-5604
Internet: [email protected]
Website: www.binaryassist.com
FileMaker Certified Developer
On Oct 22, 2009, at 11: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 \\\\ ! Nothing works.
Surely this can be done?
Thanks
Emma
Emma Glaisher
Artworker and Database Development
Fourninety Limited
Tel: 0113 238 2447
[email protected]
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.