Data Validation

The file parser activity performs data validation. You can check the following table for the valid format and range of each data type. When a field contains data that does not conform to the format or data whose value is beyond the valid range, the entire record is discarded and an error message is logged.

Data Type Format Valid Range
i1 [whitespace][{+|-}][digits] <-128,127>
i2 [whitespace][{+|-}][digits] <-32768,32767>
i4 [whitespace][{+|-}][digits] <-2147483648,2147483647>
i8 [whitespace][{+|-}][digits] <-9223372036854775808,92233720368547758 07>
ui1 [whitespace][+][digits] <0,127>
ui2 [whitespace][+][digits] <0,32767>
ui4 [whitespace][+][digits] <0,2147483647>
ui8 [whitespace][+][digits] <0,9223372036854775807>
r4 [whitespace][sign][digits][. digits][{e|E}[sign]digits] <1.175494351e-38,3.402823466e+38>
r8 [whitespace][sign][digits][. digits][{e|E}[sign]digits] <2.2250738585072014e-308,1.7976931348623158e+308>
DateTime A list of predefined patterns and an option to specify user-defined patterns are available. If the user-defined pattern option is enabled, you can use User-Defined Pattern to specify the pattern. For syntax and semantics for specifying the pattern, see Synatx for Specifying User-defined Date and Time Patterns.