string fallback_val for Replace::FieldValueWithStaticMapping

Previously, if a string was given for fallback_val, the replaced field would be blank. Only :orig and :nil fallback_val values were handled.

Now, the replaced field will contain the fallback_val string if the static mapping does not contain the key being looked up.

add Explode::FieldValuesToNewRows

New transformation added.

Merge::MultivalueConstant

Add a specified constant value to a new multivalued field. Number of times the constant is added is based on number of values in specified field. Where specified field value is nil, blank, or equal to specified placeholder string, the placeholder string is added to new field instead.

Bugfix for Replace::FieldValueWithStaticMapping

Does not croak when multivalue option is used and field value is nil

Replace::EmptyFieldValues

Adds new transform to replace nil or blank string values in specified field(s) with the given string.

Add options to existing transforms

With this update,

• Replace::FieldValueWithStaticMapping can handle multival fields
• Clean::RegexpFindReplaceFieldVals can take :all as fields value to globally replace a value

Bugfix for CombineValues::FromFieldsWithDelimiter

This did not work properly when more than one source field value in a row was an empty string.

For example, two empty string fields combined with separator ' -- ' would be output as: ' -- '.

Now all empty string values are converted to nil and dropped before field values are combined.

Add :nulltonil CSV library converter

Adds converter for Ruby standard CSV library that converts all cells with "NULL" to nil values.

Add casesensitive option to Deduplicate::Fields transform

Adds casesensitive option (defaulting to true)

Addition of transform: Deduplicate::Fields

Removes value(s) of source field from target field(s)