[Qgis-user] how to split a single field into multiple fields with the field calculator?

Wed Dec 5 09:48:01 PST 2012

Hi, I would normally do this in excel and then use a join command, but I
have special characters in foreign languages in the attribute table I'd
like to preserve. So far I successfully preserved the special characters
when I exported the attribute table from QGIS and opened it in excel using
the proper character encoding (cp1252), but when I bring it back into QGIS
I can't get the characters to display using cp1252 or utf-8.

Can anyone inform me if there is a way to edit the attribute table in QGIS
and use the field calculator to split text from a single field into
multiple fields using a delimiter such as a comma? (ie address data)

a sample of the data I'm working with can be found here:
https://www.dropbox.com/s/g6etf02cdf7bx7l/test_data.zip

I'm on mac 10.8 using QGIS 1.8

much thanks,

-Chris

On Wed, Dec 5, 2012 at 5:26 AM, <qgis-user-request at lists.osgeo.org> wrote:

> Send Qgis-user mailing list submissions to
>         qgis-user at lists.osgeo.org
>
> To subscribe or unsubscribe via the World Wide Web, visit
>         http://lists.osgeo.org/mailman/listinfo/qgis-user
> or, via email, send a message with subject or body 'help' to
>         qgis-user-request at lists.osgeo.org
>
> You can reach the person managing the list at
>         qgis-user-owner at lists.osgeo.org
>
> When replying, please edit your Subject line so it is more specific
> than "Re: Contents of Qgis-user digest..."
>
>
> Today's Topics:
>
>    1.  R?ponse automatique (j.boutet at conservatoirepicardie.org)
>    2. ESA project using SEXTANTE (Victor Olaya)
>    3. Re: [Qgis-developer] Defining the SEXTANTE roadmap (Victor Olaya)
>    4. Re: [Qgis-developer] ESA project using SEXTANTE (Anita Graser)
>    5. Re: Defining the SEXTANTE roadmap (Bhaskaran)
>    6. Re: Defining the SEXTANTE roadmap (Victor Olaya)
>    7. Re: Defining the SEXTANTE roadmap (Andre Joost)
>    8. Problems with Sextante (Klammt, Anne)
>    9. Re: Defining the SEXTANTE roadmap (Ramon Andi?ach)
>
>
> ----------------------------------------------------------------------
>
> Message: 1
> Date: Tue, 4 Dec 2012 21:01:25 +0100 (CET)
> From: j.boutet at conservatoirepicardie.org
> To: qgis-user at lists.osgeo.org
> Subject: [Qgis-user]  R?ponse automatique
> Message-ID: <201212042001.qB4K1PPr013798 at albane6.nfrance.com>
> Content-Type: text; charset=ISO-8859-1
>
>
>
>
> Bonjour,
>
>
>
> Je serais en cong?s jusqu'au Jeudi 6 D?cembre.
>
> Pour des raisons d'urgence, vous pourrez me contacter par t?l?phone au 06
> 46 34 81 03.
>
>
>
> Cordialement,
>
>
>
> ------------------
>
>
>
> J?r?me Boutet
>
> Conservatoire d'espaces naturels de Picardie
>
> 1, place Ginkgo - village Oasis
>
> 80 044 AMIENS cedex
>
> t?l : 03 22 89 84 24
>
>
>
> > From: qgis-user-request at lists.osgeo.org
> > Subject: Qgis-user Digest, Vol 82, Issue 9
> > Date: Tue, 04 Dec 2012 12:00:16 -0800
>
>
>
> ------------------------------
>
> Message: 2
> Date: Tue, 4 Dec 2012 21:45:07 +0100
> From: Victor Olaya <volayaf at gmail.com>
> To: qgis-user <qgis-user at lists.osgeo.org>,      qgis-developer
>         <qgis-developer at lists.osgeo.org>
> Subject: [Qgis-user] ESA project using SEXTANTE
> Message-ID:
>         <CAJsc-7z3z16gXXFx97FCsr0AV=
> o2fWRc5sM3gbDwfn7ii5J8GA at mail.gmail.com>
> Content-Type: text/plain; charset=ISO-8859-1
>
> Hi all
>
> This mail is to tell you about the great work ESA is doing with
> SEXTANTE, They have contributed several important patches (thanks to
> Radoslaw Guzinski for his fantastic work!) and they use it for some of
> their projects, as it can be seen in this newsletter they recently
> published[1]. I think this is a very good case study, and as such it
> is of interest for the QGIS community.
>
> It seems that SEXTANTE is growing up, which will for sure be good for
> all of us and will help us have a robust and table version pretty
> soon. Thanks to everyone for you collaboration!!
>
> Victor
>
> [1]http://tiger-net.org/uploads/media/TIGER-NET_D19_QN_Issue2.pdf
>
>
> ------------------------------
>
> Message: 3
> Date: Tue, 4 Dec 2012 21:53:34 +0100
> From: Victor Olaya <volayaf at gmail.com>
> To: rldhont <rldhont at gmail.com>
> Cc: qgis-user <qgis-user at lists.osgeo.org>,      qgis-developer
>         <qgis-developer at lists.osgeo.org>
> Subject: Re: [Qgis-user] [Qgis-developer] Defining the SEXTANTE
>         roadmap
> Message-ID:
>         <
> CAJsc-7wHbwNka4DLjwGbiquu10_h2GUoivPRgbib6ZizD72Ccg at mail.gmail.com>
> Content-Type: text/plain; charset=ISO-8859-1
>
> Hi all
>
> Thanks a lot for your ideas, there are definitely very good ones in here.
>
> I am going to try to put a detailed list of priorities and maybe some
> time estimations, so we can then focus our work more efficiently.
>
> As some of you mentioned that you have plans to work on these
> ideas,since they are of interest for you company/work/etc, (this is a
> great surprise!), I would just like to ask for some communication here
> in the list, so as to avoid duplicate work. For instance, support for
> databases as inputs and outputs was already on my priorities list. A
> good roadmap will help us divide the work and advance faster.
>
> I cannot thank you all enough for you help. It is really exciting to
> see how people are using SEXTANTE and helping us to push it forward.
>
> Thanks!
>
>
> 2012/12/4 rldhont <rldhont at gmail.com>:
> > Hi Victor, hi all,
> >>
> >> Let's start with the second point.... How do you think we should spend
> >> this money on SEXTANTE?
> >
> >
> > I think the first point is to fixed bugs, the second like Vincent
> Picavet is
> > Making sextante totally independant of qgis GUI, to be able to run
> sextante
> > processes in batch in command line mode.
> >
> > We, at 3Liz, could spend some time on SEXTANTE and find fund to improve
> > SEXTANTE. Some of our clients, mainly labs, can be insteresting in
> improving
> > SEXTANTE in QGIS, SEXTANTE has a command line or SEXTANTE as a WPS
> Server.
> >
> > Ren?-Luc
> > _______________________________________________
> > Qgis-developer mailing list
> > Qgis-developer at lists.osgeo.org
> > http://lists.osgeo.org/mailman/listinfo/qgis-developer
>
>
> ------------------------------
>
> Message: 4
> Date: Tue, 4 Dec 2012 22:05:36 +0100
> From: Anita Graser <anitagraser at gmx.at>
> To: qgis-user <qgis-user at lists.osgeo.org>,      qgis-developer
>         <qgis-developer at lists.osgeo.org>
> Subject: Re: [Qgis-user] [Qgis-developer] ESA project using SEXTANTE
> Message-ID:
>         <CAFFV8FjJY49WK3tuBE5Z0nnR2O8usqZ=
> iceqQY61mWaoZLsOuw at mail.gmail.com>
> Content-Type: text/plain; charset=ISO-8859-1
>
> On Tue, Dec 4, 2012 at 9:45 PM, Victor Olaya <volayaf at gmail.com> wrote:
> > Hi all
> >
> > This mail is to tell you about the great work ESA is doing with
> > SEXTANTE,
>
> Thanks for sharing Victor! It's really valuable to have reports like
> this strengthening the reputation of QGIS and SEXTANTE.
>
> Best wishes,
> Anita
>
>
> ------------------------------
>
> Message: 5
> Date: Tue, 4 Dec 2012 21:37:06 +0000
> From: Bhaskaran <bbkaran at gmail.com>
> To: Pirmin Kalberer <pi_ml at sourcepole.com>
> Cc: "qgis-user at lists.osgeo.org" <qgis-user at lists.osgeo.org>,
>         qgis-developer <qgis-developer at lists.osgeo.org>
> Subject: Re: [Qgis-user] Defining the SEXTANTE roadmap
> Message-ID:
>         <CABqZb7c3sB_MzRZ10y=uzDouQ_w=pMv1DPxffgo2Gh83mx=
> Few at mail.gmail.com>
> Content-Type: text/plain; charset="iso-8859-1"
>
> My top three priorities are:
>
> 1) Documentation
> 2) Documentation
> 3) Documentation
>
> I am sure there are other things to develop. However, at the moment the
> knowledge of Sextante and QGIS is with a few users/developers. Majority of
> the users struggle for a while and move on to use commercial apps. So let
> us have a propoer documentation so that the exisiting featues can be fully
> exploited.
>
> bbkaran
>
>
>
> On 3 December 2012 12:40, Pirmin Kalberer <pi_ml at sourcepole.com> wrote:
>
> > Hi Victor
> >
> > Am Freitag, 30. November 2012, 23.52:20 schrieb Victor Olaya:
> > [.....]
> > >
> > > Let's start with the second point.... How do you think we should spend
> > > this money on SEXTANTE?
> > >
> >
> > My personal priority list:
> > 1. Reanimate Python code export
> > 2. Support for database tables as input and output types
> > This would be the starting point for implementing import and export
> > workflows
> > with SEXTANTE.
> > 3. Support for spatialite as an intermediate format
> > No more troubles with long layer names!
> > 4. PostGIS algorithm collection
> > 5. Merging history/log window with QGIS protocol windows
> >
> > Regards
> > Pirmin
> >
> > --
> > Pirmin Kalberer
> > Sourcepole  -  Linux & Open Source Solutions
> > http://www.sourcepole.com
> >
> > _______________________________________________
> > Qgis-user mailing list
> > Qgis-user at lists.osgeo.org
> > http://lists.osgeo.org/mailman/listinfo/qgis-user
> >
> -------------- next part --------------
> An HTML attachment was scrubbed...
> URL: <
> http://lists.osgeo.org/pipermail/qgis-user/attachments/20121204/a94dc24c/attachment-0001.html
> >
>
> ------------------------------
>
> Message: 6
> Date: Tue, 4 Dec 2012 22:56:28 +0100
> From: Victor Olaya <volayaf at gmail.com>
> To: Bhaskaran <bbkaran at gmail.com>
> Cc: "qgis-user at lists.osgeo.org" <qgis-user at lists.osgeo.org>,
>         qgis-developer <qgis-developer at lists.osgeo.org>
> Subject: Re: [Qgis-user] Defining the SEXTANTE roadmap
> Message-ID:
>         <
> CAJsc-7yJstFKexQQKUZQTUzdz1TMCsuwbJihZXAWKb3jiSsnqQ at mail.gmail.com>
> Content-Type: text/plain; charset=ISO-8859-1
>
> Many people mention documentation. As I said, we are interested in
> documenting how to develop with SEXTANTE, which is a great priority in
> order to keep the project alive.
>
> However, I guess most people are talking about user documentation. Do
> you mean algorithm documentation? Documentation about the SEXTANTE
> framework itself?
>
> GRASS algorithms are all fully documented, since we use the original
> GRASS docs. SAGA ones are not... That is clearly a huge amount of
> work, probably beyond what can be achieved in the short- or mid-term,
> but suggestions about this topic are welcome. Other SEXTANTE documents
> not related to analysis algorithms are more comprehensive and closer
> to completion...
>
> Thanks in advance
>
>
>
> 2012/12/4 Bhaskaran <bbkaran at gmail.com>:
> > My top three priorities are:
> >
> > 1) Documentation
> > 2) Documentation
> > 3) Documentation
> >
> > I am sure there are other things to develop. However, at the moment the
> > knowledge of Sextante and QGIS is with a few users/developers. Majority
> of
> > the users struggle for a while and move on to use commercial apps. So
> let us
> > have a propoer documentation so that the exisiting featues can be fully
> > exploited.
> >
> > bbkaran
> >
> >
> >
> > On 3 December 2012 12:40, Pirmin Kalberer <pi_ml at sourcepole.com> wrote:
> >>
> >> Hi Victor
> >>
> >> Am Freitag, 30. November 2012, 23.52:20 schrieb Victor Olaya:
> >> [.....]
> >> >
> >> > Let's start with the second point.... How do you think we should spend
> >> > this money on SEXTANTE?
> >> >
> >>
> >> My personal priority list:
> >> 1. Reanimate Python code export
> >> 2. Support for database tables as input and output types
> >> This would be the starting point for implementing import and export
> >> workflows
> >> with SEXTANTE.
> >> 3. Support for spatialite as an intermediate format
> >> No more troubles with long layer names!
> >> 4. PostGIS algorithm collection
> >> 5. Merging history/log window with QGIS protocol windows
> >>
> >> Regards
> >> Pirmin
> >>
> >> --
> >> Pirmin Kalberer
> >> Sourcepole  -  Linux & Open Source Solutions
> >> http://www.sourcepole.com
> >>
> >> _______________________________________________
> >> Qgis-user mailing list
> >> Qgis-user at lists.osgeo.org
> >> http://lists.osgeo.org/mailman/listinfo/qgis-user
> >
> >
> >
> > _______________________________________________
> > Qgis-user mailing list
> > Qgis-user at lists.osgeo.org
> > http://lists.osgeo.org/mailman/listinfo/qgis-user
> >
>
>
> ------------------------------
>
> Message: 7
> Date: Wed, 05 Dec 2012 12:32:55 +0100
> From: Andre Joost <andre+joost at nurfuerspam.de>
> To: qgis-user at lists.osgeo.org
> Subject: Re: [Qgis-user] Defining the SEXTANTE roadmap
> Message-ID: <k9nbgt$hbg$1 at ger.gmane.org>
> Content-Type: text/plain; charset=ISO-8859-1; format=flowed
>
> Am 04.12.12 22:56, schrieb Victor Olaya:
> > Many people mention documentation. As I said, we are interested in
> > documenting how to develop with SEXTANTE, which is a great priority in
> > order to keep the project alive.
> >
> > However, I guess most people are talking about user documentation. Do
> > you mean algorithm documentation? Documentation about the SEXTANTE
> > framework itself?
> >
> > GRASS algorithms are all fully documented, since we use the original
> > GRASS docs. SAGA ones are not... That is clearly a huge amount of
> > work, probably beyond what can be achieved in the short- or mid-term,
> > but suggestions about this topic are welcome.
>
>  From the user side, a sophisticated algorithm is useless if he does not
> know what effect the parameters have. And if the user does not find any
> documentation or tutorial, he will not use it.
>
> And native language documentations are most wellcomed.
>
> Greetings,
> Andr? Joost
>
>
>
> ------------------------------
>
> Message: 8
> Date: Wed, 5 Dec 2012 13:25:12 +0100
> From: "Klammt, Anne" <aklammt at gwdg.de>
> To: <qgis-user at lists.osgeo.org>
> Subject: [Qgis-user] Problems with Sextante
> Message-ID:
>         <A16FFF7E05AEF74780F6A7BB2E6CEE2C02826E37 at VS1.exc.top.gwdg.de>
> Content-Type: text/plain;       charset="iso-8859-1"
>
> Hello,
> I've got problems to install Sextante. I received a message that " 'module'
> object has no attribute 'admintools'"
>
> What to do about this?
>
> Thanks a lot
>
>
> ------------------------------
>
> Message: 9
> Date: Wed, 5 Dec 2012 21:26:34 +0800
> From: Ramon Andi?ach <custard at westnet.com.au>
> To: Andre Joost <andre+joost at nurfuerspam.de>
> Cc: qgis-user at lists.osgeo.org
> Subject: Re: [Qgis-user] Defining the SEXTANTE roadmap
> Message-ID: <074E0AF5-E9A8-4455-A300-0CA418D9360F at westnet.com.au>
> Content-Type: text/plain; charset=iso-8859-1
>
>
> On 05/12/2012, at 19:32 , Andre Joost wrote:
>
> > Am 04.12.12 22:56, schrieb Victor Olaya:
> >> Many people mention documentation. As I said, we are interested in
> >> documenting how to develop with SEXTANTE, which is a great priority in
> >> order to keep the project alive.
> >>
> >> However, I guess most people are talking about user documentation. Do
> >> you mean algorithm documentation? Documentation about the SEXTANTE
> >> framework itself?
> >>
> >> GRASS algorithms are all fully documented, since we use the original
> >> GRASS docs. SAGA ones are not... That is clearly a huge amount of
> >> work, probably beyond what can be achieved in the short- or mid-term,
> >> but suggestions about this topic are welcome.
> >
> > From the user side, a sophisticated algorithm is useless if he does not
> know what effect the parameters have. And if the user does not find any
> documentation or tutorial, he will not use it.
> >
> > And native language documentations are most wellcomed.
>
> In support of Andr?'s comments, this is a large part of why I've haven't
> really dived into Sextante.
>
> (Time is the next one.)
>
> -ramon.
>
> ------------------------------
>
> _______________________________________________
> Qgis-user mailing list
> Qgis-user at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/qgis-user
>
>
> End of Qgis-user Digest, Vol 82, Issue 10
> *****************************************
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20121205/861ae669/attachment.html>