Extract Position

Follow

Determines how to a extract a substring from a string.

Basically extracts the text between the From and To fields, these fields can either be numbers or text. If it is a number it indicates the character postion in the string (the first charcter is 1), if it is a text the postion is determined dynamically depending on where in the string the text appears.

If From or To field contains a number (indicating a character position) and direction is backwards a new option appears: Left or Right indicating from which end numbers are counted from.

If to is a number a new option appears: Relative To, if this is set to indicates the number of characters to include in the substring.

Some examples

Source string: "project_othertext#evenother_text.pdf"

  1. Direction forward
    From "1" To "_"
    Extracted substring: "project" 
  2. Direction forward
    From "_" To "#"
    Extracted substring: "othertext" 
  3. Direction forward
    From "2" To "4"
    Extracted substring: "roj" 
  4. Direction forward
    From "2" To "4"
    Relative To Extracted substring: "roje" 
  5. Direction forward
    From "_" To "evenother"
    Extracted substring: "othertext#" 
  6. Direction forward
    From "1" To "_"
    Extracted substring: "project" 
  7. Direction forward
    From "#" To "."
    Extracted substring: "evenother_text" 
  8. Direction backwards
    From "_" To "#"
    Extracted substring: "evenother" 
  9. Direction backwards
    From "5" To "#"
    Right
    Extracted substring: "evenother_text" 
  10. Direction backwards
    From "#" To "1"
    Left
    Extracted substring: "project_othertext"
Have more questions? Submit a request

Comments

Powered by Zendesk