PositionValue (text;searchValue;start;occurence)

PositionValue is very similar to the FileMaker function, Position, except that it returns a value position instead of a character position.

PositionValue (text;searchValue;start;occurence)

Let ( [ adjustedText = "¶" & text & "¶" ; positionStart = Length ( LeftValues ( text ; start - 1 ) ) ] ;

If (

Position ( adjustedText ; "¶" & searchValue & "¶" ; PositionStart ; occurrence ) = 0 ; 0 ;

ValueCount ( Left ( text ; (Position ( adjustedText ; "¶" & searchValue & "¶" ; PositionStart ; occurrence ) - 1) + Length ( searchValue ) ) )

)

)

Contact Us | Privacy | Policies

Copyright © 2006 DataIsland Software LLC. All rights reserved.

Notice: Product specifications and availability are subject to change without notice.