How to get only table from notepad file

hi New Text Document (4).txt (226 Bytes)
Hi Everyone,

I would like to get table columns from the notepad and remove all others to write it an excel file and take it as datatable

Very simply you can:

Use the Read file activity
You can then parse out everything before “task” and after “*”

Then you can go line by line and Split the line by blank space or tabs to get each of the column data

Hope this helps

hi @AndyMenon,
Could you Explain how to parse and how to go line by line to get column data

You can check the System.IO namespace. Here is one that can help. The example here writes to file and then reads it back line by line.

Thanks @AndyMenon

1 Like

You’re welcome.
Happy Automating! :slight_smile:

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