A character (for example, !) or character representation (for example, \r\n for carriage return).A character (for example, !) or character representation (for example, \r\n for carriage return).Hexadecimal value (for example, 0X09).Octal value (for example, 009).Unicode characters (for example, \uXXXX, where XXXX represents the Unicode value of the character).
To configure a delimited record parserProperty | Description |
Character | Character that separates records in a flat file document. |
--OR-- | |
Character Position | Starting from the beginning of the document and counting from zero (0), the character position at which the record delimiter for this document is located. For example, if you specify 3 as the character position, you have indicated that the record delimiter appears in the fourth character position from the beginning of the document. Note: If records use a fixed position extractor, the delimiter record parser does not include the record delimiter character in the parsed record. You will not be able to extract the record delimiter character in a fixed position field. |
Property | Description |
Character | Optional. Character that separates fields in a flat file document. |
--OR-- | |
Character position | Optional. Starting from the beginning of the document and counting from zero (0), the character position at which the field delimiter for this document is located. For example, if you specify 4 as the character position, you have indicated that the field delimiter appears in the fifth character position from the beginning of the document. |
Property | Description |
Character | Optional. Character that separates subfields in a flat file document. The default is a period “.”. |
--OR-- | |
Character position | Optional. Starting from the beginning of the document and counting from zero (0), the character position at which the subfield delimiter for this document is located. For example, if you specify 5 as the character position, you have indicated that the subfield delimiter appears in the sixth character position from the beginning of the document. |
Property | Description |
Character | Optional. Character used to enable a section of text within a field to be represented as its literal value. Any delimiter characters that appear within this section will not be treated as delimiters. For example, your field delimiter is (,) and your release character is “. When you want to use (,) within a field as text, you must prefix it with your quoted release character. When using the convertToValues service to create the strings Doe, John and Doe, Jane, the record would appear as “Doe, John”,“Doe, Jane”. When using the convertToString service to create “Doe, John”,“Doe, Jane”, the value of the record would be Doe, John and Doe, Jane. When using the convertToString service, if you have specified both the Release Character and the Quoted Release Character, the Quoted Release Character will be used. |
--OR-- | |
Character position | Optional. Starting from the beginning of the document and counting from zero (0), the character position at which the quoted release character for this document is located. For example, if you specify 5 as the character position, you have indicated that the quoted release character appears in the sixth character position from the beginning of the document. |
Property | Description |
Character | Optional. Character used to enable a delimiter to be used for its intended, original meaning. The character following the release character will not be treated as a delimiter. For example, your field delimiter is + and your release character is \. When using + within a field as text, you must prefix it with your release character. When using the convertToValues service to create the strings a+b+c and d+e+f, the record would appear as a\+b\+c+d\+e\+f. When using the convertToString service to create a\+b\+c+d\+e\+f, the value of the record would be a+b+c and d+e+f. |
--OR-- | |
Character position | Optional. Starting from the beginning of the document and counting from zero (0), the character position at which the field delimiter for this document is located.For example, if you specify 5 as the character position, you have indicated that the field delimiter appears in the sixth character position from the beginning of the document. |