Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Published by Scroll Versions from space DEV and version r079

...

  • Multiple: Select one or more discrete columns from the drop-down list.
  • All: Select all columns in the dataset.
  • Range: Specify a start column and ending column. All columns inclusive are selected.
  • Advanced: Specify the columns using a comma-separated list. You can combine multiple and range options under Advanced. Ranges of columns can be specified using the tilde (~) character. Example:

    Code Block
    Store_Nbr, Item_Nbr, WM_Week~POS_Cost

...

Pattern TypeDescriptionExample
Literal value An exact string or value.

The following matches on the exact value between the quotes:

  'This is what I want to match.'

d-s-lang
item
pattern
pattern

D s product
supports a variety of macro-like pattern identifiers, which can be used in place of more complex regular expressions.

The following matches when two digits appear at the beginning of a value:

`{start}{digit} {digit}`

Regular expression pattern

Regular expressions are a standard method of describing matching patterns.

Info

NOTE: The syntax of regular expressions can be complex and can lead to unexpected results if they are improperly specified. Regex is considered a developer-level skill.

The following matches on all numerical values from 0 to 99:

/^\d$|^\d\d$/

...

Delimiter groupDescription
On delimiterTransformation is applied based on a specific literal or pattern.
Between delimitersTransformation is applied on database between two literal or pattern-based delimiters. Details are below.
On multiple delimiters

Transformation is applied based on a sequence of delimiters. An individual pattern can be a string literal, 

d-s-itemlang
itempattern
, or regular expression, and the sequence can contain combinations of these pattern types.

Between positionsTransformation is applied based on a starting index position and an ending index position. Index positions start from 0 on the left side of any cell value.
On positionsTransformation is applied based on a sequence of listed index positions. Index positions start from 0 on the left side of any cell value.
At regular intervalTransformation is applied at every nth position. Index positions start from 0 on the left side of any cell value.

...