Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 2 Next »

Description

This step allows you to cut a portion of a substring. If the designated field is out of range, it returns blank.

Option

Definition

Step name

The name of this step as it appears in the transformation workspace.

In stream field

Name of the field whose substring to cut.

Out stream field

When a field name is given here, the step creates a new field with the substring. Otherwise the original field gets replaced by the substring.

Cut from

Designate where to begin cutting the substring. This value is 0-based, thus the first character in a string is 0.

Cut to

Designate where to end cutting the substring. This value is exclusive (1-based), so using a 1 includes the first character. The maximum length of the new string is Cut to minus Cut from.

  • No labels