Share
ReportI 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!
Categories:
I have the same question (0)
All responses (
Answers (
542
