SSIS:Generalized Cleanser:Component - Revision history

Admin at 00:32, 27 August 2022

2022-08-27T00:32:25Z

@@ Line 21: / Line 21: @@
 ;Regular Expression Search Replace
 :Searches for an expression and will replace that expression with another expression or data. (E.x. Resumé &rarr; Resum)
 ;Text Search Replace

Admin at 22:32, 27 January 2017

2017-01-27T22:32:27Z

← Older revision		Revision as of 22:32, 27 January 2017
Line 8:		Line 8:

	==Cleansing Details==		==Cleansing Details==
	These are the ~~rules~~ you are creating to cleanse your data. The following ~~rules~~ are available for your use:		These are the operations you are creating to cleanse your data. The following operations are available for your use:

	;Case		;Case
Line 24:		Line 24:
	;Text Search Replace		;Text Search Replace
	:Searches for a string to replace with another string. (E.x. Volvo → Toyota)		:Searches for a string to replace with another string. (E.x. Volvo → Toyota)


			The Generalized Cleanser takes into account order of operations. Meaning it will execute all operations in a rule in order from top to bottom. Once you’ve finished creating your operations, we suggest you save your operations within a rule with a name and short description for future use.

Admin at 22:28, 25 January 2017

2017-01-25T22:28:47Z

← Older revision		Revision as of 22:28, 25 January 2017
Line 20:		Line 20:

	;Regular Expression Search Replace		;Regular Expression Search Replace
	:Searches for an expression and will replace that expression with another expression or data. (E.x. Resumé  Resum)		:Searches for an expression and will replace that expression with another expression or data. (E.x. Resumé → Resum)

	;Text Search Replace		;Text Search Replace

Admin at 22:28, 25 January 2017

2017-01-25T22:28:34Z

← Older revision		Revision as of 22:28, 25 January 2017
Line 11:		Line 11:

	;Case		;Case
	:Cleanses the casing for your data (e.x. MeLiSa DaTA  Melissa Data)		:Cleanses the casing for your data (e.x. MeLiSa DaTA → Melissa Data)

	;Punctuation		;Punctuation

Admin at 22:28, 25 January 2017

2017-01-25T22:28:17Z

← Older revision		Revision as of 22:28, 25 January 2017
Line 23:		Line 23:

	;Text Search Replace		;Text Search Replace
	:Searches for a string to replace with another string. (E.x. Volvo  Toyota)		:Searches for a string to replace with another string. (E.x. Volvo → Toyota)

Admin at 22:27, 25 January 2017

2017-01-25T22:27:40Z

← Older revision		Revision as of 22:27, 25 January 2017
Line 28:		Line 28:
	==Triggers==		==Triggers==
	There are 3 triggers that you can use to determine whether or not a rule should be used for a record:		There are 3 triggers that you can use to determine whether or not a rule should be used for a record:


	;None		;None

Admin: Created page with "{{SSISGeneralizedCleanserNav}} {{CustomTOC}} link= ==Cleansing Details== These are the rules you are creating to cleanse your data. The follow..."

2017-01-25T22:27:24Z

Created page with "{{SSISGeneralizedCleanserNav}} {{CustomTOC}} link= ==Cleansing Details== These are the rules you are creating to cleanse your data. The follow..."

New page

{{SSISGeneralizedCleanserNav}}

{{CustomTOC}}

[[File:SSIS_GC_Source.png|link=]]

==Cleansing Details==
These are the rules you are creating to cleanse your data. The following rules are available for your use:

;Case
:Cleanses the casing for your data (e.x. MeLiSa DaTA  Melissa Data)

;Punctuation
:Cleanses the punctuation for your data (e.x. FIND EXAMPLE)

;Expression
:Removes your data and replaces with an expression

;Regular Expression Search Replace
:Searches for an expression and will replace that expression with another expression or data. (E.x. Resumé  Resum)

;Text Search Replace
:Searches for a string to replace with another string. (E.x. Volvo  Toyota)

==Triggers==
There are 3 triggers that you can use to determine whether or not a rule should be used for a record:

;None
:This will trigger on every record.

;Expression
:Only trigger when a record matches this expression.

;Regular Expression
:Only trigger when a record matches this regular expression.

[[Category:SSIS]]
[[Category:SSIS Generalized Cleanser]]