GGreg Posted January 7, 2009 Share Posted January 7, 2009 Hello, I need a rule to forces : - a name field to be in lowercase - and the first caracter in uppercase Is it possible to do it with a made up name? Link to comment Share on other sites More sharing options...
mhilger Posted January 9, 2009 Share Posted January 9, 2009 Hello, We have a rule called ToTitleCase() that will return strings with the first character in upper-case and the rest in lower-case. Try this: return ToTitleCase(Field("YourFieldName")); Link to comment Share on other sites More sharing options...
GGreg Posted January 29, 2009 Author Share Posted January 29, 2009 How to make it for a made up family names (here is an example: Catherine Baud-Fouquet) or with the names with particle (here is an example: Catherine de Fouquet)? Thank you ! Link to comment Share on other sites More sharing options...
Dan Korn Posted January 29, 2009 Share Posted January 29, 2009 How to make it for a made up family names (here is an example: Catherine Baud-Fouquet) or with the names with particle (here is an example: Catherine de Fouquet)? The first mantra of VDP is "Know Thy Data." While computers can do all kinds of things to filter and cleanse input data, there's simply no way to write an algorithm that will reliably calculate something as arbitrary as the correct capitalization of proper names, especially with the great Tower of Babel of different languages with their own conventions and exceptions. Your best bet is to go back to the client and get the data in the format that you need. See my post on the old forum about this: http://www.mail-archive.com/fusionpro@printplanet.com/msg01161.html Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.