[Qgis-user] combine field calculator functions

[Carlos Cerdán]

Hi Michael:

You can try Calc, from the LibreOffice suite. In this case it's a powerful
free software tool to open many kinds of formats, such *. DBF  without
issues.

There are installers for Mac OS also in http://www.libreoffice.org . Try
it! perhaps you find it very useful.

Carlos
(QGIS 1.8 on Ubuntu 12.04)


2013/8/6 Michael Giebels <giebels at meo-carbon.com>

>  Hi Carlos,
>
> thanks for your input. I tried this before. However I am not able to open
> *.dbf tables in Excel. It appears not to be readable in a suitable form
> (Yes, I do go the way over right click, show all files, open, and define
> seperators etc.). Somehow Excel does not read the row break properly (when
> I try to import the pure data without the header it tries to show all data
> in the first row and aborts due to limited number of columns in Excel). I
> tried different file origins (MacIntosh, Windows, DOS) as well. In a German
> forum I found information that Microsoft does not support *.dbf files
> anymore for Excel 2010 or higher which might explain that issue.
>
> Btw: I am running QGIS 1.8 on a Mac OS X Version 10.7.5 (whom ever this
> information helps) with MS Excel for Mac2011 Version 14.3.6 on it.
>
> I mentioned it before to Nathan already. All I want to do in the end is to
> convert six categories so I can display them in differing colors without
> creating new layers. But that is the way I have to do it in the end I
> guess.
>
> Thanks for your replies and thanks for having me in the community
>
> Michael
>
>
> Am 06.08.13 15:24, schrieb Carlos Cerdán:
>
>   ... or perhaps you can:
>
> 0. Add the new column, acording type od data and length and... save and
> close QGIS (no data added).
> 1. Open the *.DBF table with LibreOffice Calc or MS Excel, to take
> advantage of their functions
> 2.  Calc-Excel formulas would be taken as text, so you have to overwrite
> them with their own results
> 3.  Save (as *.DBF).
> 4. Open the shape in QGIS. It will have the new data.
>  5. An "advanced" step 2 is add new columns directly in Calc/Excel. For
> that, watch the headers: they have: name_of_camp , type_of_data , lenght
>
>  Good luck
>
>  Carlos Cerdán
>
>
>
>
> 2013/8/6 Nathan Woodrow <madmanwoo at gmail.com>
>
>> Hey Micheal,
>>
>>  This is currently not possible.  If you are running QGIS 1.9 you do
>> have the ability to define your own functions using Python example here
>> https://github.com/NathanW2/qgsexpressionsplus/blob/master/functions.py however
>> if you are new to Python and QGIS this isn't something I would do right
>> away.
>>
>>  - Nathan
>>
>>
>>  On Tue, Aug 6, 2013 at 9:38 PM, Michael Giebels <giebels at meo-carbon.com>wrote:
>>
>>>   Hello QGIS users,
>>>
>>> the QGIS world is new to me, so please be gentle...
>>>
>>> I am wondering how I could combine field calculator functions in order
>>> to convert information from an existing data column into a new one.
>>> What I can do with my mediocre knowledge is to query information from
>>> column 1 by setting
>>>
>>> "column1"='abc'
>>>
>>> which gives me a binary result (0,1) in my resulting column. Then I can
>>>
>>> replace ("newcolumn",'1','6')
>>>
>>> How could I combine these two into one working function (i.e. there MUST
>>> be a simple expression in the function list) and do not lose the new number
>>> when querying another information (e.g. 'cba') from column 1?
>>>
>>> Thanks in advance!
>>>
>>> Michael
>>>
>>>
>>>  _______________________________________________
>>> 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
>>
>>
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20130806/7814e1c5/attachment.html>