Extract Name and Date of Birth from unstructured and semi-structured data in sharepoint list

[Anonymous]

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!

[CedrickB]

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