How to get only table from notepad file

Help
,
1

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

2

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

3

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

4

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.

5

Thanks @AndyMenon

1 Like
6

You’re welcome.
Happy Automating! :slight_smile:

7

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