Like what you see? Have a play with our trial version.

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  1. Either click on the menu icon next to a text field’s name in the data preview panel.

     

  2. Or click on the menu option next to a text field in the Configure panel, under the Fields tab.

     

  3. A menu will appear for the selected field.

  4. Click on the Sub-String option.



  5. When the popup appears, choose which side to begin extraction from. Options include:
    • Left: Extract characters starting from the left side (beginning) of the string.
    • Right: Extract characters starting from the right side (end) of the string and work backwards.
    • Middle: Extract characters starting from the specified starting position (including the character at that position) and work forwards.
    Image Removed
    Image Added

  6. Then specify the number of characters to extract.
  7. If the Middle option is selected, then enter a starting position to begin extraction. (The character in that position will also be extracted.)
    Image Removed
    Image Added

  8. Click on Submit.

...