I have a text file in which there is a set of structured data each with some parameters . I have to selectively take data from text file based on the 5 parameters values and then send it to word.
If those 5 parameters exist for the dataset and their values are the same ,then we have to append each dataset one after the other and send it to word. If they dont exist then we cannot append that dataset to the previous one
We are considering the parameters and its values for the 1st Datset as the criteria.
For this I tried using the split option in notepad , but didn’t get ideas post that. Thereafter I thought of shifting it to an excel file to get the data in row format and thought of building a dataTable with 2 columns ,one column of parameter and other column of Dataset but I am not getting further ideas on how to selectively find the parameter values from each row .
I want to know how can I make a loop for finding those 5 parameters with their values and stopping thereafter and appending the corresponding dataset to that and then in the 2nd iteration of the loop going down ,again finding those 5 parameters and matching their values with the 1st one and if it matches then append their dataset to the 1st dataset and going down to the next page and doing the same thing and appending the 3rd dataset to the above one and henceforth for the remaining datasets.
I have uploaded the a sample file for reference . In actual file the same parameters and its corresponding Dataset repeats with different values for around 10-15 times or may be N no. of times.