Hyphenate ( )
Function stats
Average user rating
Support
FileMaker 8.0 +
Date posted
19 November 2008
Last updated
09 December 2008
Version
1.3 + View history
Recursive function
Yes
Function overview
Prototype
Hyphenate (
Field )
Parameters
Field
Description
Takes a list of values and puts a hyphen in between each value in the list.
Examples
Sample input
900
200
600
500
200
600
500
Sample output
900 - 200
200 - 600
600 - 500
200 - 600
600 - 500
Function code
Let ( i = ValueCount ( Field );
Case ( i > 1;
GetValue ( Field ; 1 ) & " - " & GetValue ( Field ; 2 ) & ¶ &
Hyphenate ( RightValues ( Field ; i - 1 ) )
)
)
// ===================================
/*
This function is published on FileMaker Custom Functions
to check for updates and provide feedback and bug reports
please visit http://www.fmfunctions.com/fid/78
Prototype: Hyphenate( Field )
Function Author: Mr Vodka (http://www.fmfunctions.com/mid/30)
Last updated: 09 December 2008
Version: 1.3
*/
// ===================================
Case ( i > 1;
GetValue ( Field ; 1 ) & " - " & GetValue ( Field ; 2 ) & ¶ &
Hyphenate ( RightValues ( Field ; i - 1 ) )
)
)
// ===================================
/*
This function is published on FileMaker Custom Functions
to check for updates and provide feedback and bug reports
please visit http://www.fmfunctions.com/fid/78
Prototype: Hyphenate( Field )
Function Author: Mr Vodka (http://www.fmfunctions.com/mid/30)
Last updated: 09 December 2008
Version: 1.3
*/
// ===================================
Login or register to comment
Create a new account with fmcustomfunctions.com or login to post a comment.
Comments
21 November 2008