Complex CSV export part 2 - the attack of the spurrious invisible characters

John Scott qnaweb at provue.com
Mon Jul 21 03:17:09 PDT 2008


Thanks for the speedy assistance, doubly so on a Sunday (being self-employed, I understand the seven-day work week, but was surprised that I am not alone).

Slowly and steadily I am getting there, but have run into another strange phenomenon.
As part of my twisted report, I am getting some strange invisible characters at the (seemingly random) beginnings of some lines.  There are typically 1-3 of these characters  when they occur, always at the beginning of a line, but not at the beginning of every line.  When I do a grep from a copy and paste, Text Wrangler reports that the offending character is "/x00".

My form uses a normal carriage return from my apple keyboard as I have done with countless other forms without this result.

In a worst case scenario I can do a grep every time I need to upload my database, but I would prefer to understand and fix this.

Thanks again...

-John


More information about the Qna mailing list