TSV file 4GB

Hello guys I need help with reading and editing a tsv file, It is a chemical file in the pictures there is a sample of the data and the error am getting any help?

Screenshot (264).png

Error: Input Data (9): Error reading "C:\Users\wolve\Desktop\BindingDB_All.tsv": Too many fields in record #1013457

Screenshot (263).png

Preparation

Accepted answers

mceleavey

@MZ900605 ,

Simply apply a text to columns tool to the single column and use \t as the delimiter.

I've attached the following example:

You will probably then need to fix that broken row, but it will process and allow you to sort that out after the fact.

tsv example.yxmd

All comments

mceleavey

Hi @MZ900605 ,

This is usually due to the delimiter being present in a cell in a single row.

If you can post the data we can build it for you, but if you want to have a crack, try opening it with a \0 delimiter and then parsing it manually with text to columns.

MZ900605

@mceleavey

I have almost 49 columns, \0 delimiter will only show the first couple of tabs merged all in a row!

Screenshot (265).png

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703