Listware for Excel:US:Input Columns: Difference between revisions

From Melissa Data Wiki
Jump to navigation Jump to search
No edit summary
No edit summary
 
Line 1: Line 1:
[[Listware for Excel:Reference|← Listware for Excel Reference]]
{{LWEUSNav
 
|StepsCollapse=
{| 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;"|'''US Check and Verify Navigation'''
|-
| style="padding-right:220px;"|
|-
|style="border-bottom:1px solid #aaaaaa;"|[[Listware for Excel:Check and Verify|← Check and Verify]]
|-
|[[Listware for Excel:US|Overview]]
|-
|[[Listware for Excel:US Tutorial|Tutorial]]
|-
|
{| class="mw-collapsible" style="width:100%;"
|- align="left"
! style="color:black;"|Steps
|-
|[[Listware for Excel:US:Processing Range|Processing Range]]
|-
|[[Listware for Excel:US:Cleansing Operations|Cleansing Operations]]
|-
|[[Listware for Excel:US:Input Columns|Input Columns]]
|-
|[[Listware for Excel:US:Output Columns|Output Columns]]
|-
|[[Listware for Excel:US:Reporting|Reporting]]
|-
|[[Listware for Excel:US:Review Settings|Review Settings]]
|-
|[[Listware for Excel:US:Processing|Processing]]
|-
|[[Listware for Excel:US: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}}
{{CustomTOC}}

Latest revision as of 23:57, 31 May 2018

← Listware for Excel Reference

US Check and Verify Navigation
← US & Canada
Overview
Tutorial
Steps
Processing Range
Cleansing Operations
Input Columns
Output Columns
Reporting
Review Settings
Processing
Review Results
Result Codes



Specify the input columns you want to process by selecting them in the drop-down menus.

The following input columns are available:


Name

If the names are split into first and last names, specify those columns in 'First Name' and 'Last Name' instead. Alternatively, if the names are not split specify that column in 'Full Name'.

Full Name
Specify the column that contains full names.
First Name
Specify the column that contains first names.
Last Name
Specify the column that contains last names.


Address

Company
Specify the column that contains company and/or organization names.
Address
Specify the column that contains street or PO Box addresses.
Address 2
Specify the column that contains a second address line. If available, this is generally extra addressing information such as an apartment or suite numbers.
If the information is in the "Address" column, it will be found and parsed to this column when you specify that column here.
City
Specify the column that contains cities.
State
Specify the column that contains the US state and/or Canadian province.
ZIP Code
Specify the column that contains the US ZIP code and/or Canadian Postal Code.
Country
Specify the column that contains the country name (US or Canada).
Although US Check & Verify can often identify an address's country of origin by looking at the address, sometimes address verification can improve if the country is provided.


Phone

Specify the column that contains phone numbers.


E-mail

Specify the column that contains e-mail addresses.