September 21, 200619 yr TrText-XML function Working from page 25 of manual below [color:green] "If the XML contains multiple occurrences of a node you can retrieve a specific node by adding a number like this: abc/def[2]/ghi[3] This will get the 3rd 'ghi' node from the 2nd 'def' node of abc." Retrieving a specific node with a number as in 2 and 3 above. I was trying to define this number with a variable either a number from another field, function or formula. Example abc/def[2]/ghi[Field G] . Field G being a number or formula result. I have tried this in calculation field and script step and have been unsuccessful. I was not sure if this was a limitation of FMP or Troi text plug in. Or am just not doing it right. Thanks Joe
September 21, 200619 yr Author I emailed Troi support and they got back to me right quick. [color:green]"This calculation should work better: TrText_XML( "-GetNode" ; "abc/def[2]/ghi[" & Field G & " ]" ; XML data ) Note that the field is outside of the text string. Is that clear?" It was not doing it right. Joe
Create an account or sign in to comment