[Qgis-user] [QGIS-user] Convert r.report output from txt to csv/xls

[Nicolas Cadieux]

Hi again,

If you ever want to use python, I have a python script that uses Gdal info to create .csv.  If you need it, I could put it on my gitlab page.

Nicolas Cadieux
https://gitlab.com/njacadieux

> Le 18 janv. 2022 à 19:40, Nicolas Cadieux <njacadieux.gitlab at gmail.com> a écrit :
> 
> Hi,
> The r.report is a rather complicated text file that contains a lot of characters made for improving the look of the output.  On way could be to python your way thought it so that is can find your way to the proper information.  This would save time if you have lots of files. 
> 
> The faster way, if you don’t program is to use a mixture of notepad++ along with excel or open office.  You can easily remove all useless characters like and replace them by no string or with a “,”.  Then you can import in open office.  I like OpenOffice Calc for this because you can they is to merge multiple separation characters into one.  This could help with the imports.  For example, if you have “line 1…….data,data,data”, you could use both the dot and the comma as separators and the multiple dots would be merged as one unique separator.  
> 
> If you have multiple files, you could use concatenation to make one big .csv file.  For windows, use the example could here. https://superuser.com/questions/111825/a-command-line-or-batch-cmd-to-concatenate-multiple-files
> 
> Hope this helps.  This by the way is an excellent way to start learning Python programming.  Python has easy of way to read and write.txt file and multiple way to manipulate text strings.  Great project if you have the time to learn.
> 
> Nicolas Cadieux
> https://gitlab.com/njacadieux
> 
>>> Le 18 janv. 2022 à 19:18, Igor Oliveira Ribeiro <igorgeoinformacao at gmail.com> a écrit :
>>> 
>> 
>> Hi, 
>> I have been using qgis version 3.10 and 3.16. I've been using the r.report tool to extract some data from a raster. Currently, the report is generated from r.report in *.txt format. I would like to know if it is possible to convert this format to csv/xls, within QGIS?
>> 
>> -- 
>> 
>> See our last paper: 
>> Impact of biomass burning on a metropolitan area in the Amazon during the 2015 El Niño: The enhancement of carbon monoxide and levoglucosan concentrations.
>> 
>> Igor Oliveira Ribeiro
>> Post-Doc on Regional Climate Change, Vulnerability, Impacts and Adaptation - Cuomo Foundation/UEA
>> 
>> +55 92 98103 7136 | skype: igorflorestal
>> 
>> Universidade do Estado do Amazonas | Instituto Nacional de Pesquisas da Amazônia
>> 
>> Visite: www.geoescrita.com.br
>> 
>> 
>> Think globally, act locally!
>> _______________________________________________
>> Qgis-user mailing list
>> Qgis-user at lists.osgeo.org
>> List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
>> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20220118/3fdd9da1/attachment.html>