XL-Tools provides a bunch of functions for list of strings, grouped in five categories :
No duplicate, Only duplicates, Count items, Count characters, L1-L2, Column to row, Row to column, List to regex, Concat,
Split strings, Split and extract, Merge lines, Replace, Reverse string, Transliterate, Lowercase, Uppercase, Add line number
Alphabetical order, Numerical order, String length, IPv4 Address, Date and time, Randomize
Hex to ASCII, ASCII to Hex, Hex to Base10, Base10 to ASCII, URI Decode, URI Encode, HTML Decode, HTML Encode, Base64 to ASCII,
ASCII to Base64, SHA1 - Base32 to Base16
Anytime to Anytime (Datetime (any formats), Unixtime, ChromeTime, LDAPTime, Filetime, SystemTime, Mac Absolute time, Mac HFS+ time),
Time difference, Add time, Substract time.
NSLookup, CIDR to IP Range, IP to Arpa, Arpa to IP, Resolve MAC Address, Resolve GeoIP, Resolve ISP, Resolve User-agent, Credit Card
to issuing company, Address to GPS, GPS to Address, Distance between locations, Custom functions
[Utils] With Resolve IPv4 GeoIP and Resolve User-agent functions,
it's now possible to select multiple options.
Determine locale timezone.
Donwloading and converting MAC OUI database is now faster.
Adding or modifying Custom functions is now faster.
[Time] With time difference, you can now get result by absolute number of years, months, weeks, days, hours, minutes or seconds.
[Utils] New Address to GPS coordinates function.
[Utils] New Distance between locations function.
[Utils] When Resolve MAC Address function is selected, the current date of the database is displayed.
When XL-Tools is used for the first time, some defaults values are set to prevent error with [Datetime]. It includes language
(en-US), local timezone (America/New York) and charset (cp1252). You may change these values before using [Datetime] function.
[Datetime] Output language is now known as Default language and applies to input as well. If a datetime contains language
specific object, like month name, you can set the appropriate default language and XL-Tools will be able to parse it correctly.
[Datetime] Double clic on an entry in the Datetime format will open it in the Edit window.
[Datetime] There was a problem when timezone was implicetly included with datetime format like unixtime.
[Datetime] There was a problem with ambiguous timezone abbreviation like EST, PST, CST, etc. These ambiguous timezones
are now set to fit the most appropriate offset. See Documentation.
With [Lists] Merge Lines, there was a problem when evaluating required parameters.
When creating a new datetime format, there was a bug with the timezone pattern in combobox (%Z-%z).
When a list contained more than one empty line at the beginning, items were not enumerated at all.
Input and output formats can now be fully customized.
Datetime formats are stored in a database: You can add, edit or delete any formats from the database. You can set a
format to be use as input, output, both or not used (hidden from list of choices).
Local timezone can be customized.
Output language and charset can also be customized.
Time functions can be used on any string. Data before or after the datetime object can be parsed with the results.
Oldest functions like Unixtime to Anytime, ChromeTime to Anytime, LDAPTime to Anytime, Anytime to Unixtime and Date
to Weekday are now available using the appropriate datetime formats.
Two new time functions have been added for Windows Filetime (64 bits hexadecimal) and Windows SystemTime (128 bits
Unixtime with more than 10 digits freezed the tool.
To translate XL-Tools to other languages:
In Settings window, use the Export Lang.ini function. The file will be
saved in the same directory of the tool;
Open the file in any text editor like Notepad;
Translate each expression at the right of the = symbol;
The expression on the left side is used by the tool to identify the expression so do not change it. Also,
be sure to have a space between the = symbol and your expression (ex. Key = Value);
Authorized characters are alphanumerics, spaces and these symbols: ",", ".", "-", "!", ",", "(" and ")".
Any other character will be deleted;
For some controls, string length must be the same as original. A longer string could be truncated if it
doesn't match the length of the field;
The value associated with the translatorName will be used in the About
window to identify you as translator (if you want). You can also add your email or a short url (ex. YourName
Restart the tool so the strings in Lang.ini will be used instead of the default language.
This program is free software: you can redistribute it and/or modify it under the terms of the GNU General
Public License as published by the Free Software Foundation, either version 3 of the License, or (at your option)
any later version.
This program is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the
implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License
for more details.