Comme delimited string to excel or Datatable

[dgreen (Daniel Green)]

Hi I have a comma delimited data set in text file. Each line has different number of commas (or data points.) There is structure to the data but it is derived from the data points or codes that exist in the beginning of the string. I’d like to start by separating all the data in an Excel file or data table to allow me to filter based on these codes. After filtering I can group the data lines based on common characteristics. But how do I first get to Excel or DT?

Example:
01,2222,34,nnnnn
03,1111111111111,0000000000000,ttttt,hhhhh,jjjjjj
03,999999999999,2222222222222,jjjjj,hhhhh,iiiii
01,3333,45,hhhhh

[Yoichi]

Hi,

Can you try the following steps?

First, Read the text file as string variable using Read Text File Activity
Then Use “Generate DataTable Activity”(Wizard) as the following image. You can get datatable variable for it.

Hope this will help you.

Regards,