AddPrefixSuffixToList ( theList ; prefix ; suffix )

add a prefix or suffix to each line in a list

Average rating: 4.3 (32 votes) Log in to vote

Andy Knasinski - Show more from this author
nrg software, llc.
http://www.nrgsoft.com

Sample input:

AddPrefixSuffixToList ( "value1¶value2" ; "[value]" ; "[/value]" )

Sample output:

[value]value1[/value]
[value]value2[/value]

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

// Description:
// AddPrefixSuffixToList ( theList ; prefix ; suffix )
// A recursive function that takes a list of values and adds a prefix and suffix

// Written by Andy Knasinski
// www.nrgsoft.com

// sample
// AddPrefixSuffixToList ( "value1¶value2" ; "<value>" ; "</value>" )
// would return an XML string for all values in a field


If ( IsEmpty ( theList );
theList;

Let ( aValue = GetValue ( theList ; 1 ) ;
	prefix &
    aValue &
    suffix &
    If ( ValueCount ( theList ) > 1 ; "¶" ; ""  ) &
    AddPrefixSuffixToList (
       RightValues ( theList ; ValueCount ( theList ) - 1 ) ;
       prefix; suffix )
	)
)

Quickly add a prefix or suffix to each line in a list. Useful for coercing related values to XML

Comments

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

AddPrefixSuffixToList ( theList ; prefix ; suffix )

Comments

Support this website.

Support this website.