I’m making an automated “Send if match”-function for Invoices. I use “get OCR text” to read the company name on the invoice and if the receiver match a company named in my Excel list i want to send the Excel Version of the name back to Uipath.
- Get OCR Text finds “Company AS c/o HelpProgram 1830 Norway)” on an invoice (this is already OK)
- In my Excel list i have “Company AS” listed.
- Since I have the company/parts of the get text listed in Excel, Uipath will use the excel-version-match and get rid of everything else Company AS (keep for the next step of the automation) c/o HelpProgram 1830 Norway (delete)
*Note: to keep everything before * AS won’t work - wrong text can also appear in front of the company name due to non-standard layout invoices.
I’m really stuck at the last step, can anyone help me or point me in the right direction?
Thank you so much