Receiving "Too many fields in record #1326265" when reading a tab delimited text file

I am receiving "Too many fields in record #1326265" when reading a tab delimited text file in a workflow that I have been running successfully for months using the same daily file download.

Below is the normal input setting and a snapshot of the error message. I searched the forum and tried changing the field length.

Workflow

Input

Accepted answers

JosephSerpis

Hi @sonseeahray this post on the community might be helpful as it has some suggestions to deal with this error.

All comments

JosephSerpis

Hi @sonseeahray this post on the community might be helpful as it has some suggestions to deal with this error.

sonseeahray

Hi @JosephSerpis, I read that one earlier and is where I got the suggestion to try changing the field size. I did also search for \t within the file as Charlie suggested.

sonseeahray

Hi @JosephSerpis, I did not try "Treat Read Errors as Warning." This allowed the entire file to be read in. Thank you.

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15880

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703