EmEditor - lightweight text editor able to open large file and also manipulate CSV

Recently, I was looking for a text editor that is capable to open and edit an SQL dump as large as 2.7 GB, and I only found EmEditor to be the workable one. Most of the well-known text editors for Windows failed to open the file. Several managed to open, but became extremely slow and easy to crash during navigation or editing.

EmEditor by Emurasoft has been around since 1997. Its user interface is still Windows 95 alike, and not that impressive at all. It seems to be powerful, with quite a lot of functions, but looking for the function will probably need some times searching in its menu items. It has most of the basic function of a modern text editor, including syntax highlighting for programming languages and scripts.

Due to its old fashion user interface, you probably won't use EmEditor for normal text editing or program coding. However, EmEditor has 2 unique features that really make a difference from other editors. These 2 superb features are:

• ability to open and edit large text file, as big as 248 GB or 2.1 billion lines!
• ability to manipulate CSV file with nice tabulation of the data into columns.

If you need a lightweight editor to open text file with millions of line, you are very likely end up with EmEditor. EmEditor is able to open such large file without consuming much memory or taking up much CPU resources.

Example of those large text files including but not limited to:

• SQL dump with data
• Log file
• Large dataset in CSV or XML

EmEditor is pretty fast in loading the large text file. If the file is really large and over a gigabit, it still needs some times to fully load the file, but not that long.

Sequential moving in between text is seamless and fast, but jumping will take a longer time. Editing character by character is also fast, but text replacement with highlighting and cut will also take a longer time.

 

EmEditor has function to split a file into multiple smaller files, and also the reverse function to combine several files into one.

This is handy in the situation whereby you need to search for a portion of the large file, and export it out for further manipulation using other tools. Another situation is to split a large chunk of SQL dump into smaller files, so that the SQL server can import by handling smaller files.

EmEditor has powerful CSV manipulation functions similar to spreadsheet such as MS Excel or LibreOffice Calc. Compared with those spreadsheet programs, EmEditor is pretty lightweight and faster to load up.

It can tabulate the CSV data into columns, insert/delete a column, perform sorting, perform filtering, convert the CSV separator, etc.

Because of these 2 unique functions, I find EmEditor a handy tools for IT person, particularly for dealing with large text files involving dataset or log file.

Cellular frequency bands allocated to Malaysia mobile network operators

The telecommunication spectrum assignment in Malaysia is handled by Malaysian Communications and Multimedia Commission (MCMC).

Mobile network operators (MNOs) need to pay multi-million ringgit to MCMC in order to get the spectrum assignment in specific frequency band, so that they can provide cellular mobile service to customers with their assigned frequency bands.

The customers' device need to be able to communicate on the same band with the cellular transmitter at the nearby telco tower of the mobile service provider in order to establish a connection for voice and data transmission.

SIRIM is the certification body who will test and certify the mobile devices sold in the local market are complying to the spectrum used in Malaysia.

Current allocated frequency bands to MNOs in Malaysia are as below. Note that the mobile operator might not make use of all of their allocated frequency bands. In fact, most of them are not using the 900MHz band for 2G GSM.

Lower frequency means longer wavelength. This will have better in-house penetration and also able to reach a longer distance, but the bandwidth is lower and connection speed is slower.

Higher frequency means shorter wavelength. This can carry more bandwidth and also provide faster connection speed, at the trade-off of poorer in-house penetration and shorter coverage distance.

LTE frequency bands are numbered according to either the FDD specification or the TDD specification. For example, FDD Band 5 used by Unifi Mobile has a low frequency of 850MHz, therefore the LTE connection speed in this band is generally slower than those in FDD Band 3 (1800MHz).

Android mobile device users can install an app called LTE Discovery by Simply Advanced to have realtime information about which LTE band the device is connected to, as well as the signal strength, cellular tower position, and many other related information.

Tourists bringing mobile phone and/or tablet to Malaysia can check the table above with their own device specification on 2G/3G/4G to ensure that their device can function well in Malaysia, either using roaming or a SIM card purchased in Malaysia from one of the MNOs or MVNOs.

Hotlink Postpaid Flex plan by Maxis

Hotlink Postpaid Flex is a postpaid (not prepaid) mobile plan operated by Maxis.

At a monthly fixed cost of as low as RM30, you can get unlimited voice calls, unlimited SMS and 1GB of high speed data usage. After the data quota used up, you can still use the Internet at capped speed for no additional charge.

On top of the base plan, you can buy monthly auto-renewed or single month one time bundle(s), which provides you categorized apps-based unlimited high-speed Internet access:

• Unlimited Social (RM10) - Facebook, Instagram, Snapchat, Pinterest & Twitter.
• Unlimited Music (RM10) - Spotify, Joox, Saavn, KK Box & Smule.
• Unlimited Chat (RM5) - WeChat, WhatsApp, Line, IMO, QQ & IM.

These apps-based unlimited Internet access bundles are sharable via mobile hotspot tethering, although the tether speed will be capped at 5Mbps.

Additional high speed Internet quota can also be purchased as Internet pass with the current rate as follow:

• 2GB for RM10 (valid until next billing cycle)
• 1GB for RM3 (valid for 1 day)

However, only the base Internet plan can be tethered, and these additional Internet pass cannot be tethered to share with other devices.

If you need more high speed data in your base plan, you can switch your plan to:

• RM30 plan = 1GB high speed Internet + unlimited calls + unlimited SMS
• RM40 plan = 5GB high speed Internet + unlimited calls + unlimited SMS
• RM60 plan = 10GB high speed Internet + unlimited calls + unlimited SMS

When you subscribe or switch to the RM60 plan called Hotlink Postpaid Flex Plus, you can buy the following phones with 24 months contract with very attractive price:

• Vivo Y81i @ RM1 only
• Vivo Y85 @ RM199
• Vivo Y95 @ RM399

Note that these are mid-range Android smartphones, which performance is not comparable with high end or flagship smartphones.

You can install the Hotlink Flex app available in Google Play Store or iTune App Store to manage your account and monitor your high speed Internet data usage.

Note that the app for this Hotlink Postpaid Flex plan is called Hotlink Flex, not the other Hotlink RED (for Hotlink prepaid users) or MyMaxis (for Maxis postpaid users).

Inside the Hotlink Flex app, there are also quite a number of hot deals containing discount e-voucher as a kind of benefit to its users.

Note that as this is a postpaid plan, Maxis will charge you RM10/month to send itemized paper statement to your address. This is considered pretty expensive. Even if you opt for the summarized paper statement, it will also cost you RM5/month.

You can eliminate this monthly charge by opting for eBill to have your monthly statement sent to your email address instead. eBill is free of charge. You can switch between eBill and paper statement inside the Hotlink Flex app.

You can also set up Direct Debit to have Maxis auto-charge your credit card for monthly payments, so that you don't have to worry about handling your monthly payment. Hotlink Flex app contains a direct web link for you to manage your Direct Debit instruction, which you can register, change credit card, suspend, reactivate or terminate your Direct Debit with Maxis.

To subscribe or port in to this Hotlink Postpaid Flex plan, you will need to visit a Maxis Store. Your SIM card will be given to you on the spot. If there is available stock for the Vivo phone and you are subscribing to the Hotlink Postpaid Flex Plus plan with contract, you can also straight away carry your phone back from the shop.

This is quite a cost effective plan, especially for those who can make good use of the unlimited calls and unlimited SMS (e.g. businessman, sales person, agent, remote support person, etc. who needs to make a lot of calls and/or SMS every month). After all, Maxis is still the industry leader with good and stable 2G/3G/4G network coverage and speed that you can rely on.