ParseParagraph ( string )

Turns paragraphs using

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:

ParseParagraph ( "Member's Name:: Bingo Jones¶Name of Card Holder:: Mr B Jones Esq.
¶Certificate No (if any)::¶" ; "::" )

Sample output:

"members_name¶name_of_card_holder"

variables:

$members_name = "Bingo Jones"
$name_of_card_holder = "Mr B Jones Esq."

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

// ParseParagraph ( string ; delimiter )
While (
  [
    i = 1 ;
    result = "" ;
    limit = ValueCount ( string ) + 1
  ] ;

  // conditional
  i < limit ;

  // logic
  [
    line = GetValue ( string ; i ) ;
    parts = Substitute ( line ; delimiter ; ¶ ) ;
    varname =
    Substitute (
      Trim (
        Filter (
          GetValue ( Lower ( parts ) ; 1 ) ;
          "abcdefghijklmnopqrstuvwxyz "
        ) 
      ); 
      [ " " ; "_" ]
    ) ;
    value = Trim (
      Substitute ( GetValue ( parts ; 2 ) ; [ ¶ ; " " ] ; [ "  " ; " " ] )
    ) ;
    temp = Evaluate ( "Let ( $" & varname & " = " & Quote ( value ) & " ; 0 )" ) ;
    result = If ( value > "" ; List ( result ; varname ) ; result ) ;
    i = i + 1
  ] ;

  // return a list of variables created
  result
)

Takes a list of delimited name:value paragraphs, and creates the appropriate variables. It returns a list of variables that were created, to make testing for required params easier in scripts, e.g.

If [ FilterValues ( ParseParagraph ( Get ( ScriptParameter ) ; Char ( 9 ) ) ; "card_number¶cvc_code" ) ]

Checks to see whether $card_number and $card_number were both created.

Comments

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

ParseParagraph ( string )

Comments

Support this website.

Support this website.