Task Factory - Urban Outfitters
"We have found that Task Factory tremendously speeds up the development process and improves performance by means of the high-performance components."

Tim Harris

BI Data Engineer

Urban Outfitters Inc.

Task Factory - Jay Cole
"I purchase Task Factory over a year ago, and let me tell you, IT WORKS FLAWLESSLY. I haven’t had a single problem with it, and I used to HATE having to make changes with the version you’re using. My advice (for what it’s worth) is to pay the money!"

Jay Cole

Task Factory
"I have found Task Factory to be a huge time saver with SSIS development. The SalesForce components alone saved close to two months of work on a major integration project. I highly recommend!"
Alan Rubel
Database Administrator
Joint Commission Resources
Task Factory - Mark Marinovic
"We bought Task Factory primarily for the SCD Type 2 task, as it enabled us to do several things the built-in SSIS SCD task did not do. Task Factory comes highly recommended from me as our ROI was reached in just days."

Mark Marinovic

Task Factory Loews Corporation
"We bought the product mostly because of the company's reputation for the service they provide and the specific need of a secure SFTP task."

Matt Cushing

Application Systems Analyst/Developer

Loews Corporation

Greater New York City Area



Buy Now Free Trial Download Compare Editions More Features

Task Factory Trim Plus Transform

The TrimPlus Transform provides a way for users to trim either whitespace or user defined characters from the beginning and end of source columns

Feature Highlights

There are 6 actions provided to trim characters
  • Whitespace trim actions – Trims whitespace from column data
    1. Trim all trailing and leading whitespace characters
    2. Trim all trailing whitespace characters
    3. Trim all leading whitespace characters

  • Specified character trim actions – Allows the user to defined the character(s) to be trimmed from the source column data
    1. Trim specified characters from start and end
    2. Trim specified characters from start
    3. Trim specified characters from end
Trim Plus Transform

Trim Plus Transform - Step 1
UI Overview

The Trim Plus Transform is a transform that allows the user to trim characters from the beginning and end of source data columns

UI Overview

The Trim Plus Transform is a transform that allows the user to trim characters from the beginning and end of source data columns

Trim Plus Transform - Step 2
Actions

The trim plus transform has 6 actions that can be used to trim characters from source data

Trim all leading and trailing white-space characters - This action will trim all the spaces and tabs from the beginning and end of the selected columns data

Trim all leading white-space characters - This action will trim all the spaces and tabs from the beginning of the selected columns data

Trim all trailing white-space characters - This action will trim all the spaces and tabs from the end of the selected columns data

Trim specified characters from start and end - This action will trim all the specified characters in the "Characters to be trimmed" parameter from the beginning and end of the selected columns data. Specify characters which you want to trim from the start or end. Certain characters that are difficult to enter by keyboard can be entered as escape sequence (e.g. Tab [\t], CarriageRerurn [\r], LineFeed [\n], VerticalTab [\v], SingleQuote [\'], DoubleQuotes [\"], NullCharacter [\0])

Trim specified characters from start - This action will trim all the specified characters in the "Characters to be trimmed" parameter from the beginning of the selected columns data. Specify characters which you want to trim from the start or end. Certain characters that are difficult to enter by keyboard can be entered as escape sequence (e.g. Tab [\t], CarriageRerurn [\r], LineFeed [\n], VerticalTab [\v], SingleQuote [\'], DoubleQuotes [\"], NullCharacter [\0])

Trim specified characters from end - This action will trim all the specified characters in the "Characters to be trimmed" parameter from the end of the selected columns data. Specify characters which you want to trim from the start or end. Certain characters that are difficult to enter by keyboard can be entered as escape sequence (e.g. Tab [\t], CarriageRerurn [\r], LineFeed [\n], VerticalTab [\v], SingleQuote [\'], DoubleQuotes [\"], NullCharacter [\0])

Actions

The trim plus transform has 6 actions that can be used to trim characters from source data

Trim all leading and trailing white-space characters - This action will trim all the spaces and tabs from the beginning and end of the selected columns data

Trim all leading white-space characters - This action will trim all the spaces and tabs from the beginning of the selected columns data

Trim all trailing white-space characters - This action will trim all the spaces and tabs from the end of the selected columns data

Trim specified characters from start and end - This action will trim all the specified characters in the "Characters to be trimmed" parameter from the beginning and end of the selected columns data. Specify characters which you want to trim from the start or end. Certain characters that are difficult to enter by keyboard can be entered as escape sequence (e.g. Tab [\t], CarriageRerurn [\r], LineFeed [\n], VerticalTab [\v], SingleQuote [\'], DoubleQuotes [\"], NullCharacter [\0])

Trim specified characters from start - This action will trim all the specified characters in the "Characters to be trimmed" parameter from the beginning of the selected columns data. Specify characters which you want to trim from the start or end. Certain characters that are difficult to enter by keyboard can be entered as escape sequence (e.g. Tab [\t], CarriageRerurn [\r], LineFeed [\n], VerticalTab [\v], SingleQuote [\'], DoubleQuotes [\"], NullCharacter [\0])

Trim specified characters from end - This action will trim all the specified characters in the "Characters to be trimmed" parameter from the end of the selected columns data. Specify characters which you want to trim from the start or end. Certain characters that are difficult to enter by keyboard can be entered as escape sequence (e.g. Tab [\t], CarriageRerurn [\r], LineFeed [\n], VerticalTab [\v], SingleQuote [\'], DoubleQuotes [\"], NullCharacter [\0])

Trim Plus Transform - Step 3
Output Actions

The Trim Plus transforms has the option of either replacing the data from a source column and outputting the replaced data into the same column or creating a new output column.

Output Actions

The Trim Plus transforms has the option of either replacing the data from a source column and outputting the replaced data into the same column or creating a new output column.

Trim Plus Transform - Step 4
If "Output the fixed data to a new output column" is chosen, the new output column name will be "inputcolumn_output". For instance, if the source column is "FirstName", the output column will be "FirstName_output".

If "Output the fixed data to a new output column" is chosen, the new output column name will be "inputcolumn_output". For instance, if the source column is "FirstName", the output column will be "FirstName_output".

View Our Suite of Pragmatic Works Products
Copyright 2014 by Pragmatic Works