Google Refine 2.1 was released in July 2011 as a maintenance release primarily focused on bug fixes.
New Features
- JSoup-based HTML parsing ( issue 220 & issue 338 ) - new functions: parseHtml, select, htmlAttr, htmlText, innerHtml, ownText
New codec & clustering options: Metaphone3 (American English) and Cologne Phonetic (German - issue 399 ) - Google Fusion Table import support
- new facet for exact duplicates ( issue 398 )
- save favorite (starred) transforms ( issue 222 )
- new math functions ( issue 224 ) - acos, asin, atan, atan2, cos, cosh, sin, sinh, tan, tanh, even, odd, abs, fact, factn, combin, degrees, radian, gcd (greatest common denominator), lcm (least common mulitple), multinomial, quotient
- new operator: modulo (%)
- new constant: PI
- update to Apache POI 3.7 (Excel library)
- update to Apache Commons Codec 1.5
Bug Fixes
- issue 415 - Operand evaluation order wrong for + and - operators
- issue 404 - Character set incorrectly detected during project create
- issue 401 - Export error reporting masks real error
- issue 374 - INC function doesn't work for dates
- issue 351 - unable to export to Excel for projects with more than 256 columns
- issue 334 - Fusion Table CSV import causes NPE
- issue 294 - Export date value in CSV/TSV
- issue 263 - & character parsed incorrectly in XML import
- issue 358 - attempts to compare two values with all stop words returns NaN
- issue 276 - Character encoding issue with project create
- issue 228 - partial fix?
- issue 202 - sort text with accents
- issue 197 - date wraparound at year boundary
- issue 196 - removing columns causes error and disables undo
- issue 185 - Same reconciliation candidate for multiple cells causes problems
- issue 184 - date.toString() doesn't work
- issue 107 - non-ASCII characters don't display correctly during reconciliation
- issue 61 - multi-line text literals don't work in XML importer
Full list of changes