Format 64GB SD card to FAT32 with AOMEI Partition Assistant

Most Android based devices such as CCTV, dashcam, etc. indicate that they only support SD card up to 32GB only.

This is simply because SD card of 32GB and below is pre-formatted with FAT32 partition which is accessible by the Android system. Microsoft Windows has put itself a limitation to be able to format a storage device into FAT32 partition for up to 32GB only. It will force you to format storage device above 32GB (eg. 64GB, 128GB, ...) with either exFAT or NTFS.

However, most Android based devices don't support exFAT and NTFS, therefore unable to access your storage device with such partition format.

This does not mean that you cannot use storage device of 64GB and above in those Android based devices, because you can still format them into FAT32 by using 3rd party tool such as the free AOMEI Partition Assistant Standard Edition.

The process to convert exFAT partition into FAT32 with AOMEI Partition Assistant Standard Edition is pretty simple.

You just need to right click on the existing partition, select Format Partition from the menu, set the File System as FAT32, click OK, then click Apply which is the first menu bar option on top.

With this, your 64GB or 128GB SD card is very likely to be able to work without problem in those Android based devices.

Click here to download the AOMEI Partition Assistant Standard Edition software for free. It is free for both personal and commercial use.

You might be also interested to read about:

• Check for bad sectors in USB thumb drive and fix it with AOMEI Partition Assistant

Fix the "need new app to open ms-wpc" message keeps on pop-up problem in Windows 10

If you are facing a problem with Windows 10 with a pop-up message as below that keeps on prompting even though you continuously clicked on the OK button, here is the fix.

Right click on the Windows icon on the left of taskbar, and run Windows PowerShell as admin.

Copy and paste the following command to run in the Windows PowerShell admin console.

Get-AppXPackage -AllUsers | Foreach {Add-AppxPackage -DisableDevelopmentMode -Register "$($_.InstallLocation)\AppXManifest.xml"}

Hopefully after this, your problem will be fixed.

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.