Hi everyone,
I use a poker game simulator called Poker Academy Pro 2.5, and their website www.Poker-Academy.com has been down for quite awhile now so I am unable to post requests in their forum. Though there is no guarantee that they would make software changes based on my request alone.
Anyway, their software compiles hand histories which can be exported as text files for analysis. I am trying to analyze my play using a third-party database import & analysis software called PokerTracker 3. Unfortunately the format of the hand history data in Poker Academy Pro does not match any format recognized by PokerTracker 3 (I also posted a request on PokerTracker 3 forums for a solution, but was turned down as well).
Therefore, what I hope to accomplish is a VBA script / macro that will automatically convert the hand format. I have attempted using various methods (including extracting words and letters from alphanumeric columns, and placing them into different columns, and also using "mid" functions, and a few other techniques) however, I have beginner level programming skills.
This might be a lengthy job (even for you expert programmers), so if you could please provide some general hints as to how I can go about accomplishing this? I can upload a sample of hand histories from both hand formats to a file host for anyone interested in tackling this problem if required.
Also, here is a screen cap of what I am trying to achieve:
http://oi56.tinypic.com/rtjnnb.jpg
Regards.
I use a poker game simulator called Poker Academy Pro 2.5, and their website www.Poker-Academy.com has been down for quite awhile now so I am unable to post requests in their forum. Though there is no guarantee that they would make software changes based on my request alone.
Anyway, their software compiles hand histories which can be exported as text files for analysis. I am trying to analyze my play using a third-party database import & analysis software called PokerTracker 3. Unfortunately the format of the hand history data in Poker Academy Pro does not match any format recognized by PokerTracker 3 (I also posted a request on PokerTracker 3 forums for a solution, but was turned down as well).
Therefore, what I hope to accomplish is a VBA script / macro that will automatically convert the hand format. I have attempted using various methods (including extracting words and letters from alphanumeric columns, and placing them into different columns, and also using "mid" functions, and a few other techniques) however, I have beginner level programming skills.
This might be a lengthy job (even for you expert programmers), so if you could please provide some general hints as to how I can go about accomplishing this? I can upload a sample of hand histories from both hand formats to a file host for anyone interested in tackling this problem if required.
Also, here is a screen cap of what I am trying to achieve:
http://oi56.tinypic.com/rtjnnb.jpg
Regards.
