Pick elements from Multiple invoice with different format


#1

Hi ,

I am new to UIpath and working in a project. Can you please suggest me on below :

We have multiple invoice but with different formats . I want my bot to pick elements in Invoice (For eg :Description ,Unit, Rate, Amount etc ). And it should run on any Invoice with different formats
For example : In 1st invoice i want to pick values from Description ,Unit,Quantity,Etc and In 2nd Invoice Description of product,unit,Qty etc (Titles are different but meaning is same).

Let me know if you have any doubt in my question.


#2

Try to use REGEX option where will start by “Description…” + Regex syntax.

A lot of different templates do you have?
For me thsi works perfecto.


#3

Also in one invoice template it is Quantity and in other it is QTY… So for such cases will BOT Identify? @pllo2ptk


#4

Okay, so you have 2 types of format, am I right?
You can try “if” module -> when Description is not found, find Description of product.


#5

I cannot say only 2… it depends… each invoice format will be different @pllo2ptk


#6

MSDN Library can helps a lot here:
https://msdn.microsoft.com/en-us/library/w2sa9yss(v=vs.110).aspx


#7

So, U mean to say only if we know the different formats it might contain we can extract ? right? @pllo2ptk


#8

Well, UiPath robot is not self-learning robot (at this moment). So you must give him all information to get data.

Sometimes you can get data by knowing the positions of text, sometimes by part of text (like above) with Regex option.


#9

Yes Exactly… i wanted to know if there any way to do so… I wanted to check the feasibility before getting into project. Thanks a lot . :slight_smile: @pllo2ptk


#10

You are welcome


#11

try to use Regular expression
there is lot of option available in the uipath
.Replace
.Split
.match
.IsMatch
etc.
now i’m giving a example using regex.

system.text.regularexpressions.regex.replace(inputstring,ouputstring)

Regards
Bagish ojha


#12

@bagishojha Thank you … I will try


#13

Hi @Sailaja_Chikkam,

The invoices are in the pdf file or in Excel file ?

Regards
Balamurugan.S


#14

PDF file @balupad14


#15

you have 2 options

1. Read the text from the pdf and do the manipulation on it to get the data.

2.Search the text in the pdf (I am working on it, I will let you once finished.)

Regards
Balamurugan.S


#16

Yes… here searching the text in PDF (text can be Product/DESC/Description/Description of Product/Description of work)… Can be anything because each invoice is different from other but the meaning is same for everything. @balupad14


#17

yes @Sailaja_Chikkam. You are right . we need to create a configuration object (may be in xml or excel) . based on that we need to search the text in the pdf. One thing is an important. The pdf quality should be in good even if it is a scanned one. Because the bad scanned quality will return the junk characters.

Regards
Balamurugan.S


#18

How to create configuration object in Excel? @balupad14


#19

Hi @Sailaja_Chikkam

Like this

image

How do you search the text in the pdf?

Regards
Balamurugan.S


#20

Find Text Exists ? Right? @balupad14