I have input data in a sharepoint list like the first table below.
CASE ID | NAME | DOB |
12345 | Jane Doe | This is the date of birth 01/02/22 isn't it |
23456 | Jane L. Doe | Look at the fox 1/02/2022 it jumps |
45678 | Jane L Doe | Help me with this data 1/2/22 |
56789 | Jane Louise Doe | 01/2/22 etc etcetera |
67890 | Doe, Jane L IV | i love football |
78901 | Jane Doe AKA Janeous Doe NKA John Doe | the beautiful sport |
From the data above, I am trying to extract the following entities into the same sharepoint list or a different list, file, etc.
CASE ID | First Name | Middle Name | Last Name | Suffix | Month | Day | Year |
12345 | Jane | Doe | 01 | 02 | 2022 | ||
23456 | Jane | L | Doe | 01 | 02 | 2022 | |
45678 | Jane | L | Doe | 01 | 02 | 2022 | |
56789 | Jane | Louise | Doe | 01 | 02 | 2022 | |
67890 | Jane | L | Doe | IV | |||
78901 | Jane | Doe |
I have been able to achieve this with Syntex where each record is on separate structured PDF files. I can't figure out how to use each sharepoint list row as a separate input.
Thanks so much for your help!
If you use Power Automate, you can use this connector to list the items of your list
Then either, use the Ai Builder prebuilt entity extraction model https://docs.microsoft.com/en-us/ai-builder/prebuilt-entity-extraction to get the name and date, finally apply some text function to split it.
Alternatively, you can build a custom entity extraction model to directly extract the name, first name, day, month and year with https://docs.microsoft.com/en-us/ai-builder/entity-extraction-overview