sc_print Posted February 2, 2011 Share Posted February 2, 2011 Hi, I have a customer who has set up the name field in their database as "FIRSTNAME LASTNAME". Both first name and last name together in 1 field, separated by a space, all in caps. I need to extract out the first name and convert it to proper case. I've created the following rule and it seems to work: var Name = Field("Name"); var FirstName=Name.split(" "); return ToTitleCase(FirstName); Link to comment Share on other sites More sharing options...
This topic is now archived and is closed to further replies.