Profiler Object:Column-Based Phone Statistics: Difference between revisions

From Melissa Data Wiki
Jump to navigation Jump to search
Created page with " ← Profiler Object Reference {| class="mw-collapsible" cellspacing="2" style="background-color:#f9f9f9; border:1px solid #aaaaaa; font-size..."
 
No edit summary
Line 27: Line 27:
{| class="mw-collapsible" style="width:100%;"
{| class="mw-collapsible" style="width:100%;"
|- align="left"
|- align="left"
! style="color:black;"|[[Profiler Object:Column-Based Statistics|Column-Based Statistics]]
! style="color:black; text-align:left;"|[[Profiler Object:Column-Based Statistics|Column-Based Statistics]]
|-
|-
|[[Profiler Object:Column-Based String Statistics|Column-Based String Statistics]]
|[[Profiler Object:Column-Based String Statistics|Column-Based String Statistics]]
Line 52: Line 52:
{| class="mw-collapsible mw-collapsed" style="width:100%;"
{| class="mw-collapsible mw-collapsed" style="width:100%;"
|- align="left"
|- align="left"
! style="color:black;"|[[Profiler Object:Iterators|Iterators]]
! style="color:black; text-align:left;"|[[Profiler Object:Iterators|Iterators]]
|-
|-
|[[Profiler Object:Column-Based Value Frequency Table Iteration|Column-Based Value Frequency Table Iteration]]
|[[Profiler Object:Column-Based Value Frequency Table Iteration|Column-Based Value Frequency Table Iteration]]
Line 73: Line 73:
{| class="mw-collapsible mw-collapsed" style="width:100%;"
{| class="mw-collapsible mw-collapsed" style="width:100%;"
|- align="left"
|- align="left"
! style="color:black;"|[[Profiler Object:Result Codes|Result Codes]]
! style="color:black; text-align:left;"|[[Profiler Object:Result Codes|Result Codes]]
|-
|-
|[[Returned Result Codes:APIs#Profiler Object|Returned Result Codes]]
|[[Returned Result Codes:APIs#Profiler Object|Returned Result Codes]]

Revision as of 18:53, 2 February 2015

← Profiler Object Reference

Profiler Object Interface Navigation
Initialization
Object Information
Enumeration Listing and Parsing
Column Specification
Initiate Profiling
Data Input
Profiling
Table-Based Statistics
Column-Based Statistics
Column-Based String Statistics
Column-Based Numeric Statistics
Column-Based Date/Time Statistics
Column-Based Name Statistics
Column-Based State/Province Statistics
Column-Based Zip/Postal Code Statistics
Column-Based Country Statistics
Column-Based Email Statistics
Column-Based Phone Statistics
Iterators
Column-Based Value Frequency Table Iteration
Column-Based Value Length Frequency Table Iteration
Column-Based Value Pattern Table Iteration
Column-Based Value Date/Time Table Iteration
Column-Based Value SoundEx Table Iteration
Column-Based Word Table Iteration
Column-Based Word Length Table Iteration
Result Codes
Returned Result Codes
Result Codes


These statistics are only accumulated for DataTypePhone columns. See ProfilerDataType Enumerations for details. They should only be retrieved after calling the ProfileData function.

GetColumnPhoneInvalidCount

This function returns a column's number of records that contain non-US or non-Canadian phone numbers. Specifically, the numeric pattern doesn't correspond with the US/Canadian phone numbering system.

This function takes one parameter.

Name Data Type Description
ColumnName String Column Name to get the number of records that contain non-US or non-Canadian phone numbers.


Syntax profiler->GetColumnPhoneInvalidCount(columnNameStr););
C integer = mdProfilerGetColumnPhoneInvalidCount(profiler,columnNameStr);
.Net integer = profiler.GetColumnPhoneInvalidCount(columnNameStr);