Just a question, given the discussion here. Shouldn't such a report be generated in a structured format like YAML/JSON/XML for easier parsing? Would this merit an enhancement request? Ari
On Tue, Jan 18, 2022 at 6:54 PM chris hermansen <[email protected]> wrote: > Nicolás, Igor and list, > > On Tue, Jan 18, 2022, 16:40 Nicolas Cadieux <[email protected]> > wrote: > >> 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. >> > > Or if you have to process the same file many times because your data is > evolving. > >> >> 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. >> > > Or not... If your decimal points are dots. > >> >> 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. >> > > I have to transform data files like this quite often. > > Generally whether using Python or another programming language, you want > to use regular expressions to match and transform text patterns. The > learning curve can be a bit steep but very worthwhile. > > On Unix / Linux there is a specialized language for this type of transform > called awk. It's probably available for Windows somewhere. The advantage of > awk is there is no programming overhead for reading and writing lines; the > awk programs are statements reacting to the input received from the file. > >> >> Nicolas Cadieux >> https://gitlab.com/njacadieux >> >> Le 18 janv. 2022 à 19:18, Igor Oliveira Ribeiro < >> [email protected]> 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: <https://doi.org/10.1016/j.envpol.2020.114029> >> >> 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. <https://doi.org/10.1016/j.envpol.2020.114029> >> >> 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 >> >> <https://www.linkedin.com/in/igoroliveiraribeiro/> >> <https://www.instagram.com/geoescrita/> >> <https://www.researchgate.net/profile/Igor_Oliveira_Ribeiro> >> <http://lattes.cnpq.br/3909691804095045> >> <https://orcid.org/0000-0002-3529-0525> <https://www.geoescrita.com.br/> >> >> Think globally, act locally! >> _______________________________________________ >> Qgis-user mailing list >> [email protected] >> List info: https://lists.osgeo.org/mailman/listinfo/qgis-user >> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user >> >> _______________________________________________ >> Qgis-user mailing list >> [email protected] >> List info: https://lists.osgeo.org/mailman/listinfo/qgis-user >> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user >> > _______________________________________________ > Qgis-user mailing list > [email protected] > List info: https://lists.osgeo.org/mailman/listinfo/qgis-user > Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user >
_______________________________________________ Qgis-user mailing list [email protected] List info: https://lists.osgeo.org/mailman/listinfo/qgis-user Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
