Terminal get screen

Help Studio
1

Hi all,
I am working on a terminal, I need to get screen text via get screen text, the text looks something like this:

BB00033 - FGH2J - 09/11/2022
PAGE 00 OF 00 INVOICES LIST - 12:00:02

 DESCRIPTION CODE INVOICE TOTAL
  • INVOICE 2993 39,22
  • INVOICE 2339 30,44
  • CREDIT NOTE AA ; 032 50
  • REVERSED INVOICE 4
  • INVOICE END OF MONTH 40

At this point, I should find out whether credit note, reversed invoice and month-end invoice are present on this screen, and take the corresponding values (for credit note AA ; 032).

I would like to organise the information within a datatable, how do I do this from the string above?

Thank you in advance

2

HI @Kumar802

Use Generate datatable with space which will give youa datatable and can access

Alternately you can use a Text before and After activity to get the credit value or any other values

cheers

3

Additionally to @Anil_G answer, If you want the most accuracy. Use regex or alternatively the matches activity

4

Share the Output that you needed in excel it would be great @Kumar802

5

Column A COLUMN B COLUMN C
INVOICE 2993 39,22
INVOICE 2339 30,44
CREDIT NOTE AA ; 032 50
REVERSED INVOICE 4
INVOICE END OF MONTH 40

6

HI @Kumar802

Can you please tell which goes into which column . As of now with this data we can’t directly convert to Datatable but you can loop through he data by first splitting this using Str.Split(Environment.Newline(),StringSplitOptions.None) this will give each row.

From the data provided I see all rows have different structure so loop through each line and If invoice break it using space for credit use Credit note to extract value and so on

cheers