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 7 + 5 =
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. Patternize ( direction ; pattern ; replaceChar ; value ; pad? )
  (Fri, Jul 25, 5:48pm)
2. RequestSQL ( fieldDesired ; fieldKey ; valueKey ; valueType)
  (Fri, Jul 25, 7:31am)
3. isLeapYear ( _year )
  (Thu, Jul 17, 8:29am)
4. AgeCalculation( Date( 4 ; 12 ; 1980 ) ;
  (Thu, Jul 17, 8:10am)
5. ntBitwiseOperation ( ope ; base ; value1 ; value2 )
  (Wed, Jul 16, 11:22pm)
6. ntRepeat( times ; statements ; resultValueName )
  (Mon, Jul 07, 8:51pm)
7. ฺBookRentalCal ( BookingStart; 1.5)
  (Sat, Jul 05, 8:25pm)
8. GetThailandSummerTime ( Start ; End )
  (Sat, Jul 05, 7:47pm)

RSS Feed of Custom Functions