How to get specific texts from the file

Learn Academy Feedback
, ,
1

Hi everyone,

I have the information like this:
Item Description Quantity Price Per Total
Professional Services 1 213776 EUR 213776 EUR

And I want to get only texts of “Professional Services”. Which formula should I use?

Thanks so much.

2

Hi @domin

You can split the string and get the index of 0 and 1 to get the value that you want :smiley:

cheers :smiley:

Happy learning :smiley:

1 Like
3

Please see this article for your reference .

@domin

cheers :smiley:

Happy learning :smiley:

2 Likes
4

Hi @domin,

Can you tell me that informations are in table or string?

5

Hi, the information in the PDF file is the table, and when I use the Read PDF with OCR, it turn to 2 lines.
So when I try to use substring and indexof for “Per Total” before split, it turns the results = “0”

6

Thanks so much Pattycarte,
I will try to extract some formula :slight_smile:

7

Your most welcome @domin

cheers :smiley:

Happylearning :smiley:

1 Like