I have a text file that I need to parse through. It contains the medical dictations and each new dictation is separated by <New Record>. Using split I can easily separate out the individual letters.
Within each letter (after the <New Record> tag) I have the following tags
<John R. Doe, M.D.>
Then after the last tag is the contents of the msg.
I need an efficient way to loop through each tag and pull out the info into separate fields.
The tags are positional in that the same information will be in the same position each time. If the data is missing then just the tag name will be there (like <Birth Date> above is not supplied so the tag is left there.
The tag positions are
<Date of Service>
<Type of dictation (chart note, letter)>
So ultimately I need to break the data into separate variables and the msg that follows into its own variable.
I've attached a sample text document.
I'm using vb.net 2010.