Group Abstract Group Abstract

Message Boards Message Boards

2
|
7K Views
|
3 Replies
|
5 Total Likes
View groups...
Share
Share this post:

Mathematica 12 deletes the blank spaces when I import a TSV-File?

Thorsten Gerloff
Posted 4 years ago
POSTED BY: Thorsten Gerloff
3 Replies
Sort By:

Thank you both for the quick responses with suggested solutions and explanations.

I will then adjust my evaluations and pay attention to the speeds. The data sets are many MB in size and consist of decimal numbers, hexadecimal numbers and strings and must be converted accordingly.

The thread can be closed.
POSTED BY: Thorsten Gerloff
Sean Cheren
Sean Cheren, Wolfram
Posted 4 years ago

Several bugs were fixed in the CSV and TSV formats and the performance was dramatically improved between version 10 and 12. Leading and trailing spaces that are part of non-quoted fields are ignored as this is by far the most common behavior and expected by many applications. The old implementation of CSV was based on the Table format, so you can get that behavior bug for bug by doing:

ImportString[" 2e54295\t       0", "Table", "Numeric" -> False, "FieldSeparators" -> "\t"] // InputForm

If it is possible to rewrite your CSV files to quote these fields, then you can still use the CSV format and preserve spacing:

ImportString["\" 2e54295\"\t\"       0\"", "TSV", "Numeric" -> False] // InputForm
POSTED BY: Sean Cheren

Instead of "TSV", import using the "Text" or "List" specifier followed by StringSplit. 

ImportString[" 2e54295\t       0", "Text"] // StringSplit[#, "\t"] & // InputForm

Out/InputForm=   {" 2e54295", "       0"}

The preceding spaces are retained.
POSTED BY: Carl Verdon
Reply to this discussion
Community posts can be styled and formatted using the Markdown syntax.
Tag limit exceeded
Note: Only the first five people you tag will receive an email notification; the other tagged names will appear as links to their profiles.
Reply Preview
Attachments
Remove
or Discard