Page tree

 

Support | BlogContact Us | 844.332.2821

Versions Compared

Key

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

...

Delimiter MethodsDescriptionOperative Parameters
single-pattern delimiters

Column is split based on one of the following:

1) patterns used to describe the beginning and ending of the field delimiter(s),

2) single delimiter, which may be repeated,

3) index values of the start and end points of the delimiter

quote

At least one of the following parameters must be specified:

after , at , from , before , on , to

multi-pattern delimiters

Column is split based one of the following literal methods:

1) explicit sequence of delimiters,

2) explicit list of character index positions

3) every N characters

At least one of the following parameters must be specified:

delimiters, positions , every

Shared parameters:

The following parameters are shared between the operating modes:

 

ParameterRequired?Transform BuilderData TypeDescription
colYColumnstringSource column name
ignoreCaseNIgnore casebooleanIf true, matching is case-insensitive.
limitNNumber of timesinteger (positive)Specifies the maximum of columns to split from the source column

Single-pattern delimiter parameters:

 

Tip

Tip: For this method of matching, at least one of the following parameters must be used: at, before, from, on, or to.

 

 

ParameterRequired?Transform BuilderData TypeDescription
afterN

On pattern

Between two patterns

stringString literal or pattern that precedes the pattern to match
atNBetween two positionsArrayTwo-integer array identifying the character indexes of start and end characters to match
beforeN

On pattern

Between two patterns

stringString literal or pattern that appears after the pattern to match
fromNBetween two patternsstringString literal or pattern that identifies the start of the pattern to match
onNOn patternstringString literal or pattern that identifies the pattern to match.
toNBetween two patternsstringString literal or pattern that identifies the end of the pattern to match
quoteNIgnore matches betweenstringSpecifies a quoted object that is omitted from pattern matching

Multi-pattern delimiter parameters:

 

Tip

Tip: Use one of the following parameters for this method of matching. Do not use combinations of them.

 

 

ParameterRequired?Transform BuilderData TypeDescription
delimitersNSequence of patternsarrayArray of strings that list the explicit field delimiters in the order to apply them to the column.
positionsNSequence of positionsarrayArray of integers that identify the zero-based character index values where to split the column.
everyNEvery nth positionintegerString literal or pattern that appears after the pattern to match

...

  • The after and from parameters are very similar. from includes the matching value as part of the delimiter string.
  • after can be used with either to or before. See  See  Pattern Clause Position Matching.

at

Include Page
at Parameter
at Parameter

...

Required?Data Type
NoArray of two Integers ( X,Y )

The at parameter cannot be combined with any of the following:  onafter,   before,   from,   to, and and quote.   See  Pattern Clause Position Matching.

before

Include Page
before Parameter
before Parameter

...

  • The after and from parameters are very similar.  from includes the matching value as part of the delimiter string.
  • from can be used with either to or beforeSee  Pattern Clause Position Matching .

on

Include Page
on Parameter
on Parameter

If the value does not appear in the source column, the original value is written to the first column of the split columns.

D code

split col: MyCol on: `###ERROR`

Output: Column into two columns. The first column contains values in the column appearing before ###ERROR, and the second column contains the values appearing after this string.

Tip

Tip: You can insert the Unicode equivalent character for this parameter value using a regular expression of the form /\uHHHH/. For example, /\u0013/ represents Unicode character 0013 (carriage return). For more information, see Supported Special Regular Expression Characters.

 

D s
snippetusage

Required?Data Type
NoString or pattern

to

Include Page
to Parameter
to Parameter

  • If this parameter is the only pattern describer: 
    • The column is split into two. The first column is blank. The second column contains the part of the source column after the to matching value. 
    • If the value appears more than once, no additional splitting is made, since there is no other pattern parameter.

      Info

      NOTE: For after, before, from, and to, matching occurs only one time at most. Additional instances of the parameter's value in the cell do not cause another column split. For more predictable results, you should specify another pattern parameter.

  • If the to value does not appear in the column, the original column value is written to the first split column.
  • This parameter is typically used with another to describe a field delimiting pattern. See below.

...

D s also
labelwrangle_transform_split