Le-tools.com - XL-Tools

Description

What is it

XL-Tools provides a bunch of functions for list of strings, grouped in five categories :

Category	Functions
Lists	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, Split and merge, Reverse split and merge, Replace, Reverse string, Transliterate, Lowercase, Uppercase, Add line number
Sorting	Alphabetical order, Numerical order, String length, IPv4 Address, Date and time, Randomize, Reverse current order
Conversion	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, SHA1 - Base16 to Base32, Format File Size
Time	Anytime to Anytime (Datetime (any formats), Unixtime, ChromeTime, LDAPTime, Filetime, SystemTime, Mac Absolute time, Mac HFS+ time), Time difference, Add time, Substract time.
Utils	NSLookup, CIDR to IP Range, IP range to CIDR, IP to Arpa, Arpa to IP, IP to IP Type, 6TO4 IP to IPv4, Resolve Teredo, IP to GeoIP, IP to ISP, Resolve MAC Address, Resolve User-agent, Credit Card to issuing company, Address to GPS, GPS to Address, Distance between locations, Custom functions

See documentation for more details.

How it works

XL-Tools can be installed using the installer or used as a standalone application. In order to start using it, just run the executable file from the start menu or the directory you install it.

What do you need

Windows XP SP2 or newer

Screenshots

Main window

Lists - Concat

Lists - Split and Extract

Lists - Merge Lines

Lists - Split and Merge

Sorting - Date and time

Conversion - Base 10 to ASCII

Conversion - URI Decode

Time - Anytime to Anytime

Datetime database window

Utils - Resolve MAC Address

Utils - Resolve GeoIP

Utils - Resolve ISP

Utils - Resolve user-agent

Utils - Credit Card to Issuing Company

Utils - Custom functions

Utils - Custom functions - Edit

Version History

Version	Comments
4.0 2020-07-26	New: OSM database is now created during autoconfiguration at first start of the tool. [Lists] Added regex option to Row to column function. [Lists] Added multiple options to Add line number function. [Lists] Added Reverse split and merge function. [Lists] When regex is used, a colored border indicates if regex is valid. [Lists] New Split by number of chars option with Split and Split and extract function. [Lists] New On this occurence(s) only option with Split function. [Sorting] Added Reverse current order function. [Conversion] Added Format File Size function. [Utils] Added IP to IP type, 6TO4 IP to IPv4 and Resolve Teredo function. [Utils] Added Scheme only option with Credit Card to Issuing Company function. Fixed: [Time] When timezone was set as name, it was not converted correctly. [Time] When a new datetime format was created, it was not sorted in list.
3.9.1 2020-01-12	New: Removed GeoIP database update.
3.9.0 2019-11-10	New: [Utils] Added GPS to Address function. [Utils] Modified Address to GPS function: Google has been replaced by OpenStreetMap.
3.8.1 2019-06-09	Fixed: Check update for GeoIP database was not working properly.
3.8.0	New: [Conversion] Added SHA1 - Base16 to Base32 function. Fixed: [Datetime object] There was a problem with the pattern combobox in the Datetime object window.
See Changes.txt for older releases.

Translation

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 (youraddress@email.com));
Restart the tool so the strings in Lang.ini will be used instead of the default language.

If you translate the tool and you want to share, contact the author.

Available translations:

To install, save the appropriate Lang.ini file in the default folder of the tool (if you used the installer, it should be AppData. Otherwise, it's the same folder of the program).

No translation available for the moment.

License

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.

You should have received a copy of the GNU General Public License along with this program. If not, see http://www.gnu.org/licenses/.

Credits

For database:

This product includes GeoLite2 data created by MaxMind, available from https://www.maxmind.com.
OUI Database comes from the IEEE Standards Association. Link for the database is http://standards-oui.ieee.org/oui.txt.
The Address to GPS and GPS to Address functions was made possible through the Nominatim API (Data © OpenStreetMap contributors). OpenStreetMap (OSM) data available through these Services is licensed under the Open Database License as interpreted by the OSMF Guidelines. See also https://osm.org/copyright.

For icons:

The main logo of XL-Tools has been created by Saki (Alexandre Moore) and is distributed on term of the GNU General Public License.
The icon used for Process button comes from Danish Royalty Free Icons by Jonas Rask Design. This icon is distributed as Freeware.
Documentation and Cancel (in Utils - Custom Functions) button icons has been created by Oxygen Team on term of the GNU Lesser General Public License.
A lot of icons used for buttons come from the Blue Bits collection of Icojam (licensed as "Public Domain") like config, about, open file, delete, check update, import database, etc.
Stop icon has been created by emey87 (Manuel Lopez) and is distributed on term of the CC Attribution-No Derivative 4.0 license.
Icons for buttons in Utils - Custom Functions and for Datetime database come from Farm Fresh Icons by Fatcow Web Hosting and are distributed on term of the CC Attribution 4.0 license.
The check icon used in Configuration Wizard has been created by Cheezen (Anders Bjarnle) and is distributed as freeware.
The Copy data from results icon has been created by Yusuke Kamiyamane (http://p.yusukekamiyamane.com) and is licensed under a Creative Commons Attribution 4.0 License.

Download

Source code is hosted on SourceForge and GitHub. Binaries are hosted on SourceForge.

Filename	MD5	SHA256
XL-Tools 4.0 Setup.exe
XL-Tools 4.0.zip
XL-Tools 3.9.1 Setup.exe	04e5b0efc4c05afaf5b04c3ed5bca8f0	0cd0b6efda99ff854874e9692bc91bc55522d61d2892a8e4caffa5ee06bfde8b
XL-Tools 3.9.1.zip	fa3f51c0790c6954a1b0a7d2572dd081	e20aecd0c36c705d892caf8aa09df9fdfb80509a52f1eb8b37aa74953d24e5d8
XL-Tools 3.9.0 Setup.exe	4f6ded0002a3284951fcdaca993d921b	245e62b8bc8dd5cb0f0492bf63f98ff8f802ccb6d91fb7af8a1a5167afae157f
XL-Tools 3.9.0.zip	8d9fa2cceafbb0b3c49da8814ba52ce3	bcd574d9d5b350dc78e0038166fa91058a0e53c375e31b6bae61dd4829635f2c

If you want to download the standalone version or an older version, check on SourceForge.

Additional content
Datetime Database	[Updated 2019-03-02] This database is used with sort by date and time function and with all functions in Time.
Custom Function - Resolve TLD	Custom function that resolves TLD to country name or organisation. Uncompress and use the import function to add.
Custom Function - State code to State	Custom function that resolves State code to State name (US and Canada only). Uncompress and use the import function to add.
Custom Function - Language code ISO-639-1	Custom function that resolves the language code to the language name, based on ISO-639-1.

If you install many tools of the XL-Toolkit, you should follow these instructions.