MiddleWordsIncPunct ( text ; startingWord ; numberOfWords )

Returns words including any punctuation and quote characters to the LEFT and RIGHT of those words

Average rating: 4.7 (29 votes) Log in to vote

Ralph Learmont - Show more from this author

Sample input:

MiddleWordsIncPunct ( "She screamed \"Let me play too!\". But nobody moved." ; 3 ; 4 )

Sample output:

"Let me play too!".

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

Let ( [

FM_MiddleWords = MiddleWords ( text ; startingWord ; numberOfWords ) ;
SpacesWithin = PatternCount ( FM_MiddleWords ; " " ) ;
QtyWords = SpacesWithin + 1 ;

FM_LeftWords = LeftWords ( text ; startingWord ) ;
startingFrom = PatternCount ( FM_LeftWords ; " " ) + 1 ;

tempText = Substitute ( text ; ¶ ; "" ) ;
tempList = Substitute ( tempText ; " " ; ¶ ) ;
shortList = MiddleValues ( tempList ; startingFrom ; QtyWords ) ;
flattened = Substitute ( shortList ; ¶ ; " " ) ;
String = Trim ( flattened ) ] ;

Substitute ( String ; "" ; ¶ ))




/*Syntax:    MiddleWordsIncPunct ( text ; startingWord ; numberOfWords )


Unlike Filemaker's "Middlewords" function, this function includes punctuation 
and quote characters to the LEFT and RIGHT of your specified words.

Example:    

MiddleWordsIncPunct ( "He was \"overjoyed!\" to get gifts" ; 1 ; 3 )      Result = He was "overjoyed!"
MiddleWords ( "He was \"overjoyed!\" to get gifts" ; 1 ; 3 )                   Result = He was "overjoyed
Note:  Caters for internal CRs and multiple spaces.
By Ralph Learmont   Jan 8th 2012

*/

Filemaker's 'MiddleWords' function (and its other similar word functions) provide a string of words which contain all punctuation and quote characters within those words, but strip off any that might have existed at the beginning and end of that word string.
If you need to include these surrounding characters, try this function.

Comments

		comment, VR Jan 10, 2012
Words are not always separated by spaces.

		Darrel, Portland Mar 17, 2014
You just saved me an hour (really 2 if I was to polish it as you did). Clean and very useful. Thanks

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

MiddleWordsIncPunct ( text ; startingWord ; numberOfWords )

Comments

Support this website.

Support this website.