Warning messages

You will see warnings against loaded rows on the main data grid and below is an explanation of each of them:

The last column (x) did not have a closing qualifier. This will be automatically fixed once saved

The very last column had an opening qualifier character but a closing one was not found, but as we are at the end of a row the missing qualifier can be easily added back on when saved.

The row did not have a standard windows line break of Carriage Return + Line Feed. This can be corrected when export.

This occurs normally when a file is loaded from a different operating system (mostly Linux) where a windows standard Carriage Return + Line Feed end of line marker isn't used. CSV Easy can work with these files without issue. When exporting you can force the windows standard to make this file more compatible on windows.

The column (x) contained additional qualifiers at the start that have been removed.

This means if a column is read in like this:

""some data", 2, "some more" it will be converted to this ""some data", 2, "some more"

This only occurs if the 'Remove surplus qualifiers' is set in the options.

The column (x) contained additional qualifiers at the start.

This means a column has been identified to look something like this:

""some data", 2, "some more"

It is only a warning and nothing has been altered as you do not have 'Remove surplus qualifiers' set in the options.

The column (x) contained additional qualifiers at the end that have been removed.

This means if a column is read in like this:

"some data"", 2, "some more" it will be converted to this "some data", 2, "some more"

This only occurs if the 'Remove surplus qualifiers' is set in the options.

The column (x) contained additional qualifiers at the end.

This means a column has been identified to look something like this:

"some data"", 2, "some more"

It is only a warning and nothing has been altered as you do not have 'Remove surplus qualifiers' set in the options.

This row has been padded with empty columns because only x columns were found instead of y. You will need to manually move data around to correct his row

The first row of a file is what determines the number of columns the process expects to find on every row. If there are less columns than expected on a subsequent row it is simply padded out to the correct amount with blank columns. The warning highlights to you the rows that may have issues with their structure that CSV Easy could not rectify automatically. In most cases a simple cut and past is all that is required to shift the contents around. Sometimes a system may export text data files in this way.

This row has been truncated because x columns were found instead of y. All of the additional data has been added to the end of the last column.You will need to manually move data around to correct his row

The first row of a file is what determines the number of columns the process expects to find on every row. If there are more columns than expected on a subsequent row these additional columns are concatenated together and placed in the last column. The warning highlights to you the rows that may have issues with their structure that CSV Easy could not rectify automatically. In most cases a simple cut and past is all that is required to shift the contents around.

The header row contains warnings. It is recommended you stop this process and load again with 'First row contains column header' unchecked.

As it is not possible to show warnings for the header row once a file is loaded this warning tells you that the header row has potentially some issues and that it might be worth loading the file without the first row as a header. This way you can see the warnings and establish if they are serious or not.

The header row does not have a standard windows line break. This can be easily fixed when saving and won't effect the loading of the file.

A simple warning that the header row does not terminate with a standard windows line break. As CSV Easy can change this when saving this is just a non-serious warning, but you may want to stop processing if this is not the desired format you expected.