S3 Upload CSV Tab Delimiter Causes Additional Rows To Be Created

[lowsingh]

I am trying to load a csv file into S3 which is Tab Delimiter.  However, when the file is loaded it creates an additional row while the data shifted in the additional row.

 Row 2 is the correct data but in row 1 the data is shifted.

[cmcclellan · Accepted solution]

So there must be an extra tab in the first record ?

[lowsingh]

That looks to be the issue.  I added a cleanse tool before the upload and removed tabs.