(?<word> \w{4,})
This is a php code that does exactly what I want my macro to do. String together characters a-z and 0-9 (not case sensitive) and match words when they are equal to or greater than 4 characters. I am not sure how to get this code into VBA's language. I need it to loop through a column, find matches, and compare those matches to each other. If they words are a 100% match in two cells I would like them to automatically combine values. If the matched words are similar in two cells, I want it to ask the user if they would like to merge these values together.
Ex:
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Project Name[/TD]
[TD]Total Hours[/TD]
[/TR]
[TR]
[TD]Mowing the lawn[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]Watering the lawn[/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD]Planting Trees[/TD]
[TD]5[/TD]
[/TR]
[TR]
[TD]Mowing the lawn[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]Planting Tree[/TD]
[TD]3[/TD]
[/TR]
</tbody>[/TABLE]
message box:
Planting Trees matched with Planting Tree, would you like to combine these Files? Yes=True No=False
If true, do
If false, do nothing
end result if user picked yes:
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Project Name[/TD]
[TD]Total Hours[/TD]
[/TR]
[TR]
[TD]Mowing the lawn[/TD]
[TD]4[/TD]
[/TR]
[TR]
[TD]Watering the lawn[/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD]Planting Trees[/TD]
[TD]8[/TD]
[/TR]
</tbody>[/TABLE]
end result if user picked no:
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Project Name[/TD]
[TD]Total Hours[/TD]
[/TR]
[TR]
[TD]Mowing the lawn[/TD]
[TD]4[/TD]
[/TR]
[TR]
[TD]Watering the lawn[/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD]Planting Trees[/TD]
[TD]5[/TD]
[/TR]
[TR]
[TD]Planting Tree[/TD]
[TD]3[/TD]
[/TR]
</tbody>[/TABLE]
</word>