Brian Dunning's FileMaker Custom Functions

Portal_Filter_Field ( Field1_Source ; Field1_Prefixe ; Field2_Source ; Field2_Prefixe ; Field3_Source ; Field3_Prefixe ; Field4_Source ; Field4_Prefixe )

Portal Filter Recursive

  Average rating: 4.4 (34 votes) Log in to vote

Joel Englander   Joel Englander
Joel Englander
http://www.asymptotes.com

Share on Facebook Share on Twitter

  Sample input:
Field 1 : Jean de La Tour & Cies
Field 2 : 95, rue des grands champs
Field 3 : 75020
Field 4 : Paris
Field 5 : France
  Sample output:
f1-J
f1-Je
f1-Jea
f1-Jean
f1-d
f1-de
f1-L
f1-La
f1-T
f1-To
f1-Tou
f1-Tour
f1-C
f1-Ci
f1-Cie
f1-Cies
f2-9
f2-95
f2-r
f2-ru
f2-rue
f2-d
f2-de
f2-des
f2-g
f2-gr
f2-gra
f2-gran
f2-grand
f2-grands
f2-c
f2-ch
f2-cha
f2-cham
f2-champ
f2-champs
f3-7
f3-75
f3-750
f3-7502
f3-75020
f4-P
f4-Pa
f4-Par
f4-Pari
f4-Paris
f5-F
f5-Fr
f5-Fra
f5-Fran
f5-Franc
f5-France
dummy_value

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

This Function will Filter 5 Fields and will create a string that take all the word with all the letter with no more and no less character that needed.

Portal_Filter_Word Function required

 

Comments

Log in to post comments.

 

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

Support this website.

This library has been a free commmunity resource for FileMaker users and developers for 15 years. It receives no funding and has no advertisements. If it has helped you out, I'd really appreciate it if you could contribute whatever you think it's worth: