|
Klassiska filtyper är inte längre tillgängliga för användning från och med januari 2021. Du kan överföra dina klassiska filer eller ladda ner en PDF. Läs mer

CSV files ....Exit message:record on line 8: wrong number of fields

Besvarat
Begär demo

A csv is being delivered to a sftp folder. The csv was created from a formatted excel report. 

This error keeps getting generated . Looking at the file in notepad++, row 8 does not look any different except for starting with a comma.

Exit message:record on line 8: wrong number of fields 

Here is a sample for rows 7-9.
Consolidated Statement of Financial Condition
,Feb-22,Dec-21,Variance,Variance %,Dec-21,Variance,Variance %
ASSETS,,,,,,,

Any ideas on how to work around this error?
0

Kommentarer

2 kommentarer

Datum Röster
  • Officiell kommentar
    Wayne Paffhausen

    Hi Ryan,

    Depending on what you are trying to do the message is expecting the file to be uniform.  What that means is the same number of fields on each line.  You will need to ensure uniformity within your file or make adjustments to your process.

    The process stops on the first "different" line.  So the issue is that Line 7 is different than Line 8.  So you need to really review Lines 1 thru 8 and determine what is the right format and processing rules.

    Thank you,
    Wayne

  • Ryan Townshend

    Thanks Wayne.

    Any suggestions on how to make the lines uniform, adding in additional comments, something with regex? 

     

    0

Du måste logga in om du vill lämna en kommentar.