One Software

Combine two MS Excel tables into one based on a common column of data from each table. The two tables can be located in the same Excel file or two different Excel files. Rows from the two unequal tables will line up perfectly without copying and pasting. A wizard makes the join process fast and easy. Excel 2000 or higher required.

Use this application to find and extract emails in your Excel files. Save the results to a text file.

Horizontally merge (combine, match, union) two Access tables into one by a common column (field) of data. The two tables can be located in the same Access file or two different Access files. No complicated options or SQL knowledge required. For Access experts, this is similar to an OUTER JOIN where a new table is created with the results.

Sort a group of selected cells in MS Excel using different methods. Features include: A-Z Sort Selected Cells Starting at Second Character Position, Starting at Third Character Position, Starting at x Character Position, Starting at Second Word, Starting at Third Word, Starting at x Word, Starting After User-specified Characters, By Alphabet Characters, By Numeric Characters, By Alphanumeric Characters, By Non-alphanumeric Characters, Backwards

Search for certain characters within an Microsoft Access database. If these characters are found, extract the field and save to file. Also, extract Access data between starting and ending characters throughout the entire database.

Search and find email addresses in Microsoft Access databases. Emails are saved to text file.

Search for and replace data (characters) in your Microsoft Access database tables. You decide which tables to make replacements in. Replacements are not made in special cases such as booleans (True/False) and primary keys.

Search for certain characters within a MySQL database. If these characters are found, extract the field and save to file. Also, extract MySQL data between starting and ending characters throughout the entire database.

Search for certain characters within a MS SQL Server database. If these characters are found, extract the fields and save to file. Also, extract data between starting and ending characters throughout the entire database.

Search, find and eliminate duplicate lines or words in one or many text files. There is a feature to automatically backup your files before taking action.