Hi,
I am reading around 400 txt files from common share. Each txt files having 100000 records. Out of 400 , around 7 or 8 has additional columns with no header. its just # as additional column at only one record of row. so when i run the files, I am getting error as "Too many fields at 11848 line" like this.
when i manually open that particular txt files and clear # means, then its working. but its repeated process for me.
Is there any way we can avoid this like take only 14 columns and ignore remaining.. like this , do we have any option
