Convert to Title Case or Proper Case

[Sef]

Hi All

I am looking for a System function or Business Function or even an API that can convert text into a format called 'Title Case' (as per Word) or 'Proper Case' (as per VB) or InitCaps (as in Oracle SQL). Example:

THIS IS an EXampLe ---> This Is An Example
Sef van den Nieuwelaar --> Sef Van Den Nieuwelaar

Any smart solutions out there as I'd hate to write one myself.

Thanks in Advance,

 

[Christian Audet]

Sef,

The only solution I see is a new Function. Easy to write in 'C'.

Tell me if you need it

Christian Audet

 

[JMR]

Sef,

I know of no such existing solutions, but not too difficult to write one. I attached a simple solution. See if it meets your needs.

 

[JMR]

Sorry Christian...I didn't see your post until after I started mine.

 

[Sef]

Hi Jeremy

Thank you very much for your help! I took your sample and created a new BSFN locally and voila... Init Caps were produced. Maybe an idea to put the solution in the Download section (If you do so, could you please include the header file as well)?

Thanks again,