Contents x
      LOWER(A)
      • 1 Minute to read
      • Print
      • Dark
        Light
      • PDF
      Contents

      LOWER(A)

      • 1 Minute to read
      • Print
      • Dark
        Light
      • PDF
      Article summary

      General: LOWER(A)

      Forces all characters in a string to be lowercase.

      Purpose

      Use this function to:
      • transform a string to lowercase characters

      Return Value

      PropertyValue
      FieldTypeString  
      FieldSizeLow / Med / High / Continuous
      DataTypeDiscrete / Continuous
      DataSizeShort / Integer / LongInteger
      Return Value: "all lower case string, even with other characters"



      Parameters

      ParameterJSONDescription
      Table“targetTable”: “MyTableName”The target table on which the new field will be created
      Filter“dataset”: {DataSet_JSON}Optional.   If a filter is applied, records not in the filter recordset will be returned as null.
      Function"function":"string""string"

      		“p1”: “LOWER(A)”String Function

      		“p2”:"fieldname"Required. 
      Supports:  
      • DataType: Discrete, Continuous
      • Field Type: String 
      • Fixed Value: #Value to Change  

      JSON Sample

      {
  "method": "BuildBakedField",
  "project": "BikeData2",
  "targetTable": "worldcities",
  "overwrite": true,
  "name": "LOWER city",
  "function": "string",
  "p1": "LOWER(A)",
  "p2": "city"
}


      Usage Notes

      See Also:   




      Was this article helpful?
      What's Next