In which case, perhaps your record separator isn't what you think it is?
In reply to Re^3: Clean a chunk of data by hippo in thread Clean a chunk of data by Anonymous Monk