SLP How to set Uppercase of the first letter in each word in a field

本文由 Canyon 在 2012-03-06 發表於 "WebSAMS 討論區" 討論區

  1. 10109629

    Canyon
    Expand Collapse

    文章:
    81
    讚:
    0
    Dear all,

    In crystal report, how to set a field to be uppercase of the 1st letter of each word?
    e.g.
    original field value = "it is a CAT"
    output = "It Is A CAT".

    That's exactly PROPER in excel function.

    Thx
     
  2. 56440610

    edb-brian
    Expand Collapse

    文章:
    382
    讚:
    0
    You may use ProperCase in Crystal Report

    e.g.
    ProperCase ("LINDA FONG")
    This example will return "Linda Fong".
     
    #2 edb-brian, 2012-03-06
  3. 10109629

    Canyon
    Expand Collapse

    文章:
    81
    讚:
    0
    Can it return "LINDA FONG" again if I use ProperCase?
     
  4. 56440610

    edb-brian
    Expand Collapse

    文章:
    382
    讚:
    0
    This proper function is the same as in Excel. You cannot reverse the changes.
     
    #4 edb-brian, 2012-03-06