Skip to main content

Legal

Tax & Accounting

Trade & Supply

Risk & Fraud

News & Media

Books

Developers

2025

March 2025

Configuration

Schematics
Under Enrichments, we extended Parse functionality to support delimiters.
You can only select Text type columns to parse using single or multiple delimiters to generate Output columns in the topic. These Output columns can be of any data type, mapped to any Blueprint columns and be further enriched in the Schematic.
The default selection of delimiters that are provided are comma, space, pipe, colon, semi-colon. Custom delimiters can also be included. The order in which these delimiters are provided doesn't matter. There should be at least 1 delimiter, either custom-defined or system-defined.
Once the Parse is configured for Delimited type, along with the source column that is parsed, the parse type is displayed as Delimiter and all the delimiters selected are displayed in the Enrichments grid.
On an existing Delimited Parse enrichment, only the source column, name, and data type of Output Columns can be edited.
Additionally, the position of the Output column is displayed.
If any existing Output column is deleted, the positions of the remaining Output columns will rearrange sequentially. For example, if initially there are set to be 4 Output columns, and column 3 is deleted, then the resulting Output columns will be 3 columns in positions 1, 2, and 3.
If the number of Output columns are less than the parsed columns resulted using the delimiters, the parsed data will populate in the respective output columns and the remaining data from extra parsed columns will be merged as single data in the last output column.
Example – If a source column has data “This is a test, delimiter-parse feature; Enrichments”, delimiters to parse are selected as hyphen, comma, semi-colon, and Output columns are 3.
Results that are created out of this Enrichment will be 3 new extra columns as follows:
Column 1 – This is a test.
Column 2 – delimiter
Column 3 - parse feature; Enrichments
Schematic Details grid will display all these Output columns with Enrichment Type as
Parse
.

This article applies to:

  • PRODUCT: ONESOURCE Data Hub