Extract a sub-string from the LEFT of a string.

Creating a LEFT formula

To create a LEFT formula:

  1. With a chart open, select the DOCUMENT RIBBON
  2. Click on the Fields button fieldmanager.png
  3. Click on Add formula button addformula.png
  4. Select the LEFT menu item
  5. Select the Field to extract a sub-string from (e.g. Work phone)
  6. Select the Range by entering an integer value or character (See options below)
  7. Click OK
  8. Rename the formula (e.g. Work phone area code)
  9. Click OK to complete the rename function
  10. Click OK (green button at the top)


The following range options are available:

  • Positive integer value - Displays a number characters starting from the left of the field equal to the value entered. (e.g. If "3" is entered with the with the Work Phone field it will return the first 3 characters of Work Phone.)
  • Break character - Displays all characters to the left of entered character. (e.g. If "@" is entered with a field containing e-mail addresses then all characters left of the "@" will be displayed.)

LEFT Examples

Here are some examples of the LEFT formula.

  1. LEFT using "@" as the break character would yield Dan given an input of moc.trahcgro|naD#moc.trahcgro|naD.
  2. LEFT using "3" as the integer value would yield 800 given the phone number 800-555-1212.

Reviewed 9/4/2017