Pete F. wrote:I've had a quick look at my source spreadsheet in Excel to see if there's anything causing these extra tab characters to appear, but there doesn't appear to be...
The last cell in each record of my email database was a comments field which often had more than one line of text. In Excel it showed as square at the end of each line which appeared to be interpreted as a TAB by phplist, since the information got separated into different records with invalid emails when I imported.
I deleted all the squares I could find and saved the file again. There were still extra records created in phplist as invalid emails. The comments were still on several lines in one cell even though I'd deleted the squares so I guess the new line character was interpreted as a TAB on import.
By the way, it's a bugger when you save your data as .txt from Excel and subsequently want to edit it, you have to reimport it and then things like several lines in one cell get split. What I did was to save information as a csv file (except some formatting doesn't seem to be saved with it), edit it if necessary, and then when finally ok save it as txt before importing to phplist.