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 - 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 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

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 - 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



Buy Now Free Trial Download Compare Editions More Features

Task Factory Case Transform

The Case Transform provides a way to properly case, upper case or lowercase all the text in a source column. The component is designed for the English language. 
 
 There is a single action which is “Convert string to Proper case” but there are many styles in which the data can be properly cased data.

The Styles are:

  • SimpleProperCase – Capitalize the First Letter of Each Word (reference file is not used so its very fast but no symbol/word replacement is performed like other styles)
    1. Text_In : the cOw jumped Over the MOON
    2. Text_Out: The Cow Jumped Over The Moon
  • Name – Standardize Prefixes & Suffixes
    1. Text_In : MR / MRS JOHN VAN DER CAMP PHD
    2. Text_Out: Mr and Mrs John Van der Camp, Ph. D.
  • Address –Eliminate Conflict Between Street Suffix & City / State / Zip
    1. Text_In : 1234 SE 41ST CT APT 26E (CT is also the abbreviation for Connecticut)
    2. Text_Out: 1234 SE 41st Ct, Apt. 26E
  • CSZ (City State Zip) – Avoid Confusion Between “Company” & “Colorado”
    1. Text_In : PINE, CO 80470
    2. Text_Out: Pine, CO 80470
  • Title – Capitalize the First Letter of Each Word, Convert Symbols
    1. Text_In : (c) PRAGMATICWORKS, INCORPORATED
    2. Text_Out: © Pragmatic Works, Inc
  • Sentence – Capitalize the First Letter of Each Sentence
    1. Text_In : TASKFACTORY(tm) IS A TRADEMARK OF PRAGMATICWORKS INC.
    2. Text_Out: TaskFactory™ is a trademark of Pragmatic Works Inc.
  • UpperCase – Capitalize each letter in the column data
    1. Text_In : hi, this is task factory.
    2. Text_Out: HI, THIS IS TASK FACTORY.
  • LowerCase – Lowercase each letter in the column data
    1. Text_In : Hi, This is Task Tactory
    2. Text_Out: hi, this is task factory.
Case Transform

Case Transform - Step 1

The case transform gives developers the ability to easilyset names and addresses to proper case.
Add the case transform to a data flow. Double click it toopen the configuration editor.

The case transform gives developers the ability to easilyset names and addresses to proper case.
Add the case transform to a data flow. Double click it toopen the configuration editor.

Case Transform - Step 2

Next to a column to be transformed, click the ‘ChooseAction’ drop down menu. Select an action.
After selecting an action, there is alist of parameters to fine tune how the data will be transformed.

Next to a column to be transformed, click the ‘ChooseAction’ drop down menu. Select an action.
After selecting an action, there is alist of parameters to fine tune how the data will be transformed.

Case Transform - Step 3

Click OK. The selected action is assigned to the column.

Click OK. The selected action is assigned to the column.

Case Transform - Step 4
Click ok again. Add a data viewer before and after thetransform.
The data viewers will display the data and show the columns that have been formatted.

Click ok again. Add a data viewer before and after thetransform.
The data viewers will display the data and show the columns that have been formatted.

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