[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: Importing values and labels?
From: |
Karel Novotny |
Subject: |
Re: Importing values and labels? |
Date: |
Thu, 02 Sep 2010 13:24:46 -0300 |
On Wed, 2010-09-01 at 14:35 -0700, Ben Pfaff wrote:
> Karel Novotny <address@hidden> writes:
> > Is there a simple way of importing values from a csv or other file,
> > as opposed to typing them all up through the interface.
> > I have an excel sheet where cells in first row contain both values
> > and labels, with semi-colon separating individual values and a coma
> > between each value and its label.
>
> > They are many and I would be happy to be able to batch import them
> > somehow. Is it possible?
>
> I was going to suggest AUTORECODE, but it looks like it doesn't
> create value labels. I filed a bug about that.
>
> Short of that, I would suggest writing a script that transforms
> the CSV data into a series of VALUE LABELS or ADD VALUE LABELS
> commands.
I am throwing it here once more because I am realizing I have near 300
values which means a day of work at least.
If anyone has any suggestion about how to unify their syntax so I could
e.g. paste them into portable file (if not import properly), I would
appreciate it.
thanks
karel