• 1. Numbers
• Parse and format Phone Numbers
• Convert to Decimal Latitude or Longitude
• ISBN-10
• Convert an ISBN-10 to ISBN-13
• 2. String manipulation
• Extract out the first value in a multi-valued cell
• Change "2010-05-31T01:10:0Z" to "05/31/2010"
• Trim whitespace from beginning and end of values
• Titlecase that works on hyphenated names
• Replacing Chars, Punctuation, etc using regular expressions
• "someprefix_a2343" -> "a2343"
• "blah_2342_blah_1232" -> "2342_blah_1232"
• "a:b:c:d:e" -> "b:c:d"
• Unique separator for split / join multi-valued cells
• Pad with leading zeroes
• Finding Proper Names or People Names in a String
• Separate letters and digits e.g. Aug13 -> Aug 13
• Find a sub pattern that exists at the end of a string
• Remove the last word in a string
• "00003400340300004" -> ["000034","0034","03","00004"]
• split / map / join
• "AT&T" --> "AT&T"
• Remove/extract words contained in a file
• Replace string list entries
• 3. Dates and Time
• Comparing Dates in columns
• Convert Epoch/Unix time to Date/Time as String
• How to convert Date string back to Unix time
• Convert Time to Minutes
• 4. JSON
• Parse JSON and Create Custom Arrays using forEach()
• Filtering or applying conditional logic to JSON Arrays
• Parse an IP address to extract a Country Name, Latitude & Longitude
• 5. Fetch URLs and Web scraping
• Get HTTP Response Header field (e.g. redirect location)
• Get HTTP Status code (e.g. link checker)
• XML parsing & stripping
• 6. Duplicate Patterns
• Removing duplicate rows when Exact values are found in a column
• Handling duplicate patterns found in cells within a column
• Facet and Count duplicate patterns found in a cell value at each row
• 7. Columns
• Count non-blank values in each column
• Count blank values in each column
• Create a new column based on the value of "Star" or "Flag"
• Combining datasets
• Using cross() to combine data from two projects
• Example:
• Using cross() within a single project
• Finding previous row
• Merging several columns
• Merging all or more than two columns in a project
• 8. Error Handling
• forNonBlank
• 9. Encoding Issues
• Replacing diacritic (accent) characters
• "Aïn Témuchent" ---> "Aïn Témuchent"
• Spot Values Potentially Placed in the wrong Column
• Question Marks � showing in your data
• 10. Records and Rows
• Facet for rows with a certain number of blank cells
• Get multiple rows from a Record row column
• Shift values in multiple rows
• 11. Clojure
• Extract row and cell information
• Convert Roman numerals to Arabic
• Java interop with Clojure
• Parse a URL or URI to extract a Host, Path, Query, or convert to a URI
• 12. Templating exporter
• Use the templating exporter to produce YAML or MARCXML
• Use the templating exporter to produce other formats
• 13. Reconciliation
• Inspecting reconciliation candidates