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.2  (5 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 2 + 9 =
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. removeFirstAddPrefixSuffixToList ( theList ; prefix ; suffix )
  (Thu, Feb 26, 3:38am)
2. ETA(StartTime;Current;OfTotal)
  (Tue, Feb 24, 7:44pm)
3. MkDir {FolderName; MyPath}
  (Tue, Feb 24, 6:20am)
4. EngNotation ( number; digits )
  (Thu, Feb 19, 5:19pm)
5. GetXmlContent ( theXml ; theNodeName ; theInstanceNumber )
  (Mon, Feb 16, 4:17pm)
6. InterpretDateFromText ( dateText ; noResult )
  (Sun, Feb 15, 12:49pm)
7. VLookup ( LookupTableAndFieldName ; MatchingValueOrList ; ReturnFieldName )
  (Thu, Feb 12, 10:44pm)
8. GetObjectHeight (ObjectName)
  (Thu, Feb 12, 2:05am)

RSS Feed of Custom Functions