FieldNames2FieldValues ( Text )

Replaces field names with field values in Text

Average rating: 4.3 (35 votes) Log in to vote

Ilya Shuvalov
SUI Solutions
http://filemaker.suisolutions.com

Sample input:

FieldNames2FieldValues ( "Dear {{Customers::CustomerName}} , thank you for buying our {{Products::ProductName}}!")

Sample output:

Dear John Smith, thank you for buying our SUI Calendar!

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

Let ([openMacrosPosition = Position ( Text; "{{" ; 1 ; 1 );       
        closeMacrosPosition =  If (Position ( Text; "}}" ; 1 ; 1 )=0; -2;  Position ( Text; "}}" ; 1 ; 1 ));
        macrosContents = Middle ( Text; openMacrosPosition + 2 ; closeMacrosPosition -  openMacrosPosition - 2);
  replacementText = GetField ( macrosContents );
        res = Replace ( Text ; openMacrosPosition ; closeMacrosPosition - openMacrosPosition + 2 ; replacementText );        
        macroscount = PatternCount ( res ; "{{" )
       ];
        
If ( macroscount=0 ; res; FieldNames2FieldValues (res) )
      )

Replaces all occurrences like {{::}} to actual field values.

Comments

		No name, no location Jun 28, 2011
Ok, so there are two competitors to this CF that are less well rated but still good (Mail Merge and Mail Merge Plus). However they use the << and>> that are more natural to users and the rest of us. It has been discussed that this CF is better because it does not use the evaluate function, which allows for more possible 'functionality' than perhaps desired, instead using GetField. Still, I am lazy, and here to copy and paste something, and would prefer to use the << and >> that my user is used to and a bit unmotivated to begin tinkering with this one. Great appreciation to all for three great choices!!!

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

FieldNames2FieldValues ( Text )

Comments

Support this website.

Support this website.