CSV Validation Rules Schema

Modified on Wed, 2 Jul, 2014 at 12:26 PM

Element: csv

Description: Root element.

 

Attributes:

Name

Usage

Default

Description

type

optional

TSI_CSV

Generated document type.

 

Child elements:

Name

Min Occurs

Max Occurs

Description

structure

1

unbounded

Csv structure.

customizeMessages

1

unbounded

Global error messages overrides.

 

Element: structure

Parent: csv

Description: Csv structure.

 

Attributes:

Name

Usage

Default

Description

hasHeader

required

 

Determines if csv file should have header.

encoding

optional

auto

Determines csv encoding which will be used for reading source file.
Values:

  • auto - attempt to autodetect encoding. Will try to detect encoding using byte order mask at the beginning of the file (Unicode or UTC-8). If no byte order mask found in file, ASCII will be used
  • Encodings supported by .NET Framework, see http://msdn.microsoft.com/en-us/library/system.text.encoding(v=vs.110).aspx

delimiter

optional

,

Regular expression for column delimiter.

culture

optional

invariant

Culture for validating dates and numbers.
Values:

  • af-ZA Afrikaans - South Africa
  • sq-AL Albanian - Albania
  • ar-DZ Arabic - Algeria
  • ar-BH Arabic - Bahrain
  • ar-EG Arabic - Egypt
  • ar-IQ Arabic - Iraq
  • ar-JO Arabic - Jordan
  • ar-KW Arabic - Kuwait
  • ar-LB Arabic - Lebanon
  • ar-LY Arabic - Libya
  • ar-MA Arabic - Morocco
  • ar-OM Arabic - Oman
  • ar-QA Arabic - Qatar
  • ar-SA Arabic - Saudi Arabia
  • ar-SY Arabic - Syria
  • ar-TN Arabic - Tunisia
  • ar-AE Arabic - United Arab Emirates
  • ar-YE Arabic - Yemen
  • hy-AM Armenian - Armenia
  • Cy-az-AZ Azeri (Cyrillic) - Azerbaijan
  • Lt-az-AZ Azeri (Latin) - Azerbaijan
  • eu-ES Basque - Basque
  • be-BY Belarusian - Belarus
  • bg-BG Bulgarian - Bulgaria
  • ca-ES Catalan - Catalan
  • zh-CN Chinese - China
  • zh-HK Chinese - Hong Kong SAR
  • zh-MO Chinese - Macau SAR
  • zh-SG Chinese - Singapore
  • zh-TW Chinese - Taiwan
  • zh-CHS Chinese (Simplified)
  • zh-CHT Chinese (Traditional)
  • hr-HR Croatian - Croatia
  • cs-CZ Czech - Czech Republic
  • da-DK Danish - Denmark
  • div-MV Dhivehi - Maldives
  • nl-BE Dutch - Belgium
  • nl-NL Dutch - The Netherlands
  • en-AU English - Australia
  • en-BZ English - Belize
  • en-CA English - Canada
  • en-CB English - Caribbean
  • en-IE English - Ireland
  • en-JM English - Jamaica
  • en-NZ English - New Zealand
  • en-PH English - Philippines
  • en-ZA English - South Africa
  • en-TT English - Trinidad and Tobago
  • en-GB English - United Kingdom
  • en-US English - United States
  • en-ZW English - Zimbabwe
  • et-EE Estonian - Estonia
  • fo-FO Faroese - Faroe Islands
  • fa-IR Farsi - Iran
  • fi-FI Finnish - Finland
  • fr-BE French - Belgium
  • fr-CA French - Canada
  • fr-FR French - France
  • fr-LU French - Luxembourg
  • fr-MC French - Monaco
  • fr-CH French - Switzerland
  • gl-ES Galician - Galician
  • ka-GE Georgian - Georgia
  • de-AT German - Austria
  • de-DE German - Germany
  • de-LI German - Liechtenstein
  • de-LU German - Luxembourg
  • de-CH German - Switzerland
  • el-GR Greek - Greece
  • gu-IN Gujarati - India
  • he-IL Hebrew - Israel
  • hi-IN Hindi - India
  • hu-HU Hungarian - Hungary
  • is-IS Icelandic - Iceland
  • id-ID Indonesian - Indonesia
  • it-IT Italian - Italy
  • it-CH Italian - Switzerland
  • ja-JP Japanese - Japan
  • kn-IN Kannada - India
  • kk-KZ Kazakh - Kazakhstan
  • kok-IN Konkani - India
  • ko-KR Korean - Korea
  • ky-KZ Kyrgyz - Kazakhstan
  • lv-LV Latvian - Latvia
  • lt-LT Lithuanian - Lithuania
  • mk-MK Macedonian (FYROM)
  • ms-BN Malay - Brunei
  • ms-MY Malay - Malaysia
  • mr-IN Marathi - India
  • mn-MN Mongolian - Mongolia
  • nb-NO Norwegian (Bokmål) - Norway
  • nn-NO Norwegian (Nynorsk) - Norway
  • pl-PL Polish - Poland
  • pt-BR Portuguese - Brazil
  • pt-PT Portuguese - Portugal
  • pa-IN Punjabi - India
  • ro-RO Romanian - Romania
  • ru-RU Russian - Russia
  • sa-IN Sanskrit - India
  • Cy-sr-SP Serbian (Cyrillic) - Serbia
  • Lt-sr-SP Serbian (Latin) - Serbia
  • sk-SK Slovak - Slovakia
  • sl-SI Slovenian - Slovenia
  • es-AR Spanish - Argentina
  • es-BO Spanish - Bolivia
  • es-CL Spanish - Chile
  • es-CO Spanish - Colombia
  • es-CR Spanish - Costa Rica
  • es-DO Spanish - Dominican Republic
  • es-EC Spanish - Ecuador
  • es-SV Spanish - El Salvador
  • es-GT Spanish - Guatemala
  • es-HN Spanish - Honduras
  • es-MX Spanish - Mexico
  • es-NI Spanish - Nicaragua
  • es-PA Spanish - Panama
  • es-PY Spanish - Paraguay
  • es-PE Spanish - Peru
  • es-PR Spanish - Puerto Rico
  • es-ES Spanish - Spain
  • es-UY Spanish - Uruguay
  • es-VE Spanish - Venezuela
  • sw-KE Swahili - Kenya
  • sv-FI Swedish - Finland
  • sv-SE Swedish - Sweden
  • syr-SY Syriac - Syria
  • ta-IN Tamil - India
  • tt-RU Tatar - Russia
  • te-IN Telugu - India
  • th-TH Thai - Thailand
  • tr-TR Turkish - Turkey
  • uk-UA Ukrainian - Ukraine
  • ur-PK Urdu - Pakistan
  • Cy-uz-UZ Uzbek (Cyrillic) - Uzbekistan
  • Lt-uz-UZ Uzbek (Latin) - Uzbekistan
  • vi-VN Vietnamese - Vietnam

terminator

optional

\r?\n

Regular expression for line terminator

ignoreLastBlankRow

optional

false

Specifies if last blank row of CSV file should be ignored. Default is false. This parameter is used in cas CSV file ends with line terminator, which means that last CSV line exists and has no columns.

 

Child elements:

Name

Min Occurs

Max Occurs

Description

column

1

unbounded

Column definition

 

Element: column

Parent: structure

Description:Column definition

 

Attributes:

Name

Usage

Default

Description

name

required

 

Column name

 

Child elements:

Name

Min Occurs

Max Occurs

Description

required

0

1

Validates that value in column is not empty.

decimal

0

1

Validates that value in column is decimal.

dateTime

0

1

Validates that value in column is datetime.

integer

0

1

Validates that value in column is integer.

byte

0

1

Validates that value in column is byte.

double

0

1

Validates that value in column is double.

float

0

1

Validates that value in column is float.

long

0

1

Validates that value in column is long.

positive

0

1

Validates that value in column is positive.

positiveOrZero

0

1

Validates that value in column is positive or zero.

negative

0

1

Validates that value in column is negative.

negativeOrZero

0

1

Validates that value in column is negativ or zero.

regexp

0

unbounded

Validates value in column against regular expression pattern.

greater

0

1

Validates that value in column is greater than other value.

greaterOrEqual

0

1

Validates that value in column is greater than or equal to other value.

less

0

1

Validates that value in column is less than other value.

lessOrEqual

0

1

Validates that value in column is less than or equal tov other value.

 

Element: required

Parent: column

Description:Validates that value in column is not empty.

 

Attributes:

Name

Usage

Default

Description

message

optional

 

Error message override.

 

Element: decimal

Parent: column

Description:Validates that value in column is decimal.

 

Attributes:

Name

Usage

Default

Description

message

optional

 

Error message override.

numberStyles

optional

 

Comma-separated list of number parsing rules.
Values:

  • AllowCurrencySymbol Indicates that the numeric string can contain a currency symbol. Valid currency symbols are determined by the NumberFormatInfo.CurrencySymbolproperty.
  • AllowDecimalPoint Indicates that the numeric string can have a decimal point. If the NumberStyles value includes the AllowCurrencySymbol flag and the parsed string includes a currency symbol, the decimal separator character is determined by the NumberFormatInfo.CurrencyDecimalSeparator property. Otherwise, the decimal separator character is determined by the NumberFormatInfo.NumberDecimalSeparator property.
  • AllowExponent Indicates that the numeric string can be in exponential notation. The AllowExponent flag allows the parsed string to contain an exponent that begins with the "E" or "e" character and that is followed by an optional positive or negative sign and an integer. In other words, it successfully parses strings in the formnnnExx, nnnE+xx, and nnnE-xx. It does not allow a decimal separator or sign in the significand or mantissa; to allow these elements in the string to be parsed, use the AllowDecimalPoint and AllowLeadingSign flags, or use a composite style that includes these individual flags.
  • AllowHexSpecifier Indicates that the numeric string represents a hexadecimal value. Valid hexadecimal values include the numeric digits 0-9 and the hexadecimal digits A-F and a-f. Strings that are parsed using this style cannot be prefixed with "0x" or "&h". A string that is parsed with the AllowHexSpecifier style will always be interpreted as a hexadecimal value. The only flags that can be combined with AllowHexSpecifier are AllowLeadingWhite and AllowTrailingWhite. TheNumberStyles enumeration includes a composite style, HexNumber, that consists of these three flags.
  • AllowLeadingSign Indicates that the numeric string can have a leading sign. Valid leading sign characters are determined by the NumberFormatInfo.PositiveSign andNumberFormatInfo.NegativeSign properties.
  • AllowLeadingWhite Indicates that leading white-space characters can be present in the parsed string. Valid white-space characters have the Unicode values U+0009, U+000A, U+000B, U+000C, U+000D, and U+0020. Note that this is a subset of the characters for which the Char.IsWhiteSpace method returns true.
  • AllowParentheses Indicates that the numeric string can have one pair of parentheses enclosing the number. The parentheses indicate that the string to be parsed represents a negative number.
  • AllowThousands Indicates that the numeric string can have group separators, such as symbols that separate hundreds from thousands. If the NumberStyles value includes the AllowCurrencySymbol flag and the string to be parsed includes a currency symbol, the valid group separator character is determined by theNumberFormatInfo.CurrencyGroupSeparator property, and the number of digits in each group is determined by theNumberFormatInfo.CurrencyGroupSizes property. Otherwise, the valid group separator character is determined by theNumberFormatInfo.NumberGroupSeparator property, and the number of digits in each group is determined by theNumberFormatInfo.NumberGroupSizes property.
  • AllowTrailingSign Indicates that the numeric string can have a trailing sign. Valid trailing sign characters are determined by the NumberFormatInfo.PositiveSign andNumberFormatInfo.NegativeSign properties.
  • AllowTrailingWhite Indicates that trailing white-space characters can be present in the parsed string. Valid white-space characters have the Unicode values U+0009, U+000A, U+000B, U+000C, U+000D, and U+0020. Note that this is a subset of the characters for which the Char.IsWhiteSpace method returns true.
  • Any Indicates that all styles except AllowHexSpecifier are used. This is a composite number style.
  • Currency Indicates that all styles except AllowExponent and AllowHexSpecifier are used. This is a composite number style.
  • Float Indicates that the AllowLeadingWhite, AllowTrailingWhite, AllowLeadingSign, AllowDecimalPoint, and AllowExponent styles are used. This is a composite number style.
  • HexNumber Indicates that the AllowLeadingWhite, AllowTrailingWhite, and AllowHexSpecifier styles are used. This is a composite number style.
  • Integer Indicates that the AllowLeadingWhite, AllowTrailingWhite, and AllowLeadingSign styles are used. This is a composite number style.
  • None Indicates that no style elements, such as leading or trailing white space, thousands separators, or a decimal separator, can be present in the parsed string. The string to be parsed must consist of integral decimal digits only.
  • Number Indicates that the AllowLeadingWhite, AllowTrailingWhite, AllowLeadingSign, AllowTrailingSign, AllowDecimalPoint, and AllowThousands styles are used. This is a composite number style.

 

Element: dateTime

Parent: column

Description:Validates that value in column is datetime.

 

Attributes:

Name

Usage

Default

Description

message

optional

 

Error message override.

dateTimeStyles

optional

 

Comma-separated list of datetime parsing rules.
Values:

  • AdjustToUniversal Date and time are returned as a Coordinated Universal Time (UTC). If the input string denotes a local time, through a time zone specifier orAssumeLocal, the date and time are converted from the local time to UTC. If the input string denotes a UTC time, through a time zone specifier orAssumeUniversal, no conversion occurs. If the input string does not denote a local or UTC time, no conversion occurs and the resulting Kind property isUnspecified.
  • AllowInnerWhite Extra white-space characters in the middle of the string must be ignored during parsing, except if they occur in the DateTimeFormatInfo format patterns.
  • AllowLeadingWhite Leading white-space characters must be ignored during parsing, except if they occur in the DateTimeFormatInfo format patterns.
  • AllowTrailingWhite Trailing white-space characters must be ignored during parsing, except if they occur in the DateTimeFormatInfo format patterns.
  • AllowWhiteSpaces Extra white-space characters anywhere in the string must be ignored during parsing, except if they occur in the DateTimeFormatInfo format patterns. This value is a combination of the AllowLeadingWhite, AllowTrailingWhite, and AllowInnerWhite values.
  • AssumeLocal If no time zone is specified in the parsed string, the string is assumed to denote a local time.
  • AssumeUniversal If no time zone is specified in the parsed string, the string is assumed to denote a UTC.
  • NoCurrentDateDefault If the parsed string contains only the time and not the date, the parsing methods assume the Gregorian date with year = 1, month = 1, and day = 1. If this value is not used, the current date is assumed.
  • None Default formatting options must be used. This value represents the default style for the DateTime.Parse, DateTime.ParseExact, and DateTime.TryParsemethods.
  • RoundtripKind The DateTimeKind field of a date is preserved when a DateTime object is converted to a string using the "o" or "r" standard format specifier, and the string is then converted back to a DateTime object.

 

Element: integer

Parent: column

Description:Validates that value in column is integer.

 

Attributes:

Name

Usage

Default

Description

message

optional

 

Error message override.

numberStyles

optional

 

Comma-separated list of number parsing rules.
Values:

  • AllowCurrencySymbol Indicates that the numeric string can contain a currency symbol. Valid currency symbols are determined by the NumberFormatInfo.CurrencySymbolproperty.
  • AllowDecimalPoint Indicates that the numeric string can have a decimal point. If the NumberStyles value includes the AllowCurrencySymbol flag and the parsed string includes a currency symbol, the decimal separator character is determined by the NumberFormatInfo.CurrencyDecimalSeparator property. Otherwise, the decimal separator character is determined by the NumberFormatInfo.NumberDecimalSeparator property.
  • AllowExponent Indicates that the numeric string can be in exponential notation. The AllowExponent flag allows the parsed string to contain an exponent that begins with the "E" or "e" character and that is followed by an optional positive or negative sign and an integer. In other words, it successfully parses strings in the formnnnExx, nnnE+xx, and nnnE-xx. It does not allow a decimal separator or sign in the significand or mantissa; to allow these elements in the string to be parsed, use the AllowDecimalPoint and AllowLeadingSign flags, or use a composite style that includes these individual flags.
  • AllowHexSpecifier Indicates that the numeric string represents a hexadecimal value. Valid hexadecimal values include the numeric digits 0-9 and the hexadecimal digits A-F and a-f. Strings that are parsed using this style cannot be prefixed with "0x" or "&h". A string that is parsed with the AllowHexSpecifier style will always be interpreted as a hexadecimal value. The only flags that can be combined with AllowHexSpecifier are AllowLeadingWhite and AllowTrailingWhite. TheNumberStyles enumeration includes a composite style, HexNumber, that consists of these three flags.
  • AllowLeadingSign Indicates that the numeric string can have a leading sign. Valid leading sign characters are determined by the NumberFormatInfo.PositiveSign andNumberFormatInfo.NegativeSign properties.
  • AllowLeadingWhite Indicates that leading white-space characters can be present in the parsed string. Valid white-space characters have the Unicode values U+0009, U+000A, U+000B, U+000C, U+000D, and U+0020. Note that this is a subset of the characters for which the Char.IsWhiteSpace method returns true.
  • AllowParentheses Indicates that the numeric string can have one pair of parentheses enclosing the number. The parentheses indicate that the string to be parsed represents a negative number.
  • AllowThousands Indicates that the numeric string can have group separators, such as symbols that separate hundreds from thousands. If the NumberStyles value includes the AllowCurrencySymbol flag and the string to be parsed includes a currency symbol, the valid group separator character is determined by theNumberFormatInfo.CurrencyGroupSeparator property, and the number of digits in each group is determined by theNumberFormatInfo.CurrencyGroupSizes property. Otherwise, the valid group separator character is determined by theNumberFormatInfo.NumberGroupSeparator property, and the number of digits in each group is determined by theNumberFormatInfo.NumberGroupSizes property.
  • AllowTrailingSign Indicates that the numeric string can have a trailing sign. Valid trailing sign characters are determined by the NumberFormatInfo.PositiveSign andNumberFormatInfo.NegativeSign properties.
  • AllowTrailingWhite Indicates that trailing white-space characters can be present in the parsed string. Valid white-space characters have the Unicode values U+0009, U+000A, U+000B, U+000C, U+000D, and U+0020. Note that this is a subset of the characters for which the Char.IsWhiteSpace method returns true.
  • Any Indicates that all styles except AllowHexSpecifier are used. This is a composite number style.
  • Currency Indicates that all styles except AllowExponent and AllowHexSpecifier are used. This is a composite number style.
  • Float Indicates that the AllowLeadingWhite, AllowTrailingWhite, AllowLeadingSign, AllowDecimalPoint, and AllowExponent styles are used. This is a composite number style.
  • HexNumber Indicates that the AllowLeadingWhite, AllowTrailingWhite, and AllowHexSpecifier styles are used. This is a composite number style.
  • Integer Indicates that the AllowLeadingWhite, AllowTrailingWhite, and AllowLeadingSign styles are used. This is a composite number style.
  • None Indicates that no style elements, such as leading or trailing white space, thousands separators, or a decimal separator, can be present in the parsed string. The string to be parsed must consist of integral decimal digits only.
  • Number Indicates that the AllowLeadingWhite, AllowTrailingWhite, AllowLeadingSign, AllowTrailingSign, AllowDecimalPoint, and AllowThousands styles are used. This is a composite number style.

 

Element: byte

Parent: column

Description:Validates that value in column is byte.

 

Attributes:

Name

Usage

Default

Description

message

optional

 

Error message override.

numberStyles

optional

 

Comma-separated list of number parsing rules.
Values:

  • AllowCurrencySymbol Indicates that the numeric string can contain a currency symbol. Valid currency symbols are determined by the NumberFormatInfo.CurrencySymbolproperty.
  • AllowDecimalPoint Indicates that the numeric string can have a decimal point. If the NumberStyles value includes the AllowCurrencySymbol flag and the parsed string includes a currency symbol, the decimal separator character is determined by the NumberFormatInfo.CurrencyDecimalSeparator property. Otherwise, the decimal separator character is determined by the NumberFormatInfo.NumberDecimalSeparator property.
  • AllowExponent Indicates that the numeric string can be in exponential notation. The AllowExponent flag allows the parsed string to contain an exponent that begins with the "E" or "e" character and that is followed by an optional positive or negative sign and an integer. In other words, it successfully parses strings in the formnnnExx, nnnE+xx, and nnnE-xx. It does not allow a decimal separator or sign in the significand or mantissa; to allow these elements in the string to be parsed, use the AllowDecimalPoint and AllowLeadingSign flags, or use a composite style that includes these individual flags.
  • AllowHexSpecifier Indicates that the numeric string represents a hexadecimal value. Valid hexadecimal values include the numeric digits 0-9 and the hexadecimal digits A-F and a-f. Strings that are parsed using this style cannot be prefixed with "0x" or "&h". A string that is parsed with the AllowHexSpecifier style will always be interpreted as a hexadecimal value. The only flags that can be combined with AllowHexSpecifier are AllowLeadingWhite and AllowTrailingWhite. TheNumberStyles enumeration includes a composite style, HexNumber, that consists of these three flags.
  • AllowLeadingSign Indicates that the numeric string can have a leading sign. Valid leading sign characters are determined by the NumberFormatInfo.PositiveSign andNumberFormatInfo.NegativeSign properties.
  • AllowLeadingWhite Indicates that leading white-space characters can be present in the parsed string. Valid white-space characters have the Unicode values U+0009, U+000A, U+000B, U+000C, U+000D, and U+0020. Note that this is a subset of the characters for which the Char.IsWhiteSpace method returns true.
  • AllowParentheses Indicates that the numeric string can have one pair of parentheses enclosing the number. The parentheses indicate that the string to be parsed represents a negative number.
  • AllowThousands Indicates that the numeric string can have group separators, such as symbols that separate hundreds from thousands. If the NumberStyles value includes the AllowCurrencySymbol flag and the string to be parsed includes a currency symbol, the valid group separator character is determined by theNumberFormatInfo.CurrencyGroupSeparator property, and the number of digits in each group is determined by theNumberFormatInfo.CurrencyGroupSizes property. Otherwise, the valid group separator character is determined by theNumberFormatInfo.NumberGroupSeparator property, and the number of digits in each group is determined by theNumberFormatInfo.NumberGroupSizes property.
  • AllowTrailingSign Indicates that the numeric string can have a trailing sign. Valid trailing sign characters are determined by the NumberFormatInfo.PositiveSign andNumberFormatInfo.NegativeSign properties.
  • AllowTrailingWhite Indicates that trailing white-space characters can be present in the parsed string. Valid white-space characters have the Unicode values U+0009, U+000A, U+000B, U+000C, U+000D, and U+0020. Note that this is a subset of the characters for which the Char.IsWhiteSpace method returns true.
  • Any Indicates that all styles except AllowHexSpecifier are used. This is a composite number style.
  • Currency Indicates that all styles except AllowExponent and AllowHexSpecifier are used. This is a composite number style.
  • Float Indicates that the AllowLeadingWhite, AllowTrailingWhite, AllowLeadingSign, AllowDecimalPoint, and AllowExponent styles are used. This is a composite number style.
  • HexNumber Indicates that the AllowLeadingWhite, AllowTrailingWhite, and AllowHexSpecifier styles are used. This is a composite number style.
  • Integer Indicates that the AllowLeadingWhite, AllowTrailingWhite, and AllowLeadingSign styles are used. This is a composite number style.
  • None Indicates that no style elements, such as leading or trailing white space, thousands separators, or a decimal separator, can be present in the parsed string. The string to be parsed must consist of integral decimal digits only.
  • Number Indicates that the AllowLeadingWhite, AllowTrailingWhite, AllowLeadingSign, AllowTrailingSign, AllowDecimalPoint, and AllowThousands styles are used. This is a composite number style.

 

Element: double

Parent: column

Description:Validates that value in column is double.

 

Attributes:

Name

Usage

Default

Description

message

optional

 

Error message override.

numberStyles

optional

 

Comma-separated list of number parsing rules.
Values:

  • AllowCurrencySymbol Indicates that the numeric string can contain a currency symbol. Valid currency symbols are determined by the NumberFormatInfo.CurrencySymbolproperty.
  • AllowDecimalPoint Indicates that the numeric string can have a decimal point. If the NumberStyles value includes the AllowCurrencySymbol flag and the parsed string includes a currency symbol, the decimal separator character is determined by the NumberFormatInfo.CurrencyDecimalSeparator property. Otherwise, the decimal separator character is determined by the NumberFormatInfo.NumberDecimalSeparator property.
  • AllowExponent Indicates that the numeric string can be in exponential notation. The AllowExponent flag allows the parsed string to contain an exponent that begins with the "E" or "e" character and that is followed by an optional positive or negative sign and an integer. In other words, it successfully parses strings in the formnnnExx, nnnE+xx, and nnnE-xx. It does not allow a decimal separator or sign in the significand or mantissa; to allow these elements in the string to be parsed, use the AllowDecimalPoint and AllowLeadingSign flags, or use a composite style that includes these individual flags.
  • AllowHexSpecifier Indicates that the numeric string represents a hexadecimal value. Valid hexadecimal values include the numeric digits 0-9 and the hexadecimal digits A-F and a-f. Strings that are parsed using this style cannot be prefixed with "0x" or "&h". A string that is parsed with the AllowHexSpecifier style will always be interpreted as a hexadecimal value. The only flags that can be combined with AllowHexSpecifier are AllowLeadingWhite and AllowTrailingWhite. TheNumberStyles enumeration includes a composite style, HexNumber, that consists of these three flags.
  • AllowLeadingSign Indicates that the numeric string can have a leading sign. Valid leading sign characters are determined by the NumberFormatInfo.PositiveSign andNumberFormatInfo.NegativeSign properties.
  • AllowLeadingWhite Indicates that leading white-space characters can be present in the parsed string. Valid white-space characters have the Unicode values U+0009, U+000A, U+000B, U+000C, U+000D, and U+0020. Note that this is a subset of the characters for which the Char.IsWhiteSpace method returns true.
  • AllowParentheses Indicates that the numeric string can have one pair of parentheses enclosing the number. The parentheses indicate that the string to be parsed represents a negative number.
  • AllowThousands Indicates that the numeric string can have group separators, such as symbols that separate hundreds from thousands. If the NumberStyles value includes the AllowCurrencySymbol flag and the string to be parsed includes a currency symbol, the valid group separator character is determined by theNumberFormatInfo.CurrencyGroupSeparator property, and the number of digits in each group is determined by theNumberFormatInfo.CurrencyGroupSizes property. Otherwise, the valid group separator character is determined by theNumberFormatInfo.NumberGroupSeparator property, and the number of digits in each group is determined by theNumberFormatInfo.NumberGroupSizes property.
  • AllowTrailingSign Indicates that the numeric string can have a trailing sign. Valid trailing sign characters are determined by the NumberFormatInfo.PositiveSign andNumberFormatInfo.NegativeSign properties.
  • AllowTrailingWhite Indicates that trailing white-space characters can be present in the parsed string. Valid white-space characters have the Unicode values U+0009, U+000A, U+000B, U+000C, U+000D, and U+0020. Note that this is a subset of the characters for which the Char.IsWhiteSpace method returns true.
  • Any Indicates that all styles except AllowHexSpecifier are used. This is a composite number style.
  • Currency Indicates that all styles except AllowExponent and AllowHexSpecifier are used. This is a composite number style.
  • Float Indicates that the AllowLeadingWhite, AllowTrailingWhite, AllowLeadingSign, AllowDecimalPoint, and AllowExponent styles are used. This is a composite number style.
  • HexNumber Indicates that the AllowLeadingWhite, AllowTrailingWhite, and AllowHexSpecifier styles are used. This is a composite number style.
  • Integer Indicates that the AllowLeadingWhite, AllowTrailingWhite, and AllowLeadingSign styles are used. This is a composite number style.
  • None Indicates that no style elements, such as leading or trailing white space, thousands separators, or a decimal separator, can be present in the parsed string. The string to be parsed must consist of integral decimal digits only.
  • Number Indicates that the AllowLeadingWhite, AllowTrailingWhite, AllowLeadingSign, AllowTrailingSign, AllowDecimalPoint, and AllowThousands styles are used. This is a composite number style.

 

Element: float

Parent: column

Description:Validates that value in column is float.

 

Attributes:

Name

Usage

Default

Description

message

optional

 

Error message override.

numberStyles

optional

 

Comma-separated list of number parsing rules.
Values:

  • AllowCurrencySymbol Indicates that the numeric string can contain a currency symbol. Valid currency symbols are determined by the NumberFormatInfo.CurrencySymbolproperty.
  • AllowDecimalPoint Indicates that the numeric string can have a decimal point. If the NumberStyles value includes the AllowCurrencySymbol flag and the parsed string includes a currency symbol, the decimal separator character is determined by the NumberFormatInfo.CurrencyDecimalSeparator property. Otherwise, the decimal separator character is determined by the NumberFormatInfo.NumberDecimalSeparator property.
  • AllowExponent Indicates that the numeric string can be in exponential notation. The AllowExponent flag allows the parsed string to contain an exponent that begins with the "E" or "e" character and that is followed by an optional positive or negative sign and an integer. In other words, it successfully parses strings in the formnnnExx, nnnE+xx, and nnnE-xx. It does not allow a decimal separator or sign in the significand or mantissa; to allow these elements in the string to be parsed, use the AllowDecimalPoint and AllowLeadingSign flags, or use a composite style that includes these individual flags.
  • AllowHexSpecifier Indicates that the numeric string represents a hexadecimal value. Valid hexadecimal values include the numeric digits 0-9 and the hexadecimal digits A-F and a-f. Strings that are parsed using this style cannot be prefixed with "0x" or "&h". A string that is parsed with the AllowHexSpecifier style will always be interpreted as a hexadecimal value. The only flags that can be combined with AllowHexSpecifier are AllowLeadingWhite and AllowTrailingWhite. TheNumberStyles enumeration includes a composite style, HexNumber, that consists of these three flags.
  • AllowLeadingSign Indicates that the numeric string can have a leading sign. Valid leading sign characters are determined by the NumberFormatInfo.PositiveSign andNumberFormatInfo.NegativeSign properties.
  • AllowLeadingWhite Indicates that leading white-space characters can be present in the parsed string. Valid white-space characters have the Unicode values U+0009, U+000A, U+000B, U+000C, U+000D, and U+0020. Note that this is a subset of the characters for which the Char.IsWhiteSpace method returns true.
  • AllowParentheses Indicates that the numeric string can have one pair of parentheses enclosing the number. The parentheses indicate that the string to be parsed represents a negative number.
  • AllowThousands Indicates that the numeric string can have group separators, such as symbols that separate hundreds from thousands. If the NumberStyles value includes the AllowCurrencySymbol flag and the string to be parsed includes a currency symbol, the valid group separator character is determined by theNumberFormatInfo.CurrencyGroupSeparator property, and the number of digits in each group is determined by theNumberFormatInfo.CurrencyGroupSizes property. Otherwise, the valid group separator character is determined by theNumberFormatInfo.NumberGroupSeparator property, and the number of digits in each group is determined by theNumberFormatInfo.NumberGroupSizes property.
  • AllowTrailingSign Indicates that the numeric string can have a trailing sign. Valid trailing sign characters are determined by the NumberFormatInfo.PositiveSign andNumberFormatInfo.NegativeSign properties.
  • AllowTrailingWhite Indicates that trailing white-space characters can be present in the parsed string. Valid white-space characters have the Unicode values U+0009, U+000A, U+000B, U+000C, U+000D, and U+0020. Note that this is a subset of the characters for which the Char.IsWhiteSpace method returns true.
  • Any Indicates that all styles except AllowHexSpecifier are used. This is a composite number style.
  • Currency Indicates that all styles except AllowExponent and AllowHexSpecifier are used. This is a composite number style.
  • Float Indicates that the AllowLeadingWhite, AllowTrailingWhite, AllowLeadingSign, AllowDecimalPoint, and AllowExponent styles are used. This is a composite number style.
  • HexNumber Indicates that the AllowLeadingWhite, AllowTrailingWhite, and AllowHexSpecifier styles are used. This is a composite number style.
  • Integer Indicates that the AllowLeadingWhite, AllowTrailingWhite, and AllowLeadingSign styles are used. This is a composite number style.
  • None Indicates that no style elements, such as leading or trailing white space, thousands separators, or a decimal separator, can be present in the parsed string. The string to be parsed must consist of integral decimal digits only.
  • Number Indicates that the AllowLeadingWhite, AllowTrailingWhite, AllowLeadingSign, AllowTrailingSign, AllowDecimalPoint, and AllowThousands styles are used. This is a composite number style.

 

Element: long

Parent: column

Description:Validates that value in column is long.

 

Attributes:

Name

Usage

Default

Description

message

optional

 

Error message override.

numberStyles

optional

 

Comma-separated list of number parsing rules.
Values:

  • AllowCurrencySymbol Indicates that the numeric string can contain a currency symbol. Valid currency symbols are determined by the NumberFormatInfo.CurrencySymbolproperty.
  • AllowDecimalPoint Indicates that the numeric string can have a decimal point. If the NumberStyles value includes the AllowCurrencySymbol flag and the parsed string includes a currency symbol, the decimal separator character is determined by the NumberFormatInfo.CurrencyDecimalSeparator property. Otherwise, the decimal separator character is determined by the NumberFormatInfo.NumberDecimalSeparator property.
  • AllowExponent Indicates that the numeric string can be in exponential notation. The AllowExponent flag allows the parsed string to contain an exponent that begins with the "E" or "e" character and that is followed by an optional positive or negative sign and an integer. In other words, it successfully parses strings in the formnnnExx, nnnE+xx, and nnnE-xx. It does not allow a decimal separator or sign in the significand or mantissa; to allow these elements in the string to be parsed, use the AllowDecimalPoint and AllowLeadingSign flags, or use a composite style that includes these individual flags.
  • AllowHexSpecifier Indicates that the numeric string represents a hexadecimal value. Valid hexadecimal values include the numeric digits 0-9 and the hexadecimal digits A-F and a-f. Strings that are parsed using this style cannot be prefixed with "0x" or "&h". A string that is parsed with the AllowHexSpecifier style will always be interpreted as a hexadecimal value. The only flags that can be combined with AllowHexSpecifier are AllowLeadingWhite and AllowTrailingWhite. TheNumberStyles enumeration includes a composite style, HexNumber, that consists of these three flags.
  • AllowLeadingSign Indicates that the numeric string can have a leading sign. Valid leading sign characters are determined by the NumberFormatInfo.PositiveSign andNumberFormatInfo.NegativeSign properties.
  • AllowLeadingWhite Indicates that leading white-space characters can be present in the parsed string. Valid white-space characters have the Unicode values U+0009, U+000A, U+000B, U+000C, U+000D, and U+0020. Note that this is a subset of the characters for which the Char.IsWhiteSpace method returns true.
  • AllowParentheses Indicates that the numeric string can have one pair of parentheses enclosing the number. The parentheses indicate that the string to be parsed represents a negative number.
  • AllowThousands Indicates that the numeric string can have group separators, such as symbols that separate hundreds from thousands. If the NumberStyles value includes the AllowCurrencySymbol flag and the string to be parsed includes a currency symbol, the valid group separator character is determined by theNumberFormatInfo.CurrencyGroupSeparator property, and the number of digits in each group is determined by theNumberFormatInfo.CurrencyGroupSizes property. Otherwise, the valid group separator character is determined by theNumberFormatInfo.NumberGroupSeparator property, and the number of digits in each group is determined by theNumberFormatInfo.NumberGroupSizes property.
  • AllowTrailingSign Indicates that the numeric string can have a trailing sign. Valid trailing sign characters are determined by the NumberFormatInfo.PositiveSign andNumberFormatInfo.NegativeSign properties.
  • AllowTrailingWhite Indicates that trailing white-space characters can be present in the parsed string. Valid white-space characters have the Unicode values U+0009, U+000A, U+000B, U+000C, U+000D, and U+0020. Note that this is a subset of the characters for which the Char.IsWhiteSpace method returns true.
  • Any Indicates that all styles except AllowHexSpecifier are used. This is a composite number style.
  • Currency Indicates that all styles except AllowExponent and AllowHexSpecifier are used. This is a composite number style.
  • Float Indicates that the AllowLeadingWhite, AllowTrailingWhite, AllowLeadingSign, AllowDecimalPoint, and AllowExponent styles are used. This is a composite number style.
  • HexNumber Indicates that the AllowLeadingWhite, AllowTrailingWhite, and AllowHexSpecifier styles are used. This is a composite number style.
  • Integer Indicates that the AllowLeadingWhite, AllowTrailingWhite, and AllowLeadingSign styles are used. This is a composite number style.
  • None Indicates that no style elements, such as leading or trailing white space, thousands separators, or a decimal separator, can be present in the parsed string. The string to be parsed must consist of integral decimal digits only.
  • Number Indicates that the AllowLeadingWhite, AllowTrailingWhite, AllowLeadingSign, AllowTrailingSign, AllowDecimalPoint, and AllowThousands styles are used. This is a composite number style.

 

Element: positive

Parent: column

Description:Validates that value in column is positive.

 

Attributes:

Name

Usage

Default

Description

message

optional

 

Error message override.

 

Element: positiveOrZero

Parent: column

Description:Validates that value in column is positive or zero.

 

Attributes:

Name

Usage

Default

Description

message

optional

 

Error message override.

 

Element: negative

Parent: column

Description:Validates that value in column is negative.

 

Attributes:

Name

Usage

Default

Description

message

optional

 

Error message override.

 

Element: negativeOrZero

Parent: column

Description:Validates that value in column is negativ or zero.

 

Attributes:

Name

Usage

Default

Description

message

optional

 

Error message override.

 

Element: regexp

Parent: column

Description:Validates value in column against regular expression pattern.

 

Attributes:

Name

Usage

Default

Description

pattern

optional

 

Regular Expression pattern.

message

optional

 

Error message override.

 

Element: greater

Parent: column

Description:Validates that value in column is greater than other value.

 

Attributes:

Name

Usage

Default

Description

compareTo

optional

 

Value to compare.

message

optional

 

Error message override.

 

Element: greaterOrEqual

Parent: column

Description:Validates that value in column is greater than or equal to other value.

 

Attributes:

Name

Usage

Default

Description

compareTo

optional

 

Value to compare.

message

optional

 

Error message override.

 

Element: less

Parent: column

Description:Validates that value in column is less than other value.

 

Attributes:

Name

Usage

Default

Description

compareTo

optional

 

Value to compare.

message

optional

 

Error message override.

 

Element: lessOrEqual

Parent: column

Description:Validates that value in column is less than or equal tov other value.

 

Attributes:

Name

Usage

Default

Description

compareTo

optional

 

Value to compare.

message

optional

 

Error message override.

 

Element: customizeMessages

Parent: csv

Description: Global error messages overrides.

 

Child elements:

Name

Min Occurs

Max Occurs

Description

required

0

1

Overrides error message

date

0

1

Overrides error message

regexp

0

1

Overrides error message

integer

0

1

Overrides error message

byte

0

1

Overrides error message

decimal

0

1

Overrides error message

double

0

1

Overrides error message

float

0

1

Overrides error message

long

0

1

Overrides error message

positive

0

1

Overrides error message

positiveOrZero

0

1

Overrides error message

negative

0

1

Overrides error message

negativeOrZero

0

1

Overrides error message

noRows

0

1

Overrides error message

wrongHeaderColumn

0

1

Overrides error message

unexpectedColumn

0

1

Overrides error message

missingColumn

0

1

Overrides error message

 

Element: required

Parent: customizeMessages

Description: Overrides error message

Default:Field is required.

 

Element: date

Parent: customizeMessages

Description: Overrides error message

Default:Date is not formatted correctly.

 

Element: regexp

Parent: customizeMessages

Description: Overrides error message

Default:Field does not match expected pattern.

 

Element: integer

Parent: customizeMessages

Description: Overrides error message

Default:Field must be valid integer.

 

Element: byte

Parent: customizeMessages

Description: Overrides error message

Default:Field must be valid byte.

 

Element: decimal

Parent: customizeMessages

Description: Overrides error message

Default:Field must be valid decimal.

 

Element: double

Parent: customizeMessages

Description: Overrides error message

Default:Field must be valid double.

 

Element: float

Parent: customizeMessages

Description: Overrides error message

Default:Field must be valid float.

 

Element: long

Parent: customizeMessages

Description: Overrides error message

Default:Field must be valid long.

 

Element: positive

Parent: customizeMessages

Description: Overrides error message

Default:Field must be positive.

 

Element: positiveOrZero

Parent: customizeMessages

Description: Overrides error message

Default:Field must be positive or zero.

 

Element: negative

Parent: customizeMessages

Description: Overrides error message

Default:Field must be negative.

 

Element: negativeOrZero

Parent: customizeMessages

Description: Overrides error message

Default:Field must be negative or zero.

 

Element: noRows

Parent: customizeMessages

Description: Overrides error message

Default:Csv file has no data rows.

 

Element: wrongHeaderColumn

Parent: customizeMessages

Description: Overrides error message

Default:Header column has wrong format. Expected {0}, got {1}.

 

Element: unexpectedColumn

Parent: customizeMessages

Description: Overrides error message

Default:Unexpected column.

 

Element: missingColumn

Parent: customizeMessages

Description: Overrides error message

Default:Column {0} is missing.

T�v�

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article