Data Cleansing at Mac App Store analyse

App power index: 100 (based on ranks around App Stores today)
Business Utilities Business Utilities
Developer: Holy Mackerel Software
Price: 0 free
Current version: 1.1, last update: 8 years ago
First release : 19 Jul 2012
App size: 17.76 Mb
4.0 ( 3100 ratings )
follow app ASO analyse

Estimation application downloads and cost

> 2.2k
Monthly downloads
~ $ 900
Estimation App Cost


Perform Data Cleansing on any MySQL database. Clean your Text, Number and Date field values with 50 different cleansing types.

Preview your changes before they are made. See the original and the cleaned values side-by-side. Make last minute edits or remove certain records from updating.

Save the preview changes to a spreadsheet, CSV or tab-delimited file. Copy the changes to the clipboard for pasting elsewhere.

Many of the cleansing types have options to tailor your specific changes.

View the Wikipedia page on data cleansing directly in the app.

When you are ready update the changes directly into the database.

Cleansing types include:
iNVERT cASE
lowercase
RaNdOM cAsE
Title Case
Sentence case
UPPERCASE

Add Time to Date
Bullets to Hyphens
Date Format
Day of the Week
Day of the Year
Days left in the Year
Em/En-dash to Hyphen
Hash Value
Hyphen to Em-dash
Hyphen to En-dash
L33T Speak
LineFeeds to Returns
Non-breaking Spaces to normal Space
Normal Spaces to non-breaking Space
Number Format
Number of Letters
Number of Words
Number to Words
“Quotes”
Returns to LineFeeds
Shift ASCII value
Soundex Code
Symbols
Tabs to Spaces
Value
Week of the Year

Remove All
Remove All ASCII
Remove ASCII Control characters
Remove Excess Returns
Remove Excess Spaces
Remove Excess Tabs
Remove LineFeeds
Remove Non ASCII
Remove Non Letters
Remove Non Numbers
Remove Periods
Remove Punctuation
Remove Returns
Remove Spaces
Remove Tabs

Email to Web
Name to Salutation/First/Last
Phone Number
Read more
Available in countries
Country Price
Canada 27.99 CAD
China 128 CNY
France 19.99 EUR
Germany 19.99 EUR
Italy 19.99 EUR
Netherlands 19.99 EUR
Portugal 19.99 EUR
Spain 19.99 EUR
Poland 19.99 EUR
UK 14.99 GBP
India 999.99 INR
Japan 999.99 JPY
Russia 999.99 RUB
Turkey 52.99 TRY
USA 19.99 USD
Korea, Republic Of 21.99 USD
Ukraine 19.99 USD
Available for devices
MacDesktop,