removeFirstAddPrefixSuffixToList ( theList ; prefix ; suffix )

Add a prefix and suffix to a list after removing the first word from the list

Average rating: 4.8 (22 votes) Log in to vote

Kenneth Durrum - Show more from this author
Released Solutions
https://releasedsolutions.net

Sample input:

removeFirstAddPrefixSuffixToList ( ID123 test¶ID 123 test 2, 123 , "" )

Sample output:

123 test
123 test2

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

// Description:
// removeFirstAddPrefixSuffixToList ( theList ; prefix ; suffix )
// A recursive function that takes a list of values, romves the first word (space separated) and adds a prefix and suffix to the line item

// Written by Kenneth Durrum
// www.releasesolutions.net



If ( IsEmpty ( theList );
theList;

Let ( aValue =               MiddleWords ( GetValue ( theList ; 1 ) ; 2 ; 100 ) ;
	prefix &
    aValue &
    suffix &
    If ( ValueCount ( theList ) > 1 ; "¶" ; ""  ) &
    removeFirstAddPrefixSuffixToList (
       RightValues ( theList ; ValueCount ( theList ) - 1 ) ;
       prefix; suffix )
	)
)

This is an expanded version of AddPrefixSuffixToList. If you need to strip away and remove the first part of a list item and add a constant prefix or suffix to the list then this custom function is for you.

Comments

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

removeFirstAddPrefixSuffixToList ( theList ; prefix ; suffix )

Comments

Support this website.

Support this website.