Configure the extraction, set the Groupname as it should late become the Property Names
Split the Body and filter out the relevant lines
arrTXTLines =
strBody.Split(Environment.NewLine.toCharArray).Where(Function (x) x.Trim.ToUpper.StartsWith("PERSON")).toArray
Loop over the lines
nested Loop over the extraction Config and store the extractions under the GroupName in a dictionary.
Within the switch we can configure the extraction mode (Text, or Boolean)
Driven by number of Phone Nos (or any other multiple value occurence) we create the split sets
Finaly we create the JSON and get:
Find starter help here:
ppr_JSONBox_CB.xaml (19.9 KB)
Test Data:
Input_CB.txt (372 Bytes)