Mailing List Archive: Importing .nsr output into Excel

Importing .nsr output into Excel

Aug 15, 2001, 11:35 AM

Post #1 of 3 (1998 views)

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

I'm sure this is addressed in the archives, but.... they're not available.
Apologies for what is likely a FAQ.

I've been able to take a whack at importing .nsr into Excel, but there are a
couple of problems. One is that the "|" delimiter is sometimes used in the
text fields, so Excel dutifully splits them into separate cells. Another is
that I'm an Excel newbie, so I am seeing a number of artifacts that I am not
able to describe or explain adequately.

Has anybody put together a worksheet template which knows what to do with the
.nsr data, and can I have a copy? :)

- ---
Computers hate being anthropomorphized.

-----BEGIN PGP SIGNATURE-----
Version: PGPfreeware 6.5.8 for non-commercial use <http://www.pgp.com>

iQA/AwUBO3rA+EksS4VV8BvHEQIy6QCg/hpMN5NqZ1dfihjrpqnQLaFmM7oAoK1a
FbdeCCQkXZ3cV6njwRmrAQg6
=S7/C
-----END PGP SIGNATURE-----

Re: Importing .nsr output into Excel [ In reply to ]

arboi at noos

Aug 17, 2001, 5:23 AM

Post #2 of 3 (1937 views)

Permalink

"Mike Batchelor" <mikebat@tmcs.net> writes:

> I'm sure this is addressed in the archives, but.... they're not
> available.
> Apologies for what is likely a FAQ.

Not so sure. Is there a FAQ, by the way?

> Has anybody put together a worksheet template which knows what to do with the
> .nsr data, and can I have a copy? :)

I just wrote this NSR to DIF converter. Maybe it's buggy. I just made
a small try with Star Office.

DIF = Data Interchange Format. Should be understood by any
spreadsheet.

In case you are running Zindoz, you'll have to install Perl first
(e.g. from Cygwin) , and open a DOS (or bash) window.

nsr2dif.pl < anything.nsr > something.dif

--
mailto:arboi@bigfoot.com http://www.bigfoot.com/~arboi/
GPG Public keys: http://www.bigfoot.com/~arboi/pubkey.txt
FAQNOPI de fr.comp.securite : http://www.bigfoot.com/~arboi/secu/FAQNOPI/

Re: Importing .nsr output into Excel [ In reply to ]

arboi at noos

Aug 17, 2001, 6:19 AM

Post #3 of 3 (1945 views)

Permalink

Michel Arboi <arboi@noos.fr> writes:

> Maybe it's buggy.

It *is* :-(
DIF format does not like LF inside strings.
I added one line and double check with Excel and Star Office, it looks
all right now.
BTW, under Windows (at least mine) *.dif are associated to "Quick
time". But there is no problem opening them with Excel.

I alsoput a copyright. I forgot how this may be important :)

Mailing List Archive

Attached Files:

Attached Files: