Text Trimming Rule (trim_text)

Trims text from a string in the source column and adds the result to a target column.

Field	Description	Required
source_column	The column where values are trimmed from.	✅ Yes
destination_column	The column where trimmed values are copied. Can be an existing or new column. Can be the same as the source_column, which will replace the original value with the trimmed value.	✅ Yes
trim_whitespace	Must be either none, left, right, or both. Controls how whitespace is trimmed from final values in the destination_column. none: Whitespace is not trimmed from result. left: Whitespace is trimmed from left side result only. right: Whitespace is trimmed from right side of result only. both: Whitespace is trimmed from left and right sides of result.	✅ Yes (default: none)
trim_type	Either left, right, or middle. Determines where the trim will start. left: Trim from beginning of value to end_position right: Trim from end of value to start_position middle: Trim from start_position to end_position	✅ Yes
start_position	Required for Trim Type right and middle. Any values ignored for Trim Type Left. Positive values start from first character and count forward, negative values start from last character and count backwards.	⚠️ Conditional
end_position	Required for Trim Type left and middle. Any values ignored for Trim Type Right. Positive values start from first character and count forward, negative values start from last character and count backwards.	⚠️ Conditional
strict_bounds	When attempting to trim data values, determines if index positions that are out of bounds for a value should prevent the rule from completing. If disabled, destination_column values for these cases will populate with an error message.	❌ No (default: false)

Example:

{
  "type": "trim_text",
  "source_column": "dose",
  "destination_column": "dose_trimmed",
  "trim_whitespace": "right",
  "trim_type": "left",
  "start_position": null,
  "end_position": 3,
  "strict_bounds": false
}

Behavior: Trims values from the dose column starting from the 1st character, and ending at the 3rd character, and copies to the dose_trimmed column. Note that trim_whitespace is set to right which removes trailing whitespace.

• "10 mg" ➔ "10"
• "100 mg" ➔ "100"

{
  "type": "trim_text",
  "source_column": "dose",
  "destination_column": "dose_trimmed",
  "trim_whitespace": "none",
  "trim_type": "middle",
  "start_position": 2,
  "end_position": 4,
  "strict_bounds": false
}

Behavior: Trims values from the dose column starting from the 2nd character, ending at the 4th character, and copies to the dose_trimmed column.

• "10 mg" ➔ "0 m"
• "100 mg" ➔ "00"

{
  "type": "trim_text",
  "source_column": "day",
  "destination_column": "day_trimmed",
  "trim_type": "right",
  "start_position": 4,
  "trim_whitespace": "none",
  "strict_bounds": false
}

Behavior: Trims values from the day column starting at the 4th character, and ending at the end of the value, and copies to the day_trimmed column. Note that trim_whitespace is set to none so white space is preserved.

• "Day 1" ➔ " 1"
• "Day 14" ➔ " 14"
• "Days 28" ➔ "s 28"

{
  "type": "trim_text",
  "source_column": "day",
  "destination_column": "day_trimmed",
  "trim_type": "right",
  "start_position": -2,
  "trim_value": "left",
  "strict_bounds": false
}

Behavior: Trims values from the day column starting -2 positions from the right, and ending at the end of the value, and copies to the day_trimmed column. Note that trim_whitespace is set to right which removes trailing whitespace.

• "Day 1" ➔ "1"
• "Day 14" ➔ "14"
• "Day 28" ➔ "28"