Client gave me 3 lists to merge. Two worked. The third is giving me unbound namespace prefix error. The first time I tried to open this particular file I got a warning that it wasn't mac compatible and will open as read-only. I got it open, copied and pasted into a new doc. But whenever I try to merge I get the namespace error. I did a google search and it said there can't be any colons or parenthesis in the data field. Far as I could determine doing a search there aren't any. Any help appreciated. Thx.
First thing I do--because I inherently do not trust clients--is to open merge lists in Excel or LibreOffice, then export them out as tab-delimeted files. As long as Excel opens them and the data is where it ought to be, this usually fixes encoding errors that can come in depending upon what last had them open and were saved from.