Topic Options
#44685 - 08/16/13 03:07 PM Formatting Text Data in an E-mail
ccooper Offline
OL Newbie

Registered: 08/14/06
Posts: 7
Loc: Harrisburg, PA
I need assistance formatting text data within the message of an e-mail.

I'm using 'get data selection' to browse to a CSV file and return the e-mail recipients full name,i.e. JOHN DOE. I want to format the upper case name as mixed case so it displays as John Doe.

Additionally, i'm using the same method to get the senders name from the data file and it is showing as Doe, Jane. I want to reformat it to display as Jane Doe.

Any assistance in this matter is greatly appreciated.

Top
#44698 - 08/19/13 09:38 AM Re: Formatting Text Data in an E-mail [Re: ccooper]
Raphael Lalonde Lefebvre Offline
OL Expert

Registered: 10/14/05
Posts: 4956
Loc: Objectif Lune Montreal
ccooper,

You'll need to format your variables somehow, before the email output. In this case, you will first need a "Set Job Info and Variables" to store the content of your data selections into variables(can be either job infos or local variables). Then you'll need a small script that will adjust the case, and then implement other formatting rules, such as "Doe, Jane" becoming "Jane Doe". You'll need to use Watch-specific commands such as "Watch.GetJobInfo", "Watch.SetJobInfo", "Watch.GetVariable" or "Watch.SetVariable", feel free to look them up in the documentation. As for the rest of the script, however, you will need to have some knowledge of scripting in order to build it.

Once you have changed the text, replace the values of the variables with the modified text, and use those variables in your email's body.

Regards,
Raphaël Lalonde Lefebvre

Top
#44705 - 08/19/13 02:45 PM Re: Formatting Text Data in an E-mail [Re: Raphael Lalonde Lefebvre]
ccooper Offline
OL Newbie

Registered: 08/14/06
Posts: 7
Loc: Harrisburg, PA
Thanks for your reply.

I was on the right track by trying to use 'set job info', however i'm not familiar with writing script. I'll look for a resource to help with that task.

Top