Data split

[NiranjanK1]

Good morning All,

I have data in notepad which I'm unable to split into column wise, column 9 and 10 data is adding to the column 11. How tobfix this. Please suggest. Thanks in advance.

Thanks 

NR

[NiranjanK1]

@caltang thanks for your details 

1.we are downloading this data from internal webpage

2. Always we get 3 data streams in one notepad.  Pages is no limit 

3. We Are getting this data only on notepad 

4. All Pages I have to read from notepad 

5. I want read all the Information available on notepad 

Thanks a lot 

Niranjan 

[caltang]

Hi @NiranjanK1 

I've cleansed and grouped them up to the Page level as attached.

What needs to be done next is to combine this solution with @flying008 's solution.

@flying008 do you mind exporting your workflow or continuing from where I left off?

[NiranjanK1]

@caltang @flying008 actually they are expecting 3 outputs based on different headings 

[caltang]

Who do you refer to as "they"? @NiranjanK1 

[NiranjanK1]

@caltangsorry, I mean end users. 

[caltang]

I think let's wait for @flying008 to combine their solution. I think their solution is much better than mine.

[flying008]

Hi, @NiranjanK1 

What's table as your want output? 1 or 3 ? Could you please give result as your need ?