topic Re: parsing data with comma separated in Data Quality

parsing data with comma separated

Anonymous — Sat, 16 Nov 2024 07:16:53 GMT

i have input data like this on sql server

name	Phone
Janet	1-543-222-532, 1-571-721-421, 754-8812, 754-5432
Mark	202-555-0179, 202-555-0174

then i need to parse phone number value by comma separated, like this

name	Phone1	Phone2	Phone3	Phone4
Janet	1-543-222-532	1-571-721-421	754-8812	754-5432
Mark	202-555-0179	202-555-0174	null	null

Please let me know if anyone has resolved this on .

Thanks, Jackson

Re: parsing data with comma separated

Anonymous — Fri, 16 Nov 2018 07:55:38 GMT

Hi Jackson,

You can achieve the solution using tExtractDelimitedFields component. Please refer the details below for your dataset.

I have read the data from file but in your case, the source will be database.

The details of the component can be referred from below screenshot.

Output can be referred as shown below.

Hope I have answered your query. Could you please mark the topic as resolved? Kudos are also welcome 🙂

Warm Regards,

Nikhil Thampi

Re: parsing data with comma separated

Anonymous — Fri, 16 Nov 2018 09:34:16 GMT

@nthampi wrote:

Hi Jackson,

You can achieve the solution using tExtractDelimitedFields component. Please refer the details below for your dataset.

I have read the data from file but in your case, the source will be database.

The details of the component can be referred from below screenshot.

Output can be referred as shown below.

Hope I have answered your query. Could you please mark the topic as resolved? Kudos are also welcome 🙂

Warm Regards,

Nikhil Thampi

SOLVED

Thanks sir