Creating datatable from a textfile having no specific delimiters

Hi All,

My goal is to create a datatable from the given notepad file. I did some research on the forum with help of it was able to reach till the split process. However, in my scenario there is no specific delimiters for the split to be performed. And, hence it is giving me a weird output.

Have attached xaml and notepad file for reference.
CMS - Copy.xaml (11.5 KB)

Notepad file :
Sample.zip (561 Bytes)

Any kind of help would be appreciated.

Thanks in advance.

Hello,

read the notepad - outpudata name it DT.

use activity create datatable - input DT and you have it.

If problem ask :slight_smile:

Hi AalpeA,

Thanks for the prompt response. Confused on the activity which you mentioned I could not see any activity stating create datatable? Are you referring to build or generate datatable activity?

Snapshot attached

he was talking about Generate DataTable. However this one also requires a delimiter to split rows in your file into columns…

2 Likes

Thank you for edit bro.

1 Like

Delimiter is the pain area in my scenario. I don’t have a specific one :frowning: to split rows and columns

Thanks you @AalpeA , @madsps. It worked :slight_smile: Have attached xaml for others to refer.CMS.xaml (7.2 KB)

Nice good job! :slight_smile:

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.