Formatting Data in a Text File from Exported PDF Comments

[augiecollins]

I am trying to format a text file, that is the result of exporting PDF comments from Adobe, into a table when I import it. The text file is formatted like this, with the comments on a certain page being located beneath the page number.

Summary of Comments on RandomDocmument.pdf
Page: 1

Author: A Subject: Text Box Date: 9/19/2019 12:50:11 PM
Long comment. Several sentences separated by periods.
Author: B Subject: Cross-Out Date: 9/19/2019 12:56:13 PM
Page: 9

Author: C Subject: Text Box Date: 9/19/2019 4:07:23 PM
More Comments. Sometimes they are dashed like so.
-
Comment 1.
-
Comment 2.
Page 16:

Author: D Subject: Text Box Date: 9/19/2019 4:07:23 PM
Another comment.



[TABLE="class: grid, width: 500, align: left"]
<tbody>[TR]
[TD]Comment No.
[/TD]
[TD]Reviewer Name
[/TD]
[TD]Type
[/TD]
[TD]Pg. #
[/TD]
[TD]Comment
[/TD]
[TD]Date
[/TD]
[/TR]
[TR]
[TD]1
[/TD]
[TD]A
[/TD]
[TD]Text Box
[/TD]
[TD]1
[/TD]
[TD]Long comment...
[/TD]
[TD]9/19/2019 12:50:11
[/TD]
[/TR]
[TR]
[TD]2
[/TD]
[TD]B
[/TD]
[TD]Cross-Out
[/TD]
[TD]1
[/TD]
[TD]Long comment by different...
[/TD]
[TD]9/19/2019 12:56:13
[/TD]
[/TR]
[TR]
[TD]3
[/TD]
[TD]C
[/TD]
[TD]Text Box
[/TD]
[TD]9
[/TD]
[TD]More comments.
-Comment 1.
-Comment 2.
[/TD]
[TD]9/19/2019 4:07:23
[/TD]
[/TR]
[TR]
[TD]4
[/TD]
[TD]D
[/TD]
[TD]Text Box
[/TD]
[TD]16
[/TD]
[TD]Another comment
[/TD]
[TD]9/19/2019 4:0723
[/TD]
[/TR]
</tbody>[/TABLE]


I want to format the data into a table like this when it is imported. Any help is appreciated!

 

[augiecollins]

Forgot to add a comment after the line with Author B, it should read "Long comment by different author on the same page."