How to use multiple Splits in a Text

RPA Discussions
1

I extracted text data from word file, on every page there is Title “Sales Report” and i am spliting it on “Sales Report” text. It is taking first page only because “Sales Report” text is repeating on every page. Any one can suggest to me the solution?

1 Like
2

Hi @sandeep.ruhela,

Welcome to the community!

After extracting from word file, do you have all the text? I mean, not only the first page.

I want to understand if your problem is when you split it or when you extract it.

Thanks!

3

Hello again @sandeep.ruhela,

I created a sample using a text file, just like this:

Sales Report

text1
text2
text3

Sales Report

text1
text2
text3
text4
text5

Sales Report

text1
text2
text3
text4
text5
text6
text7
text8
text9
text10

I was able to get the following result:

image
image361×543 9.33 KB

Through the following code:

image
image616×532 22.9 KB

If this solves your problem, kindly mark this post as solution to close this topic.

If you need extra help or/and if you have any question, please let me know. :slight_smile:

Thanks!

4

Thanks Gustavo :slight_smile:
But there can be N numbers of “Sales Report” text, in that case what to do? I need whole consolidated date in a variable.

1 Like
5

Hi @sandeep.ruhela,

You could do something like this:

image

6

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