Skip to main content
Sign in

Sub-string

  • Updated

Purpose

Pull out a portion of a string.

 

Category Location: All, calculate or manipulate

 

sub-string.png

  1. Source attribute: attribute to parse
  2. Target attribute: attribute to house the parsed information (use add attribute to create a new attribute)
  3. Sub-string operation
    • Left: specify the number of characters from the first letter of the string (counting starts from the left of the string.
    • Right: specify the number of characters from the last letter of the string (counting starts from the right of the string)
    • Start and end: specify the start and end position of the letters in the string (counting starts from a designated position that you set)3.jpg
  4. Number of characters: specify the number of characters in Left or Right, specify start and end character counts for Start and End.

 

Examples

  1. Build dates for campaigns based on the campaign name:
    • Q2 - 2020 Executive Dinner: Pull first two characters and characters 4-8 to build dates
  1. Truncate long strings:
    • You've deduped records and merged the Notes field resulting in this field not meeting the target system's data type length.  Set a field length limit using the sub-string task.

 

Related articles