Contents x
      RIGHTOF
      • 1 Minute to read
      • Print
      • Dark
        Light
      • PDF
      Contents

      RIGHTOF

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

      String: RIGHTOF

      Extracts all characters to the right of the first occurrence of defined character.

      Purpose

      Use this function to:
      • Extract a sub-string from another string
      • Find text to the right of a specified string

      Return Value

      PropertyValue
      FieldTypeString  
      FieldSizeLow / Med / High / Continuous
      DataTypeDiscrete / Continuous
      DataSizeShort / Integer / LongInteger / Double
      MyStringValue


      Parameters

      ParameterJSONDescription
      Table“targetTable”: “MyTableName”The target table on which the new field will be created
      Overwrite"overwrite": true
      		true/false.  If true will automatically overwrite an existing field.
      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”: “RIGHTOF(A,B)”RIGHTOF(A,B)

      		“p2”: "ShortFieldName"
      		Required. Field to modify.
      Supports:  
      • DataType: Discrete or STRING CONT
      • Field Type: Discrete (All), Continous (String)
      • Fixed Value: #fixedvalue

      		“p3”: "SubString"Required. Character from which to begin new string
      Supports:  
      • DataType: DISCRETE
      • Field Type: String
      • Fixed Value: #A, #Aaaa, #An nNa
      Treat Null as Zero"nullIsZero": true
      "nullIsZero": false

      		True/False.
      Default = False
      If true, then any null values in the input fields will be treated as if they have a value of 0.

      JSON Sample

      {
  "method": "BuildBakedField",
  "project": "BikeData2",
  "targetTable": "Journeys",
  "overwrite": true,
  "name": "Town",
  "function": "string",
  "p1": "RIGHTOF(A,B)",
  "p2": "StartStation Name",
  "p3": "#,"
}


      Usage Notes

      See Also:   

      • Engineering | Expression Field
      • LeftOf
      • Right
      • Left

      Example

      ExampleDetails
      DescriptionExtract Town From Station Name
      Input
      • Table: = [Journeys]
      • Filter: = [No Filter]
      • Function: = String
      • String Function:= RIGHTOF(A,B)
      • A:=[StartStation Name]
      • B:=#,
      • Name: = Town
      Sample




      Was this article helpful?
      What's Next