Software Venture Consulting
ToMarket

FileMaker Pro downloads & Resources
FileMaker Custom Functions
FileMaker Web Viewer Examples
FileMaker Pro & Lasso Consulting
Training
FileMaker Books
FileMaker Articles
FileMaker Error Reference

Free Web Tools
Free FileMaker Tools

Personal Pages
Videos
Adventures
Links

Shopping Cart
Shopping Cart

Search:

Free Newsletter
Signup


Contact


Privacy Policy



FileMaker is a registered trademark of FileMaker, Inc. in the U.S. and other countries.

 

 FileMaker Pro Custom Functions

List  |  Show Random  |  Upload  |  Add This to Your Site

MatchX ( string ; search )

Rate this function:  

RatingRatingRatingRatingRating
  Average rating: 3.6  (7 votes)
  Discuss this Custom Function

Ian Moree, Somethings Different
http://somethingsdifferent.biz

Matches consecutive characters only l-r not r-l yet

Sample Input:
MatchX( "MYnamE1" ; "E1 )


MatchX( "BahmiaN" ; "Lk" )
Sample Output:
E1


There was no Match


 Then copy & paste into FileMaker Advanced's Edit Custom Function window.

Click here to copy To Clip Manager if you have myFMbutler's Clip Manager installed

Description:

Matches a set of characters such as

Ia

BA

U1

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

This is my Custom Function and I want to edit it

Discuss:

Was this working for you?

Lee Smith, Woodland
March 29, 2012 6:54pm

WOW!
totally messed up the copy / paste

Here is what i intended to past>

/*
###################################

Match v.1_0
by: Ian moree
date: Mar 29, 2012

Definition: Match ( string; search ; )

eg. this finds chars in sequence {IA} , if not, then returns Message stating so
// My first custom function- I am sure there is room for improvement,just dont know yet!

#####################################
*/


Case
( IsEmpty( string) or IsEmpty( search ); "" ;
/* else */
Let( [

len = Length ( search );
pos = Position( string; search ; 1 ;1 )
];


Case( pos = 0 ; 0 ; Exact (search; Middle ( string ; pos; len ) )
) )
)

Ian Moree, Nassau Bahamaas
March 29, 2012 9:11pm

Initially I noticed that you had a typo in the Let statement

POS = Position (text; search; 1:1)

S/B POS = Position (string; search; 1; 1)

In addition you had the opening case statements closing within the Let calculation, instead of at the end where it belonged.

I tested your revised Custom Functions and I noticed that you modified the calculation for the Let so that it no longer gives statement “there was no match”

Anyway, here is a modification of your original custom function, that I think does what you wanted to do.

Case (
IsEmpty ( text ) or IsEmpty ( Search ) ;
Get ( LastError ) ;
Let ( [
len = Length ( Search ) ;
pos = Position ( text ; Search ; 1 ; 1 )
] ;
Case (
pos = 0 ;
"There was no Match" ;
Middle ( text ; pos ; len )
)
)
)
//end case

Lee Smith, Woodland
March 30, 2012 12:40am

thanks Lee.

Ian Moree, Nassau Bahamaas
March 30, 2012 6:58am

Make a comment about this Custom Function (please try to keep it brief & to the point). Anyone can post:

Your Name:
City/Location:
Comment:
characters left. If you paste in more than 1500 characters, it will be truncated. Discuss the function - advertisements and other useless posts will be deleted.
Answer 4 + 3 =
Search for Custom Functions:

Custom Functions Widget
Download the Custom Function Dashboard Widget for OS X
Keep all the latest Custom Functions right at your fingertips!

Newest Custom Functions:

1. IndianNotation ( number )
  (Wed, Jun 24, 1:40pm)
2. RemoveValue ( Values ; RemoveValue )
  (Wed, Jun 24, 2:04am)
3. NumberToTextFormatCurrency ( Number;Seperator;DecimalSign;Precision )
  (Fri, Jun 19, 4:55am)
4. fmpGoogleMap ( address ; city ; state ; zip ; country)
  (Fri, Jun 12, 1:43am)
5. SortableTextWithNumbers ( text )
  (Tue, Jun 09, 12:15am)
6. WV_text ( txt ; bgnd_color ; font_color ; fontsize )
  (Mon, Jun 01, 2:17am)
7. ModifiersOn ( keys )
  (Sat, May 30, 3:17pm)
8. convertDropboxURL ( theURL )
  (Sat, May 30, 2:45pm)

RSS Feed of Custom Functions