Extraction information from Invoices - Multiple Lines

Hi @prasath17 ,

Thank you so much for helping out. I have tried it . But i am missing something. Can you please help? Please find attached the workflow. I have provided all the regex. It seems out of all the fields we may need only the following

  1. Invoice no
  2. Supply period
  3. Customer No
  4. Contract No.
    You have helped with regex for the above 4 and also the the ones with all the fields. Along with above 4 i may need only Consumption field (which is spread across multiple lines). I tried extracting only the regex for Consumption from your regex pattern but didnt work . May be i am missing something.

Please let me know how to get the regex for Consumption only (multiple lines)

Thanks and Regards,
Srinivas

Its on group 10.

So your Regexvar(0).groups(10).value

Thanks @prasath17 . do you mean something like this?

@srinivas_pradeep - No.

I see, your other fields will fetch single value where consumption will fetch multiply values so you can’t give consumptions like this…

I guess Yoichi’s xaml has the solution to pull all the table values, you have to follow that approach.

or After writing all the single values(A to E columns) you have to create a separate loop for “Consumption” and write it column F.