Extract delimited data within CSV fields (single and iterative)

McDon — Fri, 15 Nov 2024 23:41:42 GMT

I'm new to Talend so hopefully, this is not a total basic situation.

I have two similar scenarios so I'm listing them together.

Both originate from the same CSV file but involved different columns.

Overall, data is coming in like this:

AddrLine1|AddrLine2|City|State|Zip$...

","Field3"

The first scenario is added parsed data from the name field (the field that starts with "LastName")

The desired output for the first scenario is to add the individual columns to the output row

The second scenario is the address field (starts with "AddrLine1") which is the same situation PLUS,

this address field can repeat infinitely (noted by the '$')

The desired output here is to generate a separate list that is keyed off of "Field1" so I can create a separate dimension with this informatin.

First scenario Details

The Name column is subdivided with pipe delimiters and looks like this (as noted above):

Presently I have the Delimited file defined in the metadata with the data successfully being loaded

Goal: I would like to add the columns within the Name data column added to my output schema

I've tried Extract Delimited file but the first field is being parsed out by character, not by pipe delimeter

Second scenario Details

I've tried to create a structure, map with the intent of using tHmap but not having any luck.

Any help would be appreciated.

If these are better suited as separate asks I'm happy to create individual asks.

Re: Extract delimited data within CSV fields (single and iterative)

Anonymous — Mon, 27 Sep 2021 01:01:52 GMT

Regards

Shong