Extract delimited data within CSV fields (single and iterative)

[McDon]

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:

   "Field1","Field2","LastName|FirstName|MiddleName|Prefix|Suffix|Crredential","AddrLine1|AddrLine2|City|State|Zip$

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):

"LastName|FirstName|MiddleName|Prefix|Suffix|Crredential"

   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.

[Anonymous]

Hi

I think you need to add row number to each line, and then do a join to merge all columns after you extract fields using tExtractDelimitedFields from the string such as "LastName|FirstName|MiddleName|Prefix|Suffix|Crredential".

Regards

Shong