Find the row that a line count misses
Suppose an import accepts one contact per file. The sample has a name column and a note column. Alpha’s note contains a comma. Beta’s note contains a line break between two and lines. Count the contacts in a CSV reader before splitting. A text editor shows an extra line in the middle of Beta’s record.
Keep the header with each contact
- In CSV Splitter, open the sample text or paste it unchanged. Choose comma as the delimiter and Records as the split mode.
- Set Amount to 1, enable Repeat header row and process the input. Download and unpack the ZIP. Its two parts are numbered in input order.
- Import part-001.csv and part-002.csv separately with the same delimiter. Each should show name and note, followed by exactly one contact.
Compare a split run with a one-file control
With one record per part, each unpacked file is 29 bytes. Alpha’s note reads one, two in one cell. Beta’s note retains the embedded newline. As a control, set Amount to 2. Now the single CSV is 47 bytes, versus 44 bytes for the original text. The writer uses CRLF between records and leaves the newline inside Beta’s cell alone. The two 29-byte figures refer to the CSVs inside the archive.
Handle a byte cap without breaking a note
In byte mode the repeated header consumes part of every file’s allowance. For this sample a 29-byte cap can hold either record with its header. A 28-byte cap fails because neither record fits intact. Increase the limit or revise the source with the data owner. If parsing fails before splitting, check the delimiter, paired quotation marks and field count in the source.