Topic Options
Rate This Topic
#131391 - 02/13/06 12:06 PM Workflow set field question
jmcollins2 Offline
newbie

Registered: 02/10/06
Posts: 3
QUESTION:
I think this is simple, but for whatever reason I do not see it, I have a set field action in a filter that is supposed to take two fields (last name, first name) and combine them into one.

For example, Smith John should become Smith, John

I have it working with the set field below:

(($Recipient_Last _Name$ + ",") + " ") + $Recipient_First Name$

However it is putting the coma in the wrong spot. Instead of:

Smith, John?.it looks like Smith , John.. It is inserting a space between Smith and the Coma.

I just do not see the problem. Any quick thoughts?

Top
#131392 - 02/14/06 06:14 AM Re: Workflow set field question [Re: maureen_korda]
DEVSGW Offline
Stealth Member

Registered: 02/13/06
Posts: 92
Loc: Texas
1. is there a space at the end of the data in the last name field? if so you may want to remove it.
2. additionally try $last Name$+", "+$first Name$ instead of the $last Name$+","+" "+$first Name$
_________________________
Stephen G.Waller
Remedy Consultant
COMMIT.LLC

Top
#131393 - 02/18/06 06:02 AM Re: Workflow set field question [Re: maureen_korda]
Anonymous
Unregistered


Most likely you have an extra space at the end of LastName field.
Try RTRIM() Function on LastName.

((RTRIM($Recipient_Last _Name$) + ",") + " ") + $Recipient_First Name$

Sanya

Top