Profiler Object:Column-Based Phone Statistics

From Melissa Data Wiki
Jump to navigation Jump to search

← 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
Frequency 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
Profiler Object 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);