Creating SQL Update Statements for Bulk Imports using DataClean

http://www.artenscience.co.uk/artenscience/Blog/files/sqlupdatesusingdataclean.html

www.artenscience.co.uk
Quality Commercial Software and Custom Software Development

DataClean 1.0.0 Released

Version 1.0.0 of DataClean has been released for Mac OSX, Windows and Linux.

DataClean is a Cross Platform Utility designed to make it straightforward to ‘clean’ large amounts of data. Data can be imported from a CSV or TAB delimited file, modified (any column, any row) and then saved back in several different formats including native Excel (XLS), TAB Delimited and Comma Separated. You can also save the modified file using your own Custom Delimiter.

DataClean supports the following Actions: Remove / Replace / Find / Insert and Format. Within each Action DataClean provides Tasks that you can apply to the data grid.

Tasks include:

Remove Leading Spaces
Remove Trailing Spaces
Remove Leading and Trailing Spaces
Remove Text
Remove Selected Row(s)
Remove Text from Start of Column
Remove Text from End of Column
Remove Text Before ...
Remove Text After ...
Replace Text
Find Text
Insert at the Beginning of the Column
Insert at the End of the Column
Insert Blank Row
Format as Uppercase
Format as Lowercase
Format as Capitalised

www.artenscience.co.uk
Commercial and Bespoke Software Development

DataClean Preview: Download for Mac / Windows and Linux

http://www.artenscience.co.uk/artenscience/DataClean.html

Download Links:

http://www.artenscience.com/autoupdate/latestversions/dataclean_osx.zip
http://www.artenscience.com/autoupdate/latestversions/dataclean_win.zip
http://www.artenscience.com/autoupdate/latestversions/dataclean_lin.zip

DataClean is a Cross Platform Utility designed to make it straightforward to ‘clean’ large amounts of data.

Data can be imported from a CSV or TAB delimited file, modified (any column, any row) and then saved back in several different formats including native Excel (XLS), TAB Delimited and Comma Separated. You can also save the modified file using your own Custom Delimiter.

DataClean supports the following Actions: Remove / Replace / Find / Insert and Format. Within each Action DataClean provides Tasks that you can apply to the data grid. Tasks include:

*Remove Leading Spaces
*Remove Trailing Spaces
*Remove Leading and Trailing Spaces
*Remove Text
*Remove Selected Row(s)
*Remove Text from Start of Column
*Remove Text from End of Column
*Remove Text Before ...
*Remove Text After ...
*Replace Text
*Find Text
*Insert at the Beginning of the Column
*Insert at the End of the Column
*Insert Blank Row
*Format as Uppercase
*Format as Lowercase
*Format as Capitalised



We are looking for feedback as to what additional features and / or tasks you think should be available within DataClean. All suggestions are welcome.

www.artenscience.co.uk
Commercial and Bespoke Software Development

DataClean Preview: Cross Platform Utility for Data Controllers

The Preview Edition of DataClean is available for download. Although the release version will be a Cross Platform Utility, the Preview Edition is Mac OSX Only.

http://www.artenscience.co.uk/artenscience/DataClean.html

DataClean is a Cross Platform Utility designed to make it straightforward to ‘clean’ large amounts of data. Data can be imported from a CSV or TAB delimited file, modified (any column, any row) and then saved back in several different formats including native Excel (XLS).

DataClean supports the following Actions: Remove / Replace / Find / Insert and Format. Within each Action DataClean provides Tasks. For example; within the Remove Action there is the Task ‘Remove Trailing Spaces’.
The Preview Version of DataClean is Framework complete, but at the moment has few Tasks. I am looking for feedback as to what you think should be available within DataClean.

All suggestions are welcome.



www.artenscience.co.uk
Commercial and Bespoke Software Development