PART II - HOW TO CREATE YOUR OWN NUMBER TO WORD CONVERTER IN MS EXCEL, MS VISUAL BASIC, MS ACCESS OR PHP?

PART II (I  JUST DON’T KNOW UNTIL WHAT PART I’LL BE ABLE TO FINISH THE PART ON “THE LANGUAGE STRUCTURE” )

After I left the blog on Part I, of this stuff, I logged in again a couple of times to see if I can understand when I have explained earlier to make sure that the reader without the help of the hind sight, can understand it.  I did not change the whole context but just edit some typos on text written earlier.

However, by hook or by crook we need to understand things that happened in our every life. We read it (the numbers) , we say it, dealt with it in simple and extreme manner taking for granted how we have understand it in the first place.

At birth, a small kid start learning the mother tongue (language spoken by the mother to the kid or the language in which you dream or in your nightmare) and that include the learning how to count and how it is spoken and written (later stage when the kid go to school).

Amazed as to how kid can learn the language, without (maybe) asking about the structure of the language when he saw how the “number” written and read in a different manner. But the brain assimilates and consume, as though no question asked (Intelligent one asked and keep it to themselves) though.

Now, THE MAIN PROBLEM ON NUMBERS that we are going to solve here is that,  What is written (digit of number) is NOT READ as how the digit numbers are written, that is the structure of the language (in this case English) did not read number as how it is written or as arranged in the written form.

ROUND NUMBER OR WHOLE NUMBER OR SIMPLY CALL IT INTEGER (I will not go beyond that. There are many types of number in its scientific form or expression depending on where it is used  (say in scientific, databases) eg Floating number, double, byte, integer, long, date, currency, Boolean (Yes/No – True/False, Good/Bad), string (not the string that you buy from the sowing machine shop) can be number in the text form until it is converted into values.

So, What is a round or whole or an Integer (number) ?

It is, as mentioned above, a single digit whole number,  it is not a fraction number or any part of “whole number”, It is not,   say ½, 1/3 or 1.000123 or 0.1111.

In this Part we are only dealing with a whole number and we will touch on the fractioned part later as it also need to be understood and required in reading number when it becomes CURRENCY either in Ringgit or Dollar. Eg  123.25  (Read as One hundred twenty three and sen Twenty five “only”. See that the point (decimal) is not read but instead it is read as “and”. The fraction part is with the “.” (DECIMAL, DOT) is not read as  decimal or dot but as “and”.

If the decimal or dot appeared after a whole number (I am using the “if” not as how a computer language liked it, but I am sure It can be understood by human) but can be interpreted differently in an array of codes ..Haaaa.. I just could not best explain how it is going to work in your mind – The brain is a marvelous organ. It is read as POINT then followed by the number read as IT IS WRITTEN. Strange how human put it, BUT when the number type is CURRENCY or RINGGIT it it read as how an ordinary number is read in its whole number form.   Can u get that !!!.

For the purpose of this Conversion, we will take it as, where whole number is read as in CURRENCY form.  Ie The Part before the Dot/Point as well as after the DOT/POINT  as expressed in 123.25 above.  Not read as One hundred twenty three POINT two five BUT Read as One hundred twenty three AND twenty five as in Currency. It can be done comprehensively but for the purpose of our CONVERSION PROGRAM we will use how FLOATING NUMBER rounded to two decimal places as we will likely to use this conversion W2NE as in monetary form.

Frankly, I never explain all these the way I explain it in the above  but I did question my self all things in these subject in question. I am in a difficulty, whether the explanation could really be understood because it works quite differently in our mind and imagination,

 J

To help me with the explanation I have produced the table. Reading the table you would say..owh I got it long before it is this is explained to you. We definitely knew about this subject even just as we learn to read and write in year one. That makes it easy as well as hard for me to explain it. .Ha3.

Examine the table and the comment (Caption) is to assist you as to what I try to explain to you before we go to and through the programming part…ok ?. I thought the table is self explanatory. The table on deal with single digit up to 19 (nine teen) only and we will continue from number 20 in the next part.

You may be too eager to go to the programming part but this part cannot be ignored. You have to understand it fully because programming part has its own complexity to bear in addition to this subject (Language structure of number in English language). When you understand how the structure,  in the English language then we will go very fast through the Malay and Miriek language structure. The three languages do not have the same structure and we just cannot cut and paste the code for the use in the Malay and Miriek Language.  I have included Miriek languase.. you may ask why, The reason is because it has a very unique (unique not as in programming term) structure that does not happen or exist in the English or Malay Language. We'll come to that subject later.

This is not in anyway rocket science...it may be just trash...that some people may find comfortable with.

To be continued......

I hope you can read what is written on this table. It looks so tiny. You may as well download it.  If its still blurry just put a comment in the blog comment so that I can improve the quality so that it can be read.

I get a few questions from my messenger's inbox and will answer that before I proceed to part III.