Data truncation feature

[nicknestle]

For some databases, if the data is larger than the expected size of the column the record fails. A map-to function that allows trunctation at x characters has been requested by a few clients. They are aware that truncating data basically means the data isn't useful so this is more to protect against unexpectedly large data causing an error (e.g. sometime types 600 chars in an email field).

[solleks]

This issue might be addressed by the 'substr' function (documented in this section) which was added this summer.

For example, substr(0, 128) in the Map Via column will truncate a field to 128 unicode characters.