AnsweredAssumed Answered

MiddleWords function - unexpected results

Question asked by abnms8695 on Aug 16, 2013
Latest reply on Aug 16, 2013 by philmodjunk

Summary

MiddleWords function - unexpected results

Product

FileMaker Pro

Version

11

Operating system version

Windows 7

Description of the issue

MiddleWords function - unexpected results parsing string - i.e. truncating second word

Steps to reproduce the problem

string=AqTot/ICPMets.Al.Sb.As.Ba.Be.Cd.Ca.Cr.Co.Cu.Fe.Pb.Mg.Mn.Hg.Ni.K.Se.Ag.Na.Tl.V.Zn

MiddleWords (string, 2, 1)

returns:
ICPMets.Al.Sb.As.Ba.Be.Cd.Ca.Cr.Co.Cu.Fe.Pb.Mg.Mn.Hg.Ni.K

however this string works:

SolTotDry/ICPMets.Al.Sb.As.Ba.Be.Cd.Ca.Cr.Co.Cu.Fe.Pb.Mg.Mn.Hg.Ni.K.Se.Ag.Na.Tl.V.Zn

ICPMets.Al.Sb.As.Ba.Be.Cd.Ca.Cr.Co.Cu.Fe.Pb.Mg.Mn.Hg.Ni.K.Se.Ag.Na.Tl.V.Zn

Exact text of any error message(s) that appear

no error

Outcomes