ListMentions ( text )

Pulls out all @mentions from the text.

Be the first to rate this function Log in to vote

Richard Dyce - Show more from this author
Dyce & Sons Ltd.
http://dyce.com

Sample input:

ListMentions ( "This is a message for @dd. Can you call @jj and @gh. @dd" )

Sample output:

"@dd¶@jj¶@gh¶@dd"

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

// ListMentions ( text )

If(
	PatternCount ( text ; "@" ) = 0 ;

	// no mentioned left to collect
	"";

	// we have more to deal with	
	Let(
		[
			start = Position ( text ; "@" ; 1 ; 1 ) ;
			prefix = Left ( text ; start - 1 ) ; 
			mention = "@" & LeftWords( Middle ( text ; start ; 64000 ) ; 1 ) ;
			end = start + Length( mention ) ;
			suffix = Middle ( text ; end ; 64000 )
		] ;
		List( mention ; ListMentions( suffix ) )
	)
)

It doesn't de-dupe @mentions - wrap the call in UniqueValues( ) if this is required. It is recursive, but depth should be equal to the number of @ symbols in the text.

Comments

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

ListMentions ( text )

Comments

Support this website.

Support this website.