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

From Melissa Data Wiki
Jump to navigation Jump to search
No edit summary
No edit summary
Line 98: Line 98:


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

Revision as of 20:15, 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);