KRIM Network Sdn Bhd has a unique portfolio of supporting socio-economic programmes ranging from bridging the digital divide, poverty, community service, economic intelligence, rural economic development, human capital development and budgetary expenditure monitoring. Our core expertise is in developing web based applications using open source Linux, Apache, MySQL and PHP technologies
Someone asked me how to extract the last name in an MS Excel file. I do not use MS Excel, so I have included this following formula using OpenOffice.org [1].
| Description |
Formula | Result |
| The name |
=(C1) | Raja Iskandar Shah bin Raja Ibrahim Shah |
| The name without spaces |
=SUBSTITUTE(C1;" ";"") |
RajaIskandarShah |
| The length of the name |
=LEN(C1) |
40 |
| The length of the name without spaces |
=LEN(C2) | 34 |
| The difference between the lengths which is the the number of spaces |
=C3-C4 | 6 |
| Mark the last space in the name with a star "*" |
=SUBSTITUTE(C1;" ";"*";C5) | Raja Iskandar Shah bin Raja Ibrahim*Shah |
| The length of the name with a star "*" | =LEN(C6) | 40 |
| The position from the left for the star "*" in the name | =FIND("*";C6) | 36 |
| The difference between the length and the position is the length for the last name |
=C7-C8 | 4 |
| The last name |
=RIGHT(C6;C9) | Shah |
If you need to have it all in one cell, then here it is:
=RIGHT(C1;LEN(C1)-FIND("*";SUBSTITUTE(C1;" ";"*";LEN(C1)-LEN(SUBSTITUTE(C1;" ";"")))))
Lately, I have been using screen recording software as a tool for instructional videos. These type of software allows me to record what I do on my computer screen as a video. This is faster than writing and adding screenshot images. It is also better in showing the flow and actions to perform a particular task as an example. The disadvantage is that it can't be printed out. There are two free open source screen recording software that I use:
Google Chrome (Beta)
Google Chrome is a browser that combines a minimal design with sophisticated technology to make the web faster, safer, and easier.
One box for everything: Type in the address bar and get suggestions for both search and web pages.
Thumbnails of your top sites : Access your favorite pages instantly with lightning speed from any new tab.
Shortcuts for your apps : Get desktop shortcuts to launch your favorite web applications.
Kod Fail Majlis / Cawangan adalah bagi membezakan Majlis dan Cawangan apabila data-data digabungkan (consolidation).
Bagi PBT di Terengganu, Kod Negeri adalah 11 manakala Kod Majlis adalah seperti berikut:
Hello - Ciao
Good morning - Buongiorno
Good evening - Buona sera
Welcome - Benvenuto
Bye - Arrivederci
Thank you - Grazie
My name is Zam - Il mio nome è Zam
1. Makna perkataan:
1. هذا Haaza = Ini (untuk مذّكر muzakkar)
2. هذه Haazihi = Ini (untuk مؤنّث mu'annats)
3. عندي 'Indii = Saya ada
4. محاضرة Muhaadhoroh = Lecture/kelas
Skrin berikut hanya boleh dicapai oleh pihak pentadbir. Ini adalah bertujuan bagi mengawal dan memastikan segala maklumat yang ada di dalam pangkalan data adalah maklumat yang betul dan terkawal.
150 percent commitment to application research
