Since this is an old post, the issues had have likely been resolved - but, just in case there is a late arrival reading this like, me, there is a tool available in the Process drop down from the top menu bar - called Find/Replace.
This allows conversion of most midi data to other midi data.
Very useful and powerful once mastered. It was available under older Pro Audio version of Cakewalk under a different name.
Other items you wished to do could likely be done with CAL programming. Cal scripts can still be executed from within the same Process drop down and the very bottom of the list.
CAL stood for Cakewalk Application Language. There used to be tutorials available as well as a language description. I have not looked for them recently however.
Good luck - as I am new at this DAW and hadn't really used it much since my Cakewalk Pro Audio 9 days.
Midi/Instrument tracts are not intuitively obvious particularly if you are trained in using hardware midi instruments
Cakewalk had always been more configurable and powerful than many realized because of these features.
Good luck,
Fwc.