Datetime todayDate = Date.Today();
Integer todayDay = todayDate.Day();
String todayDateString = todayDate.format('dd-MMM-yyyy hh:mm aaa');
finalMergefieldMap.put('{!Today}', todayDateString);
System.debug('****************************** Date.Today() ' + Date.Today());
System.debug('****************************** Day of Today ' + todayDay );
System.debug('****************************** todayDateString ' + todayDateString );

Is there a way to search a text field and create a List or Map with entries each time a specific string of characters is in the text field? I'm looking for a way to go through a text (not Rich) field and make merge field replacements, in much the same way the standard email templates work in SF.

Unlike a standard email, my text field can have fields from up to 4 objects + Sending User fields; an email template on steroids.

For instance:

{!Contact.FirstName} {!Contact.LastName}
{!Account.BillingStreet}
{!Account.BillingCity} etc...

Dear {!Contact.FirstName},

Account Name: {!Account.Name}

Possible {!Lead.Name} in here for good measure. This is my body. More fields possible down below. {!Custom_object__c.Field} too!

Sent by: {!User.FirstName} {!User.LastName}

I want a List/Map for each object in the above text field with the field merge field name in it.

List<String> contactFields as
{!Contact.FirstName}
{!Contact.LastName}
etc... 
List<String> accountFields
List<String> LeadFields
List<String> customerObjectFields
List<String> sendingUserFields

OR

Map<String, String> contactFields ('{!Contact.FirstName}', 'FirstName')
etc...
Map<String, String> accountFields ('{!Account.Name}', 'Name')

Once I have the Lists, I can do some trimming/looping to create SOQL statements and return the field values for the merge fields. In essence, I'm trying to loop through a single field.

I'll worry about doing the actual merge once I get over this hurdle as it will take another pass through the text field making replacements. I actually feel better about this one though—a while loop checking for ‘{!’ In the text field.

Thanks in advance!
~J

@Conga_Jereriah

Datetime todayDate = Date.Today();
Integer todayDay = todayDate.Day();
String todayDateString = todayDate.format('dd-MMM-yyyy hh:mm aaa');
finalMergefieldMap.put('{!Today}', todayDateString);
System.debug('****************************** Date.Today() ' + Date.Today());
System.debug('****************************** Day of Today ' + todayDay );
System.debug('****************************** todayDateString ' + todayDateString );

Is there a way to search a text field and create a List or Map with entries each time a specific string of characters is in the text field? I'm looking for a way to go through a text (not Rich) field and make merge field replacements, in much the same way the standard email templates work in SF.

Unlike a standard email, my text field can have fields from up to 4 objects + Sending User fields; an email template on steroids.

For instance:

{!Contact.FirstName} {!Contact.LastName}
{!Account.BillingStreet}
{!Account.BillingCity} etc...

Dear {!Contact.FirstName},

Account Name: {!Account.Name}

Possible {!Lead.Name} in here for good measure. This is my body. More fields possible down below. {!Custom_object__c.Field} too!

Sent by: {!User.FirstName} {!User.LastName}

I want a List/Map for each object in the above text field with the field merge field name in it.

List<String> contactFields as
{!Contact.FirstName}
{!Contact.LastName}
etc... 
List<String> accountFields
List<String> LeadFields
List<String> customerObjectFields
List<String> sendingUserFields

OR

Map<String, String> contactFields ('{!Contact.FirstName}', 'FirstName')
etc...
Map<String, String> accountFields ('{!Account.Name}', 'Name')

Once I have the Lists, I can do some trimming/looping to create SOQL statements and return the field values for the merge fields. In essence, I'm trying to loop through a single field.

I'll worry about doing the actual merge once I get over this hurdle as it will take another pass through the text field making replacements. I actually feel better about this one though—a while loop checking for ‘{!’ In the text field.

Thanks in advance!
~J

@Conga_Jereriah