Lowercase et uppercase in field name

[GGreg]

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?

[mhilger]

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"));

[GGreg]

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 !

[Dan Korn]

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