Skip to content

Releases: 4R3B3LatH34R7/MMRTokenizerXL

v1.2 new functions added

Choose a tag to compare

@4R3B3LatH34R7 4R3B3LatH34R7 released this 20 Dec 09:52
53e7330

Changelog:

  • 5 new functions added for improving QOL and ease of use of Myanmar Pyidaungsu font users.
  • Read more here.
  • a few bugs fixed

License

This work is licensed under a
Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International License.

CC BY-NC-SA 4.0


trackgit-views

Bug fixed for Daw

Bug fixed for Daw Pre-release
Pre-release

Choose a tag to compare

@4R3B3LatH34R7 4R3B3LatH34R7 released this 28 Nov 01:20
08b29cd

Release Notes

  1. In the initial release v1.0a, the algorithm won't recognize the word ဒေါ် (Daw) and it would just leave it out of the returning text string and therefore added a constant for moutcha (ါ).
  2. With this version, MMRManipulator UDF has been updated to give the user more refined control over how the output string was separated by allowing the user to define the delimiter (or not) even right down to the left or right one!
    Now, MMRManipulator has to be called like =MMRManipulator(whichCell, leftDelimiter, wordSeparator, rightDelimiter, reversedOrder) and an example call would be like: if Cell A1 contains, အောင်မြင့်မြတ် then from inside Cell B1, =MMRManipulator(A1,"""",",",CHAR(34),FALSE) and the return would be something like "အောင်","မြင့်","မြတ်" just like a Python list.
    Thus, added 2 extra parameters for leftWraper and rightWrapper.
  3. Also included in Sheet3 of the .xlsm file are:
    i. word count formula (sample)
    ii. formula to split each word into a column (sample).

The formulas are just minimal and of course, the users can edit and/or use whatever formula they desired.
Further information on using formulas can be found in their relevant sections.

First Release

First Release Pre-release
Pre-release

Choose a tag to compare

@4R3B3LatH34R7 4R3B3LatH34R7 released this 26 Nov 13:07
12c21b1

MMRTokenizerXL v.1.0a Pre-Release

Algorithm is not elegant by all means. But it just works.
Feels like not tested enough.
Therefore, if there's any bug or return errors, please let me know via discussions.

  1. xlsm can be downloaded and directly open and tested. But please make sure that macros are allowed to run.
  2. .bas can be imported into an existing VBA project via File Menu.
  3. VBA code can also be copy pasted from README.md under the explanation of each of the following 4 UDFs:
    1. MMRTokenizer
    2. MMRManipulator
    3. getMMRConsonants
    4. MMRParser