DSV Parser
Parses delimited text. See Supported reader-parser combinations for compatible readers.
DSV Parser properties
property | type | default value | notes |
---|---|---|---|
Block as Complete Record | Boolean | False | With JMSReader or UDPReader, if set to True, the end of a block will be considered the end of the last record in the block, even if the rowdelimiter is missing. Do not change the default value with other readers. |
Charset | String | UTF-8 | |
Column Delimiter | String | , | use |
Column Delimit Till | Integer |
| With the default value of -1, all delimiters are interpreted as columns. If a positive value is specified, that number of delimiters are interpreted as columns, and any additional delimiters are treated as if escaped. For example, if the columndelimiter value is a space, and columndelimittill is 4, this row:
would be interpreted as five columns: 2012-12-10 10:30:30:256 10.1.10.12 jsmith User Login Error, invalid username or password |
Comment Character | Character | if specified, lines beginning with this character will be skipped | |
Event Type | String | reserved | |
Header | Boolean | False | Set to True if the first row (or the row specified by headerlineno) contains field names. When DSVParser is used with FileReader, the output stream type can be created automatically from the header (see Creating the FileReader output stream type automatically). |
Header Line No | Integer |
| if the header is not the first line of the file, set this to the line number of the header row |
Ignore Empty Column | Boolean | False | if set to True, empty columns will be skipped instead of output as null values |
Ignore Multiple Record Begin | Boolean | True | |
Ignore Row Delimiter in Quote | Boolean | False | if set to True, when the rowdelimiter character appears between a pair of quoteset characters it is treated as if escaped |
Line Number | Integer |
| With the default value of -1, reads all lines. Set to |
No Column Delimiter | Boolean | False | if set to True, columndelimiter is ignored and the entire line is output as |
Quote Set | String |
| character or characters that mark the start and end of each field; you may specify different start and end characters, such as |
Record Begin | String | ||
Record End | String | ||
Row Delimiter | String |
| |
Separator | String | : | character used to separate multiple values for columndelimiter, quoteset, or rowdelimiter (for example, |
Trim Quote | Boolean | True | if set to False, the quoteset and quotecharacter characters are not removed from the output |
Trim Whitespace | Boolean | False | set to True if the data has spaces between values and delimiters (for example, |
The output type of a source using DSVParser is WAEvent.
DSV Parser example
... PARSE USING DSVParser ( header:'yes' )...