parsing data with comma separated

[Anonymous]

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

[Anonymous · Accepted solution]

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

[Anonymous]

---

@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