Select Page

Greetings Humans

Welcome to my personal webpage where I try to document what I found useful during my day-to-day work in Universiti Teknologi Malaysia and what I randomly come across in the Internet. Feel free to leave any comment and get in touch with me. Hope you found something useful among my random rambling posts.

Enjoy!

Royal Rambles

Optical Character Recognition (OCR)

One of the frustrating thing when we are handling PDF document is that sometime we would not be able to select, copy and paste the content of that pdf. This is because the content of the pdf was not properly OCR-ed (Optical Character Recognition). Whenever we are...

read more
Trimming whitespaces in Excel

Trimming whitespaces in Excel

More often than not, whenever we extract data from our databases (MySQL, ORACLE, etc.), perhaps due to some missing pre or post processing, we are dealing with extra spacing in our data. My own way of double checking this is to resize the specific column to as wide as...

read more
Creating video montage with minimal technical know-how

Creating video montage with minimal technical know-how

I was tasked to create an opening montage for an event back in May 2018 and I have no idea where to begin, except from trying to coordinate with all other video experts around campus. Unfortunately, most of the people I contacted were occupied with some other task at...

read more

Google Form as metadata manager

Often we encountered problem with documentations and reports done by someone else and that someone else has been transferred to another unit or retired. Although we have some kind of storage system to store all those information and it is just a matter of passing that...

read more
Improved Scopus author profile wizard

Improved Scopus author profile wizard

Apologies to all other fans out there but I personally think Gandalf is the greatest (fictional) wizard of all time. Pun aside, I stumbled upon an improved Scopus Author Profile tool few days back when I was assisting Dr Mastura with her Scopus profile. Apart from...

read more

New information export support from Scopus

A quick visit to Scopus today and I found out that new information can now be exported; particularly the Scopus IDs (or Author IDs) of the list on publications! This feature is definitely useful for anyone, myself included, in dealing with unique identifier for...

read more
Royalty free photos for your next project

Royalty free photos for your next project

Looking for royalty-free (free-to-use) photos for your slides, presentation or webpage? Try PEXELS. It did not get any better than this as you can simply search, browse and download any photos you want to use. Just make sure you pay attention to the Pexel License on...

read more