The text function 'Proper' does not return a conventional result (in comparison with other software like MS Excel.

When two words are separated with a dash like:

LOUIS-MICHEL

Proper returns:

Louis-michel

Where it should be:

Louis-Michel

Does anyone agree with me? Should we request this to change?
Is there a page on the objectif lune website where we can post wishes?

That sounds reasonable, I'll see what we can do.

I don't think there's a page on the OL site, but you could post in the Feedback & Feature Requests forum: http://www.objectiflune.com/cgi-bin/ultimatebb.cgi?ubb=forum;f=103

Hi,

As a workaround, you could use an expression like:

REPLACE(PROPER(REPLACE("louis-michel","-"," "))," ","-")

1. Replace "-" by " "
2. Apply the proper function
3. Replace " " by "-"

Of course this expression assumes that the name parameter will initially not contain any blank space (otherwise they would all be replaced by "-" in step 3).

Hope this helps!


Benoit

I just read your replies. The objectif lune mails don't come thru anymore (probably our spam filter. I'll check it.)

Thanks for the help.