How to extract the data table from the notepad?

Help
1

I want to extract the data table below the hyphen and export the output to the excel:

image
image794×540 7.82 KB

My idea is to split the data and make them to be an array of string.

Be noticed that there is an empty line between the data table and hyphen.
Also, there are some spaces to separate the data.

I’ve tried hard and couldn’t figure it out, please help me.

2
  • Use Generate Datatable activity
  • Give column seperator as tab or space
  • Give row seperator as new line.
  • preview options to see the output.

image

image

Ref: vivek_Nalashaa

1 Like
3

Please find the attached flow

extract_Data_From_Notepad.zip (17.3 KB)

2 Likes
4

It works!!! Thanks for your help!

5

@KarthikByggari
@kirti.iyer

6

Please close the topic :slight_smile:

7

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