This job uses a tFixedFlowInput to provide data. The tFixedFlowInput is run into a tExtractRegexFields which breaks the input into two strings: investment type and remainder. The tExtractRegexFields is connected to a tMap which filters the columns. The result is output to tLogRow.
|Input Data for Regex-parsing Job|
The parenthesis characters denote the column match groups. Everything in the first set of parens -- the investment type w+ -- is the first group. The remainder is the second group. Here is the outbound schema used in the tExtractRegexFields component.
|Schema Used by tExtractRegexFields|
|A tMap Filtering a Column|
|Input String Parsed to Define an Investment Type|