Brian Dunning's FileMaker Custom Functions

RemovePartValue ( TheList ; Left Nb )

Select the same number of left characters from each value of a list

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

Nehme RAAD   Nehme RAAD
Digit-Chart
http://digit-chart.com

Share on Facebook Share on Twitter

  Sample input:
RemovePartValue(
"acbd¶1234¶orange" ; 2 )
  Sample output:
"ac¶12¶or"

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

/*
By Nehme Raad; March 2015
This function selects the same number of caracters from each value of a list
*/


If ( IsEmpty ( TheList );
TheList;

Left ( GetValue ( TheList ; 1 ) ; Left Nb ) &

If ( ValueCount ( TheList ) > 1 ; "¶" ; "" ) &
RemovePartValue (
RightValues ( TheList ; ValueCount ( TheList ) - 1 ) ;
Left Nb )
)

 

Comments

Log in to post comments.

 

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

Under construction. Email me your wish list for improvements.