Listware for Excel:Global:Cleansing Operations - Revision history

Admin at 23:48, 26 December 2019

2019-12-26T23:48:09Z

← Older revision		Revision as of 23:48, 26 December 2019
Line 42:		Line 42:


	For more information on Melissa Data Credits, please see [~~http~~://www.~~melissadata~~.com/~~dqt~~/~~credit-summary.htm~~ Credit Costs].		For more information on Melissa Data Credits, please see [https://www.melissa.com/pricing/listware Credit Costs].


	[[Category:Listware for Excel]]		[[Category:Listware for Excel]]

Admin at 23:46, 31 May 2018

2018-05-31T23:46:50Z

@@ Line 1: / Line 1: @@
-[[Listware for Excel:Reference|&larr; Listware for Excel Reference]]
+{{LWEGlobalNav
+|StepsCollapse=
-{| class="mw-collapsible" cellspacing="2" style="background-color:#f9f9f9; border:1px solid #aaaaaa; font-size:9pt; color:#0645ad; padding:8px 8px;"
+}}
 {{CustomTOC}}

Admin at 20:56, 19 September 2014

2014-09-19T20:56:50Z

← Older revision		Revision as of 20:56, 19 September 2014
Line 84:		Line 84:


	For more information on Melissa Data Credits, please see [[http://www.melissadata.com/dqt/credit-summary.htm Credit Costs]].		For more information on Melissa Data Credits, please see [http://www.melissadata.com/dqt/credit-summary.htm Credit Costs].


	[[Category:Listware for Excel]]		[[Category:Listware for Excel]]

Admin at 20:56, 19 September 2014

2014-09-19T20:56:38Z

← Older revision		Revision as of 20:56, 19 September 2014
Line 82:		Line 82:
	;Credit Usage		;Credit Usage
	:Displays the estimated credit usage of your data cleansing process.		:Displays the estimated credit usage of your data cleansing process.


			For more information on Melissa Data Credits, please see [[http://www.melissadata.com/dqt/credit-summary.htm Credit Costs]].


	[[Category:Listware for Excel]]		[[Category:Listware for Excel]]

Admin at 21:43, 15 September 2014

2014-09-15T21:43:20Z

← Older revision		Revision as of 21:43, 15 September 2014
Line 2:		Line 2:

	{\| class="mw-collapsible" cellspacing="2" style="background-color:#f9f9f9; border:1px solid #aaaaaa; font-size:9pt; color:#0645ad; padding:8px 8px;"		{\| class="mw-collapsible" cellspacing="2" style="background-color:#f9f9f9; border:1px solid #aaaaaa; font-size:9pt; color:#0645ad; padding:8px 8px;"
	! style="text-align:left; color:black; border-bottom:1px solid #aaaaaa;"\|'''Global Navigation'''		! style="text-align:left; color:black; border-bottom:1px solid #aaaaaa;"\|'''Global Check and Verify Navigation'''
	\|-		\|-
	\| style="padding-right:220px;"\|		\| style="padding-right:220px;"\|
			\|-
			\|style="border-bottom:1px solid #aaaaaa;"\|[[Listware for Excel:Check and Verify\|← Check and Verify]]
	\|-		\|-
	\|[[Listware for Excel:Global\|Overview]]		\|[[Listware for Excel:Global\|Overview]]

Admin: Created page with "← Listware for Excel Reference {| class="mw-collapsible" cellspacing="2" style="background-color:#f9f9f9; border:1px solid #aaaaaa; font..."

2014-07-07T17:54:02Z

Created page with "← Listware for Excel Reference {| class="mw-collapsible" cellspacing="2" style="background-color:#f9f9f9; border:1px solid #aaaaaa; font..."

New page

[[Listware for Excel:Reference|← Listware for Excel Reference]]

{| class="mw-collapsible" cellspacing="2" style="background-color:#f9f9f9; border:1px solid #aaaaaa; font-size:9pt; color:#0645ad; padding:8px 8px;"
! style="text-align:left; color:black; border-bottom:1px solid #aaaaaa;"|'''Global Navigation'''
|-
| style="padding-right:220px;"|
|-
|[[Listware for Excel:Global|Overview]]
|-
|[[Listware for Excel:Global Tutorial|Tutorial]]
|-
|
{| class="mw-collapsible" style="width:100%;"
|- align="left"
! style="color:black;"|Steps
|-
|[[Listware for Excel:Global:Processing Range|Processing Range]]
|-
|[[Listware for Excel:Global:Cleansing Operations|Cleansing Operations]]
|-
|[[Listware for Excel:Global:Input Columns|Input Columns]]
|-
|[[Listware for Excel:Global:Output Columns|Output Columns]]
|-
|[[Listware for Excel:Global:Reporting|Reporting]]
|-
|[[Listware for Excel:Global:Review Settings|Review Settings]]
|-
|[[Listware for Excel:Global:Processing|Processing]]
|-
|[[Listware for Excel:Global:Review Results|Review Results]]
|}
|-
|
{| class="mw-collapsible mw-collapsed" style="width:100%;"
|- align="left"
! style="color:black;"|Result Codes
|-
|[[Returned Result Codes:Software#Listware for Excel|Returned Result Codes]]
|-
|[[Result Codes]]
|}
|}

{{CustomTOC}}

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

Check the operation(s) you want to perform and specify your origin country, output script, and default country.

The following operations are available:

;Check
:The Check action determines whether the data within a submitted record is valid, e.g. whether or not a given postal code contains the given city. It can also make limited corrections and appends to the data. Check looks at each data point separately, the inputs you put in for email don't affect what Check does with an address. Check returns results codes that describe which inputs were invalid, valid, or corrected. It also returns the input data after it has been corrected and added.

;Country of Origin
:The origin country. This is used for mailing information in the Formatted Address output column.

;Output Script
:The character set used to format the output data. You can choose:

;:*Match Input

:::The output character set will match the input character set.

;:*Latin

:::The output character set will be latin.

;:*Native

:::The output character set will match the address's country.

;Default Country
:When no country column is specified or the record's country column is blank, this will set the default country for that record.

;Credit Balance
:Displays your credit balance.

;Credit Usage
:Displays the estimated credit usage of your data cleansing process.

[[Category:Listware for Excel]]