MaxTokensPerLine ( text ; delimiter )

Calculates the maximum number of tokens per line in the supplied text

Be the first to rate this function Log in to vote

Richard Dyce - Show more from this author
Dyce & Sons Ltd.
http://dyce.com

Sample input:

MaxTokensPerLine ( "123.123.123¶123.4123¶1234.1234.234.12¶123" ; "." )

Sample output:

Function definition: (Copy & paste into FileMaker's Edit Custom Function window)

// MaxTokensPerLine ( text ; delimiter )

While (
  [
    rows = ValueCount ( text ) ; 
    i = 0 ;
    tokens = 0
  ] ;
  
  i < rows ;
  
  [
    i = i + 1 ;
    tokenCount = PatternCount ( GetValue ( text ; i ) ; delimiter ) + 1;
    tokens = If ( tokenCount > tokens ; tokenCount ; tokens )
  ] ;
  
  tokens
)

In the case where you have value lists or variable length rows of delimited data, it can be useful to know the maximum number of iterations you will need.

Comments

Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.

MaxTokensPerLine ( text ; delimiter )

Comments

Support this website.

Support this website.