MoI discussion forum
MoI discussion forum

Full Version: How to export shortcuts into a nice textformat?

Show messages: All  1-4  5

From: Michael Gibson
20 Jan 2020   [#5] In reply to [#1]
Hi Lordfox, you can use Excel for that.

First go to moi.ini and select the entire [Shortcut Keys] section and use Ctrl+C.

Inside Excel select cell A1 and use Ctrl+V to paste in the text.

Now stretch out column A (so it is easier to go to the B column), then go to cell B1 and put in this: =LEFT(A1,FIND("=",A1)-1)

That will extract out the text before the first = sign. Select the cells from B1 downwards to your last row and use Fill > Down. This has now extracted the "Key" part of the shortcut key into its own column.

Now in cell C1 put in this: =RIGHT(A1,LEN(A1)-LEN(B1)-1)

That extracts the "Command" part of the text. Select the cells from C1 downloads to your last row and use Fill > Down.

Now hide Column A and you should have 2 separated columns that you can print out.

- Michael

Show messages: All  1-4  5