Profiler Object:Column-Based Zip/Postal Code Statistics

← Profiler Object Reference

The statistics are only accumulated for the DataTypeZipOrPostalCode and DataTypeCityStateZip data types. See ProfilerDataType Enumerations for details. They should only be retrieved after calling the ProfileData function.

GetColumnZipCodeCount

This function returns a column's number of records that contain US ZIP codes. This includes 5-digit ZIP and ZIP Plus 4 codes.

This function takes one parameter.

Parameters

Name	Data Type	Description
ColumnName	String	Column Name to get the number of records that contain US Zip codes.

Syntax	profiler->GetColumnZipCodeCount(columnNameStr);
C	integer = mdProfilerGetColumnZipCodeCount(profiler,columnNameStr);
.Net	integer = profiler.GetColumnZipCodeCount(columnNameStr);

GetColumnPlus4Count

This function returns a column's number of records with a full ZIP Plus 4 codes.

This function takes one parameter.

Parameters

Name	Data Type	Description
ColumnName	String	Column Name to get the number of records that contain full US ZIP Plus 4 codes.

Return Value This function returns number of records contains Plus4 in numerical form

Syntax	profiler->GetColumnPlus4Count(columnNameStr);
C	integer = mdProfilerGetColumnPlus4Count(profiler,columnNameStr);
.Net	integer = profiler.GetColumnPlus4Count(columnNameStr);

GetColumnZipCodeInvalidCount

This function returns a column's number of records that contain invalid US ZIP codes. This is a check against known US ZIP codes, State is not taken into account for this check.

This function takes one parameter.

Parameters

Name	Data Type	Description
ColumnName	String	Column Name to get the number of records that contain invalid US Zip codes.

Syntax	profiler->GetColumnZipCodeInvalidCount(columnNameStr);
C	integer = mdProfilerGetColumnZipCodeInvalidCount(profiler,columnNameStr);
.Net	integer = profiler.GetColumnZipCodeInvalidCount(columnNameStr);

GetColumnPostalCodeCount

This function returns a column's number of records that contain Canadian postal codes.

This function takes one parameter.

Parameters

Name	Data Type	Description
ColumnName	String	Column Name to get number of records contains Canadian postal code.

Syntax	profiler->GetColumnPostalCodeCount(columnNameStr);
C	integer = mdProfilerGetColumnPostalCodeCount(profiler,columnNameStr);
.Net	integer = profiler.GetColumnPostalCodeCount(columnNameStr);

GetColumnPostalCodeInvalidCount

This function returns a column's number of records that contain invalid Canadian postal codes. This is a check against known Canadian postal codes, Province is not taken into account for this check.

This function takes one parameter.

Parameters

Name	Data Type	Description
ColumnName	String	Column Name to get the number of records that contain invalid Canadian postal codes.

Syntax	profiler->GetColumnPostalCodeInvalidCount(columnNameStr);
C	integer = mdProfilerGetColumnPostalCodeInvalidCount(profiler,columnNameStr);
.Net	integer = profiler.GetColumnPostalCodeInvalidCount(columnNameStr);

GetColumnZipCodePostalCodeInvalidCount

This function returns a column's number of records that contain neither US ZIP codes nor Canadian postal codes. The pattern doesn’t fit into either country’s postal code format.

This function takes one parameter.

Parameters

Name	Data Type	Description
ColumnName	String	Column Name to get the number of records that contain invalid ZIP/Postal codes.

Syntax	profiler->GetColumnZipCodePostalCodeInvalidCount(columnNameStr);
C	integer = mdProfilerGetColumnZipCodePostalCodeInvalidCount(profiler,columnNameStr);
.Net	integer = profiler.GetColumnZipCodePostalCodeInvalidCount(columnNameStr);

GetColumnStateZipCodeMismatchCount

This function returns a column's number of records with a mismatch of US state and ZIP code.

This function takes one parameter.

Parameters

Name	Data Type	Description
ColumnNameStr	String	Column Name to get the number of records that contain mismatched US state and ZIP code.

Syntax	profiler->GetColumnStateZipCodeMismatchCount(ColumnNameStr);
C	integer = mdProfilerGetColumnStateZipCodeMismatchCount(profiler,columnNameStr);
.Net	integer = profiler.GetColumnStateZipCodeMismatchCount(columnNameStr);

GetColumnProvincePostalCodeMismatchCount

This function returns a column's number of records with a mismatch of Canadian province and postal code.

This function takes one parameter.

Parameters

Name	Data Type	Description
ColumnNameStr	String	Column Name to get the number of records that contain mismatched Canadian province and postal code.

Syntax	profiler->GetColumnProvincePostalCodeMismatchCount(ColumnNameStr);
C	integer = mdProfilerGetColumnProvincePostalCodeMismatchCount(profiler,columnNameStr);
.Net	integer = profiler.GetColumnProvincePostalCodeMismatchCount(columnNameStr);