Hi
I pretty much have no prior knowledge to visual basic, or the macro/function in excel for that matter, so bare with me.
I'm reading through a MASSIVE chat log that has been imported to excel. The format of the log is like this: (all fictional)
[TABLE="class: grid, width: 800"]
<tbody>[TR]
[TD]Timestamp[/TD]
[TD]Direction[/TD]
[TD]Chat member ID#[/TD]
[TD]Chat member session ID[/TD]
[TD]Color code[/TD]
[TD]Message[/TD]
[/TR]
[TR]
[TD]01.01.2013[/TD]
[TD]RECV[/TD]
[TD]3[/TD]
[TD]11111111111[/TD]
[TD]X[/TD]
[TD]Look at this file:
<files alt="sending file " dad.jpg""=""> <files alt="sending file " dad.jpg""=""> <file size="843927" index="0" time="11111111">dad.jpg</file></files></files>
And www.junkfiles.com[/TD]
[/TR]
</tbody>[/TABLE]
What I want to do is parse through the message column, and find all cell with occourences of either filesharing or containing links.
When these cells are found, I want to copy the entire associated row to another spreadsheet, and keep copying further results into the same sheet on the row below.
I attempted to do some research for a search function using regular expressions but I couldn't find a good answer or guide how to do this.
I know how to write a regular expression, but not how to utilize it in this scenario.
Does anyone have a good solution for this?
-Thanks
I pretty much have no prior knowledge to visual basic, or the macro/function in excel for that matter, so bare with me.
I'm reading through a MASSIVE chat log that has been imported to excel. The format of the log is like this: (all fictional)
[TABLE="class: grid, width: 800"]
<tbody>[TR]
[TD]Timestamp[/TD]
[TD]Direction[/TD]
[TD]Chat member ID#[/TD]
[TD]Chat member session ID[/TD]
[TD]Color code[/TD]
[TD]Message[/TD]
[/TR]
[TR]
[TD]01.01.2013[/TD]
[TD]RECV[/TD]
[TD]3[/TD]
[TD]11111111111[/TD]
[TD]X[/TD]
[TD]Look at this file:
<files alt="sending file " dad.jpg""=""> <files alt="sending file " dad.jpg""=""> <file size="843927" index="0" time="11111111">dad.jpg</file></files></files>
And www.junkfiles.com[/TD]
[/TR]
</tbody>[/TABLE]
What I want to do is parse through the message column, and find all cell with occourences of either filesharing or containing links.
When these cells are found, I want to copy the entire associated row to another spreadsheet, and keep copying further results into the same sheet on the row below.
I attempted to do some research for a search function using regular expressions but I couldn't find a good answer or guide how to do this.
I know how to write a regular expression, but not how to utilize it in this scenario.
Does anyone have a good solution for this?
-Thanks