MapInfo Pro

 View Only
  • 1.  Update column expression to make the first letter of every word capital (Title Case)

    Posted 03-25-2025 01:15

    Dear All,

    I'm trying to update a data set that is currently in capital to title case (Table > SQL > Update Column). I could only find the following function to make all data lowercase.

    Please support me in building an expression to make the first letter of every word capitalised (Title Case)



    ------------------------------
    Dhan
    VIC, Australia
    ------------------------------


  • 2.  RE: Update column expression to make the first letter of every word capital (Title Case)

    Posted 03-25-2025 01:22

    Hi Dhan,

    You might be after Proper Case.  In that "case", you can use the Proper$ function.



    ------------------------------
    James Nolet
    GIS Manager
    Caf Consulting
    Mentone office, VIC, Australia
    ------------------------------



  • 3.  RE: Update column expression to make the first letter of every word capital (Title Case)

    Posted 03-25-2025 02:19

    Hi James,

    Thank you for your support. I was able to update the data using Proper$. Is there a document you tumbled upon to find more details about expressions and functions currently available on MapInfo Pro?

    Cheers!

    Dhan



    ------------------------------
    Dhan
    VIC, Australia
    ------------------------------



  • 4.  RE: Update column expression to make the first letter of every word capital (Title Case)

    Posted 03-25-2025 07:20

    Hi Dhan,

    I use the help available via MapBasic, which can be downloaded here: https://support.precisely.com/product-downloads/

    You can also bring up the MapBasic Reference within MapInfo, such as by selecting "MapBasic Reference" from the Help dropdown in the SQL window:



    ------------------------------
    James Nolet
    GIS Manager
    Caf Consulting
    Mentone office, VIC, Australia
    ------------------------------