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 😀
@buddy4eva5569 ай бұрын
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?
@TomsTechAcademy9 ай бұрын
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
@buddy4eva5569 ай бұрын
@@TomsTechAcademy I see, thank you.
@muhammadwahyudi1382 Жыл бұрын
thank you
@TomsTechAcademy Жыл бұрын
Thank you for your comment, glad my video was useful for you 😀
@25_kengheng383 ай бұрын
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_kengheng383 ай бұрын
I have also added increment row but it still isn't working
@TomsTechAcademy3 ай бұрын
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 ❤
@midoeez13916 ай бұрын
after i'm done with creating the project can i add more invoices to the input folder ? will it work the same ?
@TomsTechAcademy6 ай бұрын
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!
@midoeez13916 ай бұрын
thank u so much @@TomsTechAcademy
@Gannilifts5 ай бұрын
im not getting the output as pdf.txt it is not showing any txt file in my file location
@TomsTechAcademy5 ай бұрын
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.
@Gannilifts5 ай бұрын
i got it thank you @@TomsTechAcademy
@vincejairam96639 ай бұрын
Very hard to see, the video is not sharp
@TomsTechAcademy9 ай бұрын
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?