The Definitive Guide to Data Quality
What is the delimiter in actual data for collateral field as well as other fields? because if actual data looks similar to above data, then it is not possible to distinguish collateral fields with other fields. tNormalize would help in this regard... but to implement this, we need to identify the column where collateral fields are available.
10000 x x x Ford Taurus Honda Accord x x