Txt file too big

[thompo511]

Hi all,

I have a txt file that is getting an error message due to too many fields being contained in each record. Is there a way to get around this issue?

Many thanks,

Ben

[Felipe_Ribeir0]

Hi @thompo511 

Have you tried to configure the input tool as .flat? You can parse the fields after the input with the text to columns. For me, it worked on similar situations.

[FrederikE]

Hey @thompo511,

Does your txt-file contain a delimiter? Then you have to specify it in the input tool, otherwise all is punched into a single column. 

Another option can be to increase the "Field Length" in the input tool, could also be the issue (default is only 255 characters). You might want to increase this.

[thompo511]

Hi @FrederikE & @Felipe_Ribeir0 

I've got a delimiter and already increased the field length and I'm still getting errors. Have you any further ideas?

Thanks,

Ben

[FrederikE]

@thompo511,

Have you tried to change the file type to a .csv (manual change by renaming it)? Sometimes helps too. 

Other then that I am running out of ideas. 

[Luke_C]

Hi @thompo511 

This error usually means that you have more fields in your data than you do in the column headers. Try importing with a \0 delimiter (will bring it in as one column) then use a text to columns tool to split on the pipe delimiter. It should become clear where your fields start to cause issues. 

I also noticed you have option 9 to 'ignore delimiters in' set to none - this could also be causing your issue, try setting it to ignore in quotes.