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: 2.0  (3 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 + 4 =
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. BinBitOperation_cf ( bin1 ; bin2 ; optype ; i ; result )
  (Sun, Apr 13, 12:40pm)
2. SubtractTimes ( Time1 ; Time2 )
  (Thu, Apr 10, 8:37am)
3. AddTimes ( Time1 ; Time2 )
  (Thu, Apr 10, 8:32am)
4. isDaylightTime ( dt )
  (Fri, Apr 04, 11:34am)
5. _FilterLowerUpperASCII ( text )
  (Tue, Apr 01, 6:16pm)
6. GoogleMapsByAddress ( Street ; Suburb ; State ; PostCode ; Zoom ; WebViewerObjectName )
  (Tue, Mar 25, 2:06am)
7. _FilterLowerASCII (Text)
  (Tue, Mar 18, 9:25am)
8. MailingLabel ( fname ; lname ; company ; addr1 ; addr2 ; city ; state ; pcode )
  (Thu, Mar 13, 12:14pm)

RSS Feed of Custom Functions