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 Digit-Chart http://digit-chart.com |
Sample input:
RemovePartValue(
"acbd¶1234¶orange" ; 2 )
"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
Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.