Invoice Extraction: Extract PDF Invoice to Excel with UiPath

No video

Invoice Extraction: Extract PDF Invoice to Excel with UiPath

Рет қаралды 10,506

Thomas Janssen | Tom's Tech Academy

Күн бұрын

Пікірлер: 26

@roshansrkokil7649 5 ай бұрын

Very good explanation

@TomsTechAcademy 5 ай бұрын

Thank you for your comment, glad my video was helpful for you :)

@docoRPA Жыл бұрын

For the given invoice example in the video, the TextToLeft/Right works fine because the text part always appears BEFORE the value. I have an invoice when converted to text has the value AFTER the text e.g. "some thing is here 5,000 Total etc etc" rather than "some thing is here Total 5,000 etc etc". I can get the left part of Total to give me " some thing is here 5,000 " so in this case I would need to split the string by " " and get the last element of the string array, rather than the first which TextToLeft/Right gives you. i.e. the result would be "thing is here 5000 etc etc" if i tried to use TextToLeft/Right returning the right side. Of course I can just write my own split to return the last element, (or reverse the order of the lines in the original text and apply TextToLeft/Right) but it would have been nice to have a Boolean property in TextToLeft/Right to allow splitting by the last appearance of the separator , instead of always splitting by the first appearance of the separator. I'm thinking of the business users of UiPath Studio /StudioX

@PraveenSingh-cl2or Ай бұрын

I have only a single space between each item in the column. "10 Nutrimatic Drinks Dispenser 4,200.00 42,000.00" These are the items in the column. I am unable to put "Nutrimatic Drinks Dispenser" in a single column as you see this is the name of the item. You have used Pipe symbol to separate it because you have single and double space bot and you are able to split it. Please tell what can be done if there is only single space.

@TomsTechAcademy Ай бұрын

Hi Praveen, for this more complex scenario you probably want to work with RegEx. My friend Jeppe has a good video about using RegEx for form extraction: kzfaq.info/get/bejne/sMlxfqWhkteqgGw.html

@docoRPA Жыл бұрын

Use this method to extract straight forward data and combine with Regex for any data not conforming to this method

@TomsTechAcademy Жыл бұрын

Exactly, I’m planning another video on the more “advanced” RegEx extraction soon 😀

@buddy4eva556 9 ай бұрын

Hello, I can't seem to join some words of the same column together. Like how you did for the "Decorative clay pottery", can you help me? I have other rows which do not require this change so how should I make the necessary changes without amending my other data?

@TomsTechAcademy 9 ай бұрын

This method only works if the distance between columns is different than the distance between words (1 space). In other scenarios I would suggest to use RegEx extraction

@buddy4eva556 9 ай бұрын

@@TomsTechAcademy I see, thank you.

@muhammadwahyudi1382 Жыл бұрын

thank you

@TomsTechAcademy Жыл бұрын

Thank you for your comment, glad my video was useful for you 😀

@25_kengheng38 3 ай бұрын

Hi, I want to use 3 invoices but the thing is that the values of each invoice will overwrite each other. I added a read range workbook as well as an assign and now it says that it cannot process as its being used by another process. Can you help me ? Thanks a lot

@25_kengheng38 3 ай бұрын

I have also added increment row but it still isn't working

@TomsTechAcademy 3 ай бұрын

Hi, please post this question on my Discord channel - this way I can help you better: discord.gg/WHJWFNDXXX

@overlord6502 Жыл бұрын

is just only can extract English language? I use Arabic language

@TomsTechAcademy Жыл бұрын

You should be able to extract any language as long as the format is similar 😀 just use other text in the “text to left / right” activity

@overlord6502 Жыл бұрын

@@TomsTechAcademyGreat you r great man ❤

@midoeez1391 6 ай бұрын

after i'm done with creating the project can i add more invoices to the input folder ? will it work the same ?

@TomsTechAcademy 6 ай бұрын

You can add more invoices, though the format needs to be the same. I would definitely encourage to create (or download) some invoice templates and experiment with reading them :) that's how you learn UiPath!

@midoeez1391 6 ай бұрын

thank u so much @@TomsTechAcademy

@Gannilifts 5 ай бұрын

im not getting the output as pdf.txt it is not showing any txt file in my file location

@TomsTechAcademy 5 ай бұрын

Can you try to navigate to your project files (instead of the actions sheet, navigate to "project" on the left side of your screen). Now right click on "main.xaml" and click "open file location". Can you check whether pdf.txt is stored in this directory? Otherwise, I would recommend to check whether the scope of your variables is configured correctly.

@Gannilifts 5 ай бұрын

i got it thank you @@TomsTechAcademy

@vincejairam9663 9 ай бұрын

Very hard to see, the video is not sharp

@TomsTechAcademy 9 ай бұрын

Can you please click on the gear icon at the right bottom of the YT video and change the resolution to 1080p? The video has been recorded in 1920*1080 resolution so it should be sharp?