[chirp_users] more trouble with CSV file

Jim Unroe
Wed Jan 16 10:50:35 PST 2019

On Wed, Jan 16, 2019 at 10:46 AM John Mehl <ke4egc at gmail.com> wrote:
> Glenn. I tried to load this file with chirp. It returned the error msg  "Column number mismatch on line xx",
>  where xx went 17 to 169. I continued and Chirp then displays lines 1-16, line 0 is not shown and 1-14 look ok. Lines 15 & 16 Blank entries, no freg or name the rest of the columns are filled in default.
> I believe The length is important to chirp... John

The length of the line is not important. The number of commas (,) is.
So from were the commas are missing at the end, the fields which
should be the data for the next memory are being put at the end of the
previous memory and every thing after that is in the wrong position.

Leaving the trailing commas off has been a known issue with excel. I
used to have a workaround when I used excel but I use Libre Office now
and don't remember for sure what the workaround was. I believe that if
you populate the "RPT2CALL" column, then excel will put in the
previous commas as expected. Since the "RPT2CALL" is a cell that
normally populated with text, I believe what I may have done was to
enter double quotes ("") or possibly a space surrounded by double
quotes (" ") to make sure the trailing commas were always there.


More information about the chirp_users mailing list