Unable to parse Formatted Address field of Extraction Results

Help Activities
, ,
1

Hi all,

I need to further process address information extracted from Invoices. For that, i am referring to the formatted results. I receive an object which contains the key-values for the different Address components (Address Line 1, City etc). So far so good. However, i am struggling to get access to those individual elements.

image

I do not know how i can convert the row of the extraction result table which contains the formatted address into a list of Key Value pairs. Managing that field as a string is not useful.

Hope someone can understand my problem and has a solution.

Thanks
Andreas

2

Hi @Andreas_Kurz

Unable to understand your requirement. Can you explain it one more time.

If you want to access the individual element of a dictionary you can use the key to access it’s value. Suppose the dictionary variable name is addressDict

addressDict.Item("Country") will give you Australia

3

Hi Kumar

Thanks for swift reply.

The problem i have is that i am unable to parse the object i receive from the extraction results into a dictionary. This is the missing piece i am looking for.

My process looks as following:

  1. Digitize PDF document
  2. Extract fields based on taxonomy and ML Model
  3. Use formatted fields table of ExtractionResult only
  4. For each row of ExtractionResult Table containing the address, assign the address components to individual variables for post processing.

The result of those rows look like this when printed as lines in debug mode:
image

I need to transform the result of the row into a dictionary to then assign the different items to variables. But this step i do not know how to accomplish. How can i access the different values of the key value pairs which are stored in the rows of the ExtractionResultTable object?