Find particular text with regex

Help AI Center
,
1

Hello,
fffffffffffffffffff

2

@kishore_praveen

Please provide the extracted text to provide regex or substring

And if formats are different please include more examples of input and required output

Cheers

4

@kishore_praveen

You can remove the exact data and provide dummy data inplace of it…but we need to see the structure to give you the regex

Cheers

6

this depends on invoice to invoice , we have to capture remit to details

7

@kishore_praveen

I guess the data is extracted differently…can you highlight which part is the required remit address

Cheers

9

Hi @kishore_praveen

Check this substring approach-

Assign (vendor_name) activity:
vendor_name = ocr_text.Substring(ocr_text.IndexOf(“Vendor Name:”) + “Vendor Name:”.Length).Split(Environment.NewLine.ToCharArray)(0).Trim()

Assign (address) activity:
address = ocr_text.Substring(ocr_text.IndexOf(“Address:”) + “Address:”.Length).Split(Environment.NewLine.ToCharArray)(0).Trim()

Thanks!!

10

Hi @kishore_praveen

I have attached the zip file for the reference. If you have multiple matches in the same PDF please store the output in IEnumerable < Matches>. If it’s an single value please store it an string variable.

Regex.zip (636.4 KB)

Hope this helps for your automation!!

Regards,