Originally Posted by
DHalltheway
Go to your HGP under account details where they show your account activity.
Then click on view all to see all your activity in a single page.
You can then copy and paste the data into excel and sort it out.
right ...
account details -> filter by hotel stays -> view all.
Then select and copy the data, paste to a file using notepad or whatever. I noticed the fields were tab separated, with the property being the 3rd field, so on a mac in a terminal (or in a cygwin terminal window on windows):
cut -f 3 input-filename | sort | uniq > output-filename
gets you a unique list of properties from that data.
(Where input-filename and output-filename are ...)
cut -f 3 selects the 3rd tab delimited field
sort does a sort
uniq eliminates duplicate consecutive lines.
Given that it's the third field in a tab separated file, there's tons of ways to do the same thing.
-David