Lets Learn something new together!
|2016/06/10 - V1.01b released! Fix to Installer - Download now! Click Here!|
As an example of the use of the use of the File converter, here is a case I used it in recently:
The task I had was to convert a CSV file I downloaded from the internet into a format suitable for the old DOS program Dbase III,
Below is the file as it appeared in notepad, There are several problems with this file:-
1. The name on line 98344 has MojiBake symbol corruption - there is a problem with the file format
2. The name on line 98346 has foreign symbols encoded in HTML format
3. Dbase is likely to have issues with nonstandard Ascii characters, so I want to convert everything to safe characters
Using the file converter, I selected the source file.
at first I assumed the file was Ansi, or UTF-8, however the preview screen still showed corrupt symbols.
However UTF-7 resolved the problem, so this must be the soruce format.
So now we can read the format OK, we need to convert it to a format Dbase will like
First we need to remove the "ô" entries and replace them with their equivalent symbols, the texttrick "HtmlUnicodeReverse" will do this
Then we want to replace all ascii chars>127 with their closest A-Z equivalent, "asci127safe" will perform this conversion
We can preview the conversions using the "Preview TextTricks" tab.
Finally, we want to output the file in a simple encoding as we have now removed all the troublesome characters, so selecting "US-ASCII" seems best.
Now everything is set up we can save the file
The final file can be seen below, with all its problems fixed