truncate erroneous data