A set of regular expressions to match the data with the corresponding fields. You can add multiple patterns for each field on separate lines. If more than one pattern is provided, only one needs to match (the logical OR operation is performed).
Syntax: FIELDNAME:/REGEX/ (per line)
Example:
id:/^[\d]+$/ name:/^[^\d]+/ name:/[^\d]+$/
A list of regular expressions used to replace or precondition a data block with another, applied before each attempt to match a given field. This can be used to pre-filter the data before each match attempt. You can add multiple replace patterns for each field on separate lines.
Syntax: FIELDNAME:/REGEX/ => "REPLACED STRING" (per line)
Example:
id:/^[\d]+$/ name:/^([^\d]+)/ => $1 name:/^([\d])+$/ => "another for same field"
A list of regular expressions to replace an already matched field with another text string. This can be used for post-processing of matched fields. You can add multiple replace patterns for each field on separate lines.
Syntax: FIELDNAME:/REGEX/ => "REPLACED STRING" (per line)
Example:
id:/^[\d]+$/ name:/^([^\d]+)/ => $1
If TRUE, replaces empty spaces in the matched fields with the string specified in the `empty_placeholder` option.
If TRUE, replace empty spaces in the matched fields with the string specified in the `empty_placeholder` option.
If TRUE, append debugger information to each line of output.
List of regular expressions that, if matched (before applying the "replace_filter_before"), will skip the matched data block. This is used to ignore blocks matching the given pattern. You can add multiple patterns on separate lines.
Syntax: /REGEX/ (per line)
Example:
/^XYZ+$/ /^abc123+$/ /^some unwanted data/
List of regular expressions that, if matched (after applying the "replace_filter_before"), will skip the matched data block. This is used to ignore blocks matching the given pattern. You can add multiple patterns on separate lines.
Syntax: /REGEX/ (per line)
Example:
/^XYZ+$/ /^abc123+$/ /^some unwanted data/
A list of regular expressions to replace or pre-prepare a data block with another, applied to the entire data block before attempting to match. This can be used to pre-filter the data before each match attempt. You can add multiple replace patterns on separate lines.
Syntax: /REGEX/ => "REPLACED STRING" (per line)
Example:
/^[\d]+$/ /^([^\d]+)/ => $1
A list of regular expressions to replace an already matched block with another text string. Applied to the entire block of data after a match is made, this can be used for post-processing of matched data. You can add multiple replace patterns on separate lines.
Syntax: /REGEX/ => "REPLACED STRING" (per line)
Example:
/^[\d]+$/ /^([^\d]+)/ => $1
List of fields to be matched. Enter the names of the fields into which you want to organize the parsed data, e.g., id, title, actor, description. The fields should be entered on one line, separated by commas (,).
Syntax: FIELDNAME1,FIELDNAME2,FIELDNAME3,FIELDNAME4...
Example:
id,title,actor,description
List of fields to match from the list above to be displayed in the output, e.g., id, title, actor. The fields should be entered on one line, separated by commas (,).
Syntax: FIELDNAME1,FIELDNAME2,FIELDNAME3,FIELDNAME4...
Example:
id,title,actor,description
INPUT / OUTPUT
Use the previous output dataset as the current dataset instead of the joined data. If disabled, the previous parsed output will be used as the current input, or the input if this is the first element in the chain.
Input separator for the rowsets dimension, or leave empty if the data is not rowset-based.
Input separator for the rows dimension, or leave empty if the data is not row-based.
Input separator for the columns dimension, or leave empty if the data is not column-based.
Output separator for the rowsets dimension, or leave empty if the data is not rowset-based.
Output separator for the rows dimension, or leave empty if the data is not row-based.
Output separator for the columns dimension, or leave empty if the data is not column-based.
#1 []
Apply the `trim()` function to every block.
Remove empty blocks
Replace all \r\n with \n
Apply the `strip_tags()` function to all.
INPUT / OUTPUT
Use the previous output dataset as the current dataset instead of the joined data. If disabled, the previous parsed output will be used as the current input, or the input if this is the first element in the chain.
Input separator for the rowsets dimension, or leave empty if the data is not rowset-based.
Input separator for the rows dimension, or leave empty if the data is not row-based.
Input separator for the columns dimension, or leave empty if the data is not column-based.
Output separator for the rowsets dimension, or leave empty if the data is not rowset-based.
Output separator for the rows dimension, or leave empty if the data is not row-based.
Output separator for the columns dimension, or leave empty if the data is not column-based.
#1 []
Restrict output to only blocks matching the given interval. Default is 1.
Limit blocks in output to specified ranges, or leave empty to allow all blocks. Specify range(s) separated by commas, with indexing starting from 0.
Example:
0, 3, 5-7, 15-
Restrict output to only blocks matching the given regular expressions. You can define multiple regex patterns, one per line.
Syntax: /REGEX/ (per line)
Example:
/^abc/ /^xyz/
Restrict output to only blocks NOT matching the given interval. Default is 1.
Limit blocks in output to ranges NOT specified, or leave empty to allow all blocks. Specify range(s) separated by commas, with indexing starting from 0.
Example:
0, 3, 5-7, 15-
Restrict output to only blocks NOT matching the given regular expressions. You can define multiple regex patterns, one per line.
Syntax: /REGEX/ (per line)
Example:
/^abc/ /^xyz/
INPUT / OUTPUT
Use the previous output dataset as the current dataset instead of the joined data. If disabled, the previous parsed output will be used as the current input, or the input if this is the first element in the chain.
Input separator for the rowsets dimension, or leave empty if the data is not rowset-based.
Input separator for the rows dimension, or leave empty if the data is not row-based.
Input separator for the columns dimension, or leave empty if the data is not column-based.
Output separator for the rowsets dimension, or leave empty if the data is not rowset-based.
Output separator for the rows dimension, or leave empty if the data is not row-based.
Output separator for the columns dimension, or leave empty if the data is not column-based.
data_mode
Select the dimension on which the other options will operate; this will also affect how the data is parsed in the dataset.
#1 []
Regular expressions to replace the matched string. The matching is done block by block. You can enter multiple expressions on new lines. An input separator is required to split the document into blocks.
Syntax: /REGEX/ => "REPLACED STRING" (per line)
Example:
/^abc/ => 'bca' /^xyz/ => 'zxc'
Limit replacing only to a specific interval, such as every other block. Default is 1.
Limit blocks to replace to specified ranges, or leave empty to replace all blocks. Specify range(s) separated by commas, with indexing starting from 0.
Example:
0, 3, 5-7, 15-
INPUT / OUTPUT
Use the previous output dataset as the current dataset instead of the joined data. If disabled, the previous parsed output will be used as the current input, or the input if this is the first element in the chain.
Input separator for the rowsets dimension, or leave empty if the data is not rowset-based.
Input separator for the rows dimension, or leave empty if the data is not row-based.
Input separator for the columns dimension, or leave empty if the data is not column-based.
Output separator for the rowsets dimension, or leave empty if the data is not rowset-based.
Output separator for the rows dimension, or leave empty if the data is not row-based.
Output separator for the columns dimension, or leave empty if the data is not column-based.
data_mode
Select the dimension on which the other options will operate; this will also affect how the data is parsed in the dataset.
Ultimate Chain Parser
v.1.2.13 LIVE DEMO