Calculation of values after extraction

[Somanath_Somu]

Hi, i have a scenario from pdf automation…where i have to extract the values…i.e.,(visits per week) larger number… For example i have to extract 3 in the attached image.
And also i have to extract number of weeks… For example 8 in the attached image.
After extracting both the values i have to multiply it… For example 3*8 = 24 visits… I need this total visits value from this scenario…
Please suggest the approach…

[sasi_poosarla (sasi p)]

if possible can you share that pdf?
so that will try

[Somanath_Somu]

I am unable to share…

[sasi_poosarla (sasi p)]

okey then after read pdf activity… use regex for that output

[Somanath_Somu]

PdfOutput_08-09-2023 16-26-53.txt (9.6 KB)
Can u please explain in more detail… Attached output of pdf fyr…

[lrtetala (Lakshman Reddy)]

Hi @Somanath_Somu

Please find the below xaml for your reference

BlankProcess7.zip (148.0 KB)

I hope it helps!!

[Shiva_Nikhil]

Hi @Somanath_Somu

System.Text.RegularExpressions.Regex.Matches(inputstring,“[^a-zA-Z-\s]”)
Gives you the output as collection

You can call the required values based on index

Hope this helps

[Somanath_Somu]

Hi @lrtetala ,

If u don’t mind, can u open that both regular expressions & send a screen shot… Actually due to some issue am unable to download the package

[lrtetala (Lakshman Reddy)]

@Somanath_Somu

(?<=Plan of Treatment: \d+\-)\d+

(?<=for\s)\d+(?=\sweeks)

[Somanath_Somu]

Thank you @lrtetala & @Shiva_Nikhil

[Shiva_Nikhil]

Thanks and Welcome @Somanath_Somu

Happy automation