CleanHaven is a program designed to make the cleaning of text easy. Paste in your text, check a box, then preview the change — the original text remain unchanged. Whether it is one paragraph or thousands, it works really fast.
CleanHaven was designed to correct columns of text from spreadsheets before importing into a CRM such as CRMHaven. Copy a column of data from a spreadsheet, clean it, then paste it back in. Conversion types include:
Case iNVERT cASE, lowercase, RaNdOM cAsE, Title Case, Sentence case and UPPERCASE
Sort Ascending, Case-Sensitive, Descending, Numerical Value, Random Sort, Reverse and Words Within Paragraph
Duplicates Remove Duplicates, Show Only Duplicates and Show Only Unique
Convert Add Time to Date, Alphagram by Paragraph, Alphagram by Word, Anagram by Paragraph, Anagram by Word, Bible Verse to Passage, Bullets to Hyphens, Butchers Talk, Date Format, Day of the Week, Day of the Year, Days between two Dates, Days left in the Year, Days left until Christmas, Diacritical Characters to non-diacritical, Double Metaphone, Em/En-dash to Hyphen, Encrypt, Hash Value, Hyphen to Em-dash, Hyphen to En-dash, L33T Speak, LineFeeds to Returns, Morse Code, Non-breaking Spaces to normal Space, Normal Spaces to non-breaking Space, Number Format, Number of Letters, Number of Words, Number to Words, Palindrome, Phone Keypad Number, Pig Latin, “Quotes”, Random Password, Returns to LineFeeds, Revise Negative Verbs, Shift ASCII value, Soundex Code, SQL compliant, Symbols, Tabs to Spaces, Time Difference between two Dates, Transpose Rows and Columns, USA to British period placement, Value, Week of the Year and Wrapped Lines
Remove All ASCII, ASCII Control characters, Email Addresses, Excess Returns, Excess Spaces, Excess Tabs, LineFeeds, Non ASCII, Non Letters, Non Numbers, Periods, Punctuation, Returns, Spaces, Tabs and Web Addresses
Personal Address Lookup on Web, Combine Columns, Combine Paragraphs, Common First Names, Common Surnames, Distance between two Postcodes, Distance between two Latitute/Longitudes, Email to Web, Name to Salutation/First/Last, Phone Number, Postcode to Region and Salutation
Info Change Text Encoding, Frequency, Frequency Within, Spelling, Text Information, View As ASCII, View As Binary, View As Description, View As Hexadecimal, View As Octal, View Text Differences and View Text Encoding
Internet Add HTML Script, HTML Name to Text, HTML Number to Text, Show HTML Conversion Table, Text from HTML (All), Text from HTML (Visible), URL Encoding to Text, View as HTML Number, View as URL Encoding and View as Web
Replace Anywhere, At Start, At End, Between Texts, From Find Text to End, Insert from Start, Insert from End, Up until Find Text, Characters from Start, Characters in Middle and Characters from End
How CleanHaven works Simply paste the text you want to clean into the left window (there is no limit to the amount of text that can be pasted). Set the attribute you want cleaned (you can set multiple attributes). When you are ready press the Clean button. The converted text will appear in the right window. If the text has not changed the way you expected, change the attributes and click Clean again.
If you want to make additional changes to the text, click the Source button to pass the cleaned text back into the left window
Many of the conversions can be reversed
Click the Clipboard button to copy the cleaned text onto the clipboard
Click the Source button to move the Cleaned text to the left window
The Cleaned text is read-only, so you can't accidentally change it
You can clean by Whole Text, Paragraph, Word or Letter
Setting the Auto-Clean Clipboard on does a conversion merely by bringing the application to the foreground (nothing to click)
You can choose to clean only the selected text
Live cleaning causes the cleaning to happen as you type each character
You can swap the text in the left and right windows
You can speak the text in either window
You can toggle viewing of the invisible characters such as spaces
You can set the font size for both windows
Most settings are remembered between launches
You can view the Wikipedia article about Text Cleaning from within the application
Click to purchase from the Apple App Store
Click to download application from HMS
Use it fully twice each launch. If you like the program, please purchase it from PayPal below. You will be emailed a Serial Number within 24 hours.
HMS Release History
Available NowCleanHaven 2.5 — 19 October 2012 [New] You can now remove all email addresses, or as an option, remove all text except the email addresses. [New] You can now view the invisible characters. [New] You can now spell check words based on every dictionary. It returns Correct if the word is in one or more dictionary and Incorrect if the word is not in any of the available dictionaries. [New] You can now run the application at Full Screen on MacOS X. [New] You can now return a list of all the Dictionary languages that each word is listed in. [New] You can now remove excess tabs. [New] You can now remove all ‘http://…’ and ‘www…’ web addresses, or as an option, remove all text except the web addresses. [New] You can now lookup geolocation data based on Apple’s Core Location, Google and Yahoo APIs [New] You can now find the number of days from a date until Christmas. [New] You can now Encrypt and Decrypt your text using a PassKey and Salt text. [New] You can now convert words to Alphagrams (the letters of each word are sorted) by word or by paragraph. [New] You can now convert paragraphs to Palindromes (every letter is reversed). [New] You can now convert diacritical text to its non-diacritical counterparts e.g. ç becomes c (lowercase) or É becomes E (uppercase). [New] You can now choose to convert to Anagrams by word or by paragraph. [New] You can now check the spelling based on an expanded number of built-in dictionaries. [New] You can now calculate the number of work days between two dates (excludes Saturdays and Sundays) [New] You can now calculate the number of weekends between two dates (includes only Saturdays and Sundays) [New] You can now calculate the number of any particular day between two dates (i.e. ‘Mondays’ through ‘Sundays’) [New] When exporting the text to an SQLite database, TEXT fields are now automatically set to COLLATE NOCASE rather than the default COLLATE BINARY. This means that text searches are no longer case-sensitive for ASCII characters so searching for ‘steve’ will match ‘Steve’. [New] The dictionary now includes the option to search for swear words within the text. [New] The Dictionaries now support accented characters. [New] The Dictionaries are now much more extensive and support the following languages: Danish, Dutch, English, Finnish, French, German, Hungarian, Italian, Norwegian, Portuguese, Romanian, Russian, Spanish, SwearWords and Swedish [New] The application is now a Cocoa application, giving you contextual options. [New] Now saves your Preferences and font size between saves. [New] Compatible with Retina Display. [New] Compatible with MacOS X Mountain Lion. [New] Added the ability to sort words within a paragraph (as suggested by Rainer Baersdorf) [New] You can now remove all Page Numbers (as suggested by Michael Kristensen). [Fix] When there are no options available the Options window description takes up the whole window. [Fix] The UK/USA Postcode to Region conversion now allows you to pick the individual item to return (All Data, City, Country, Latitude/Longitude, Latitude, Longitude, Region, State or SubRegion). [Fix] The Styled text and Table functions are no longer supported. [Fix] The HTML Name, HTML Number and URL encoding conversions are now much more reliable. [Fix] The case of the First Name no longer matters when looking up the Salutation. [Fix] Options window doesn’t show unless there are entries available. [Fix] Finding the number of days left in the year now works for months with less than 31 days. [Fix] Converting Anagrams no longer freezes when converting multiple character words of the same letter.
CleanHaven 2.3 — 6 January 2011 [New] CleanHaven submitted to Apple App Store.
CleanHaven 2.2 — 6 January 2011 [Fix] Combining columns no longer places a comma on the left if the lefthand column is blank. [Fix] Formatting as Phone Number now removes the round brackets and plus signs. [Fix] Names beginning with salutations (such as Missy) are no longer confused as Salutations when converting to First/Last Names. [Fix] Showing Duplicates no longer shows one extra non-duplicate. [Fix] The splash screen has been removed so it is faster to launch. [Fix] When determining the Full Name, double-barrelled Surnames are now hyphenated. [New] A pro option in the Setting tab now allows for the clean operation to apply ONLY to selected text rather than the whole source text window. [New] Now provides a Total under the Frequency. [New] Pro option to auto-paste clipboard text into main window, clean the text, then auto-copy text from Results to clipboard on each clean [New] There is now a popup to check your text amongst all dictionaries: English, English (Lite), English (British), French, German, Italian, Spanish and Icelandic. Please note that these dictionaries have been sourced by third parties and may be missing certain words. [New] There is now a Pro keyboard hot-key (Command-L for Macintosh, Control-L for Windows and Linux) to perform the current clean on the clipboard text (via Keyboard System Preference) [New] There is now a Pro option to convert all HTML Names to ASCII text. [New] There is now a Pro option to convert all HTML Numbers to ASCII text. [New] There is now a Pro option to convert all Text to URL Encoding. [New] There is now a Pro option to convert all Text to HTML Numbers. [New] There is now a Pro option to convert all Text to HTML Names. [New] There is now a Pro option to convert all URL Encoding to Text. [New] There is now a Pro option to Convert Styled text to HTML. You must be in the styled View for this to work. [New] There is now a Pro option to find survey statistical information based on USA Postcodes. [New] There is now a Pro option to find the City, County, State and Regional information based on USA & UK Postcodes. [New] There is now a Pro option to find the Latitude and Longitude information based on USA & UK Postcodes. [New] There is now a Pro option to remove all standard HTML scripts leaving the plain visible text. [New] There is now a Quick Find button on the Find Tab to find the next occurrence of the Find text within the main window. [New] There is now a way to Replace any quotes with any other European or world quotes and back. The country presents include: Afrikaans 1, Afrikaans 2, Albanian, Basque, Belarusian 1, Belarusian 2, Bulgarian 1, Bulgarian 2, Catalan 1, Catalan 2, Chinese (Simplified) 1, Chinese (Simplified) 2, Chinese (Traditional) 1, Chinese (Traditional) 2, Croatian 1, Croatian 2, Czech 1, Czech 2, Danish 1, Danish 2, Danish 3, Dutch 1, Dutch 2, English (UK), English (US), Esperanto, Estonian 1, Estonian 2, Finnish 1, Finnish 2, French 1, French 2, French 3, French (Swiss), Georgian 1, Georgian 2, German 1, German 2, German (Swiss), Greek 1, Greek 2, Hebrew 1, Hebrew 2, Hungarian, Icelandic, Indonesian, Irish, Italian 1, Italian 2, Italian (Swiss), Japanese, Korean 1, Korean 2, Latvian, Lithuanian 1, Lithuanian 2, Macedonian, Norwegian 1, Norwegian 2, Polish 1, Polish 2, Portuguese (Brazil), Portuguese (Portugal) 1, Portuguese (Portugal) 2, Romanian 1, Romanian 2, Russian, Serbian 1, Serbian 2, Serbian 3, Slovak 1, Slovak 2, Slovene 1, Slovene 2, Sorbian, Spanish 1, Spanish 2, Swedish 1, Swedish 2, Thai, Turkish 1, Turkish 2, Ukrainian 1, Ukrainian 2, Welsh 1 and Welsh 2. [New] There is now an option to convert 'hyphen to em-dash or en-dash' and 'em/en-dash to hyphen'. [New] There is now an option to Convert curly quotes to back to straight quotes. [New] There is now an option to remove ‘All ASCII’ to show only characters higher than decimal 127. [New] There is now the option to buy and register a serial number to upgrade to CleanHaven Pro. [New] Title Case now has an option to not capitalise conjunctions i.e. Words such as: after, although, and, as, as if, as long as, because, before, but, even if, even though, for, if, nor, once, or, since, so, so that, the, though, till, unless, until, what, when, whenever, wherever, whether, while, yet, etc. [New] You can now a Pro option to extract the contents of all quoted text, such as from within a page of HTML. This will return all quoted text, not just visible text, so it will return lots of text. [New] You can now Preview your HTML Text in an HTML window. [New] You can now show a complete HTML Text Conversion Table. [New] You can now view your Text in Binary format (e.g. < (Decimal 60) as 00111100). [New] You can now view your Text in Hexadecimal format (e.g. < (Decimal 60) as 3C). [New] You can now view your Text in Octal format (e.g. < (Decimal 60) as 074). [New] You now have an option to Invert the capitalisation of the text.
CleanHaven 2.1 — 19 August 2010 [New] You can now perform most functions by words as well as paragraphs. The Cleaned Results window will reflect the results word by word. [New] You can now toggle between Table and Text views in the Settings tab (or typing Command-T). Choose whether all columns are affected by Convert and Replace actions or just a particular column. [New] When formatting Phone numbers CleanHaven asks for the position of the space divider. [New] The text fields now remove all formatting when text is pasted into them. [New] The Info menu can now show the Frequency of Paragraphs or Words from most to least common. [New] The CleanHaven window displays a counter of the text variables. The number of variables is reduced when viewing over 100,000 characters (to reduce the slowdown). [New] The Cleaned Results Text window can now be saved as a plain text file. [New] The Cleaned Results Table window can now be saved as an Excel XML, tab-delimited or CSV file. [New] Optionally the English dictionary can be replaced with any one of the French, German, Italian, Spanish, Icelandic and British English dictionaries (download the AllDictionaries.zip file, rename the chosen dictionary with filename ‘words’ and copy over the previous ‘words’ file in the Resources folder of the application. Mac users will have to right-click the application and choose ‘Show Package Contents’ first). [New] Now uses the English ‘YAWL 3’ dictionary with 264,058 words (rather than the previous ‘SCOWL 6 lite’ dictionary with only 77,676 words). [New] Menu Commands can now bring the CleanHaven or Cleaned Results to the foreground. [New] Auto-suggests conversion of Linefeeds to Returns in text (NeoOffice and OpenOffice use linefeeds as delimiters). [New] An Open dialog now opens any text file. If the file contains a ‘.csv’ extension the data is parsed as a CSV file. [New] A Clipboard button on the Cleaned Results window copies the whole Results text to the Clipboard. If you need only a portion, then highlight that portion then use the normal Copy command. [Fix] Title Case now makes capitals after ‘-’, ‘.’, ‘(‘ and ‘/’. Words such ‘of’ are made lowercase. Paragraphs ending with UK, ‘ UK ’ and ‘(UK)’ have this extension made all uppercase. [Fix] The Value conversion has been moved from the Personal menu to the Info menu. [Fix] The UK postcodes have been updated to be more accurate. [Fix] The Text Information calculation of the number of words and paragraphs has been improved. [Fix] The text field font is now much smaller. [Fix] The Salutation have been updated to be more accurate and some non-gender-specific first names have been removed. [Fix] The Phone Number formatting now takes into account any extension. [Fix] The Cleaned Results text is now read-only. [Fix] On Windows, after a Clean the text window now is scrolled to the top of the list. [Fix] Fixed a problem where removing excess spaces was removing spaces before plain quotes.
Previous [CleanHaven 2.0 — 6 May 2010 New] Checks for new version on HMS server. [New] Windows now uses an installer [Fix] Advertising window removed. Case: [New] You can now convert any base text into title case (first letter of each word is uppercase, the rest is lowercase), sentence case (first letter of each sentence is uppercase, the rest is lowercase), uppercase, lowercase, random case (each time you choose it each letter is randomly uppercase or lowercase) and curly quotes (plain quotes are changed to the 66/99 alternatives). Sort: [New] You can now sort any base text into ascending order (A to Z), case-sensitive ascending order (A-Z then a-z), descending order (Z-A), random order (sorts each paragraph differently each time you click Clean), reverse order (the opposite of however it is now sorted) and numerical order (sorts by the full numerical value rather than order of the text e.g. 0-9, 10-19 whereas alphabetically ’10’ comes after ‘1’ and before ‘2’). Duplicates: [New] You can now remove all paragraphs that have one or more duplicate paragraphs, show only those paragraphs that have one or more duplicates and show only those paragraphs that are unique. Remove: [New] You can now remove all excess returns (where one of more carriage return characters appears at the start or end, or double-spaces appear in the middle of the base text). [New] You can now remove all excess spaces (where one of more space characters appears at the start or end, or double-spaces appear in the middle of the base text). [New] You can now remove all line feeds (where one of more line feed characters appears anywhere in the base text). [New] You can now convert all line feed characters to carriage returns e.g. some programs such as OpenOffice use line feeds as delimiters rather than carriage returns. [New] You can now remove all non-ACSII characters i.e. that are not within the first 128 ASCII range. [New] You can now remove all non-letter characters i.e. that are not within the a-z and A-Z range. [New] You can now remove all non-number or space characters i.e. leaving you with only numerical data. [New] You can now remove all periods. [New] You can now remove all punctuation characters. [New] You can now remove all carriage returns. [New] You can now convert all carriage returns to line feed characters e.g. some programs such as OpenOffice use line feeds as delimiters rather than carriage returns. [New] You can now remove all tab characters e.g. though invisible these can cause a problem when pasting text into spreadsheets. [New] You can now see the numerical value of the each paragraph e.g. Get the values of a spreadsheet column containing currency, commas or text. Personal: [New] You can now combine columns separated by tabs e.g. converts multiple-columns of spreadsheet address data into one column of data ‘1 Main Street’ & ‘New York’ becomes ‘1 Main Street, New York’ replacing the tab with a comma where necessary. Empty columns are ignored. [New] You can now combine paragraphs separated by superfluous carriage returns e.g. some email programs wrap text after 70 characters wide making this text very hard to edit in a text editor. [New] You can now convert a column of email address to their web equivalent e.g. ‘firstname.lastname@example.org’ becomes ‘email@example.com www.apple.com’ so the data can be pasted back into a spreadsheet. [New] You can now convert a single column of first/lastname pairs to their separate columns, converts them to title case and, if missing, tries to find the correct salutation based on over 1000 common first names e.g.‘john smith’ becomes‘Mr John Smith’ so the data can be pasted back into a spreadsheet. [New] You can now convert a single column of phone numbers into a common ##### ###### format. It removes all excess spaces then places a space six characters from the right (unless there is a phone extension). This may be useful when searching for phone numbers in a CRM such as CRMHaven. [New] You can now look up the salutation for a single column of first names based on a database of over 1000 common first names. Males names are given the salutation‘Mr’ and female names are given the salutation‘Ms’. [New] You can now look up the UK postcode for a single column of UK postcodes from a database of over 2800 UK postcodes. From the set of UK postcodes the five values are returned as‘Postcode City County Region Country’ suitable for pasting back into a spreadsheet. Note that it only searches up until the first space character so the City/Town name is only approximate. Contact HMS if you want your country’s postcodes included. Info: [New] You can now check the spelling on a list of English words based on a database of a few thousand words. It will return either a list of only the correctly spelled words, or only the incorrectly spelled words or a list of the original words with a tab separating whether the original word is correct or incorrect so it can be pasted into a spreadsheet. Note that the dictionary is not exhaustive and there may be correctly spelled words that are marked as incorrect. [New] You can now decipher the ASCII values of a set of text characters e.g. ‘The Cat Sat’ becomes T«84»h«104»e«101» «32»C«67»a«97»t«116» «32»S«83»a«97»t«116»«13» [New] You can now get information about the text including the number of words, double-spaces, characters, non-space-characters, paragraphs, linefeed, escape and tab characters.
Replace Tab Chris Pirrillo Review Veronica Belmont Revision 3 Tekzilla Review (show title is wrong!)