Good day,
I've done so much searching and tried different approaches but haven't figured this out and I'm hoping that someone can point me in the right direction or offer some advice.
Currently I receive a daily email that has, amongst other text, a large table that contains information that I need. But it also includes information for other site locations that I don't need and makes the table hard to read and easy to miss the relevant information. The table currently has a fixed number of columns, but the number of rows can change.
What I want to do is take that table and extract only rows where one of the columns contains specific text (our site location). I can then use that to create a new table with only that information. That will allow us to see only the information that I need and not all the other items.
Right now, I can get the table extracted from the original message as another HTML table. I can also extract it as plain text, too, but it's all one very long line. I was thinking that I could put it all into an array and manipulate it from there but I can't find any informaiton on how to do that.
Does anyone have any thoughts on this?
