how cool! there were instructions for importingit into excell and I thought to myself that excell is merely a spreadsheet s I tried librecalc. badabing, bada-boom.... it opened it! :-)~MIKE~(-: On Thu, Jul 25, 2013 at 3:24 PM, wrote: > do: > sed -i -e 's/[[:space:]]*$//g' file-to-fix > To get rid of '^M'. > ET > > Michael Havens writes: > >> cool..... vi opens it. I do not see any '^@' characters but I see a lot of >> '^M' characters. I see a few '@' characters. So I do not need to worry >> about those characters.... only the non ascii ones? >> :-)~MIKE~(-: >> >> On Thu, Jul 25, 2013 at 2:42 PM, Paul Mooring wrote: >> >>> There's some null characters (look like ^@ in vim) in this file causing >>> your problem, run `file -I ` and you'll see it's charset is >>> binary. I found some null chars on line 155 (grep for non-ascii >>> characters >>> to find them). You can remove them with sed or tr and be on your happy >>> way. >>> >>> Paul Mooring >>> Operations Engineer >>> www.opscode.com >>> ------------------------------ >>> *From:* plug-discuss-bounces@lists.**phxlinux.org< >>> >>> plug-discuss-bounces@lists.**phxlinux.org> >>> on behalf of Michael Havens < >>> bmike1@gmail.com> >>> *Sent:* Thursday, July 25, 2013 2:09 PM >>> *To:* plug-discuss@phxlinux.org >>> *Subject:* I got a zip file from the government but it won't unzip >>> >>> properly >>> It seems to unzip fine but the document that opens freezes libre writer >>> and when I try to open it with a text editor it complains about >>> encoding. >>> here is the file: >>> https://www.dropbox.com/s/**q5x24uzhyrv3mo1/az-foiarefund-**list.zip >>> Any ideas how to open it? >>> :-)~MIKE~(-: >>> ------------------------------**--------------------- >>> PLUG-discuss mailing list - PLUG-discuss@lists.phxlinux.**org >>> To subscribe, unsubscribe, or to change your mail settings: >>> http://lists.phxlinux.org/**mailman/listinfo/plug-discuss >>> >> ------------------------------**--------------------- > PLUG-discuss mailing list - PLUG-discuss@lists.phxlinux.**org > To subscribe, unsubscribe, or to change your mail settings: > http://lists.phxlinux.org/**mailman/listinfo/plug-discuss >