<div dir="auto"><div>Nicolás, Igor and list,<br><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Tue, Jan 18, 2022, 16:40 Nicolas Cadieux <<a href="mailto:njacadieux.gitlab@gmail.com">njacadieux.gitlab@gmail.com</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="auto">Hi,<div>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. </div></div></blockquote></div></div><div dir="auto"><br></div><div dir="auto">Or if you have to process the same file many times because your data is evolving.</div><div dir="auto"><div class="gmail_quote"><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="auto"><div><br></div><div>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.  </div></div></blockquote></div></div><div dir="auto"><br></div><div dir="auto">Or not... If your decimal points are dots.</div><div dir="auto"><div class="gmail_quote"><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="auto"><div><br></div><div>If you have multiple files, you could use concatenation to make one big .csv file.  For windows, use the example could here. <a href="https://superuser.com/questions/111825/a-command-line-or-batch-cmd-to-concatenate-multiple-files" target="_blank" rel="noreferrer">https://superuser.com/questions/111825/a-command-line-or-batch-cmd-to-concatenate-multiple-files</a></div><div><br></div><div>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.</div></div></blockquote></div></div><div dir="auto"><br></div><div dir="auto">I have to transform data files like this quite often.</div><div dir="auto"><br></div><div dir="auto">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.</div><div dir="auto"><br></div><div dir="auto">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.</div><div dir="auto"><div class="gmail_quote"><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="auto"><div><br><div dir="ltr">Nicolas Cadieux<div><a href="https://gitlab.com/njacadieux" target="_blank" rel="noreferrer">https://gitlab.com/njacadieux</a></div></div><div dir="ltr"><br><blockquote type="cite">Le 18 janv. 2022 à 19:18, Igor Oliveira Ribeiro <<a href="mailto:igorgeoinformacao@gmail.com" target="_blank" rel="noreferrer">igorgeoinformacao@gmail.com</a>> a écrit :<br><br></blockquote></div><blockquote type="cite"><div dir="ltr"><div dir="ltr"><div class="gmail_default" style="font-family:arial,helvetica,sans-serif;font-size:small">Hi, </div><div class="gmail_default" style="font-family:arial,helvetica,sans-serif;font-size:small">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?<br></div><div><br></div>-- <br><div dir="ltr" data-smartmail="gmail_signature"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div><span><br><div dir="ltr" style="margin-left:0pt" align="left"><table style="border:none;border-collapse:collapse"><colgroup><col width="168"><col width="456"></colgroup><tbody><tr style="height:21pt"><td colspan="2" style="vertical-align:top;padding:5pt 5pt 5pt 5pt;overflow:hidden"><p dir="ltr" style="line-height:1.2;margin-top:0pt;margin-bottom:0pt"><a href="https://doi.org/10.1016/j.envpol.2020.114029" target="_blank" rel="noreferrer"><span style="font-size:8pt;font-family:Arial;color:rgb(39,78,19);font-weight:700;font-style:italic;vertical-align:baseline;white-space:pre-wrap">See our last paper: </span></a></p><p dir="ltr" style="line-height:1.2;margin-top:0pt;margin-bottom:0pt"><a href="https://doi.org/10.1016/j.envpol.2020.114029" target="_blank" rel="noreferrer"><span style="font-size:8pt;font-family:Arial;color:rgb(0,0,0);font-style:italic;vertical-align:baseline;white-space:pre-wrap">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.</span></a></p></td></tr><tr style="height:128.69726562500003pt"><td style="border-right:solid #38761d 3pt;vertical-align:top;padding:5pt 5pt 5pt 5pt;overflow:hidden"><p dir="ltr" style="line-height:1.2;margin-top:0pt;margin-bottom:0pt"><span style="font-size:11pt;font-family:Arial;color:rgb(0,0,0);background-color:transparent;vertical-align:baseline;white-space:pre-wrap"><span style="border:none;display:inline-block;overflow:hidden;width:146px;height:145px"><img src="https://lh5.googleusercontent.com/-bliIGlTBH64UHBAAns8Ubhxgih0cgNVZjNAWPkBZSkYIa-o9idb3Km_x571oZ3NL0nZVMvFmclRedyzJDfv00BMdZPjcKg4zD1y1yGGErKoPszFJuTRjvN_0fmLsa4Ah_2YTtxJ" width="146" height="145" style="margin-left:0px;margin-top:0px"></span></span></p></td><td style="border-left:solid #38761d 3pt;vertical-align:top;padding:5pt 5pt 5pt 5pt;overflow:hidden"><p dir="ltr" style="line-height:1.2;margin-top:0pt;margin-bottom:0pt"><span style="font-size:12pt;font-family:Georgia;color:rgb(56,118,29);background-color:transparent;font-weight:700;vertical-align:baseline;white-space:pre-wrap">Igor Oliveira Ribeiro</span></p><p dir="ltr" style="line-height:1.2;margin-top:0pt;margin-bottom:0pt"><span style="font-size:8pt;font-family:Georgia;color:rgb(0,0,0);font-style:italic;vertical-align:baseline;white-space:pre-wrap">Post-Doc on Regional Climate Change, Vulnerability, Impacts and Adaptation - Cuomo Foundation/UEA</span></p><br><p dir="ltr" style="line-height:1.2;margin-top:0pt;margin-bottom:0pt"><span style="font-size:8pt;font-family:Georgia;color:rgb(34,34,34);vertical-align:baseline;white-space:pre-wrap">+55 92 98103 7136 | skype: igorflorestal</span></p><br><p dir="ltr" style="line-height:1.2;margin-top:0pt;margin-bottom:0pt"><span style="font-size:8pt;font-family:Georgia;color:rgb(34,34,34);vertical-align:baseline;white-space:pre-wrap">Universidade do Estado do Amazonas | Instituto Nacional de Pesquisas da Amazônia</span></p><br><p dir="ltr" style="line-height:1.2;margin-top:0pt;margin-bottom:0pt"><span style="font-size:8pt;font-family:Georgia;color:rgb(34,34,34);vertical-align:baseline;white-space:pre-wrap">Visite: </span><a href="http://www.geoescrita.com.br" target="_blank" rel="noreferrer"><span style="font-size:8pt;font-family:Georgia;color:rgb(56,118,29);vertical-align:baseline;white-space:pre-wrap">www.geoescrita.com.br</span></a></p><br><p dir="ltr" style="line-height:1.2;margin-top:0pt;margin-bottom:0pt"><a href="https://www.linkedin.com/in/igoroliveiraribeiro/" target="_blank" rel="noreferrer"><span style="font-size:8pt;font-family:Georgia;color:rgb(17,85,204);vertical-align:baseline;white-space:pre-wrap"><span style="border:none;display:inline-block;overflow:hidden;width:27px;height:27px"><img src="https://lh4.googleusercontent.com/2py0KXy5JccNXFC-38-2TT9wnYCQAXMRBlM5H0eOS83jy2Sz-PUr9_1C57srnad478ma9o9_fAYHjUhFN7Hza3OOCSiFHFpboznBl1PpVLavbfnjGYoU1usFc0W8j9pS4VzAKwCV" width="27" height="27" style="margin-left:0px;margin-top:0px"></span></span></a><a href="https://www.instagram.com/geoescrita/" target="_blank" rel="noreferrer"><span style="font-size:8pt;font-family:Georgia;color:rgb(17,85,204);vertical-align:baseline;white-space:pre-wrap"><span style="border:none;display:inline-block;overflow:hidden;width:27px;height:27px"><img src="https://lh4.googleusercontent.com/-FUMJ4HbrYAwwTKB49CF6r39wVYnoWf1AD9ZLKvD6Z1Cu1yqyo8NRk-InWHOa34J87OHDcJcCstkC_khG2_jCc6qDGop64cV2F0OL-IZ1S3Jgf9SfxVF08U9xfx47ov24InhjsqE" width="27" height="27" style="margin-left:0px;margin-top:0px"></span></span></a><a href="https://www.researchgate.net/profile/Igor_Oliveira_Ribeiro" target="_blank" rel="noreferrer"><span style="font-size:8pt;font-family:Georgia;color:rgb(17,85,204);vertical-align:baseline;white-space:pre-wrap"><span style="border:none;display:inline-block;overflow:hidden;width:27px;height:27px"><img src="https://lh6.googleusercontent.com/ert1Bk_3idA2Vb4MK8Hd3B1p2vdcL52JrOmNjaGhhbS7caCNQiZwRKKX55B9pB7-3j2nPFttXJezhSxrHQeBpnEnpeD_CRjzBQgPo5hG5C68qhY1wRFMu0PDv9LbQ8iY8-K4bwIk" width="27" height="27" style="margin-left:0px;margin-top:0px"></span></span></a><a href="http://lattes.cnpq.br/3909691804095045" target="_blank" rel="noreferrer"><span style="font-size:8pt;font-family:Georgia;color:rgb(17,85,204);vertical-align:baseline;white-space:pre-wrap"><span style="border:none;display:inline-block;overflow:hidden;width:27px;height:27px"><img src="https://lh6.googleusercontent.com/z9emf1sj2DW-tYYJZ6Qkd3RxvB23DjQdH7bLcTDIv9zyi-XnZRAroZBc8OPJqQkDIvZJBpd7GCa-2ClAT2gT3ubJ4yZj1BA0-T8hGgBboms-kjpowUuhBQO4z4EcWDwF9w25FGiy" width="27" height="27" style="margin-left:0px;margin-top:0px"></span></span></a><a href="https://orcid.org/0000-0002-3529-0525" target="_blank" rel="noreferrer"><span style="font-size:8pt;font-family:Georgia;color:rgb(17,85,204);vertical-align:baseline;white-space:pre-wrap"><span style="border:none;display:inline-block;overflow:hidden;width:27px;height:27px"><img src="https://lh4.googleusercontent.com/fOmYAxdij-Q_UFG3dFFnhy_zegLQSPZcgxSE-l8u9XuSz6LvnUGItsmoPZL_GCcfoYF2yl9dqYGs3842AcozPLqY103OWAe1x-js_lNLXym1Wcde7j4r19_vICiJXP5xaE_-KPIL" width="27" height="27" style="margin-left:0px;margin-top:0px"></span></span></a><a href="https://www.geoescrita.com.br/" target="_blank" rel="noreferrer"><span style="font-size:8pt;font-family:Georgia;color:rgb(17,85,204);vertical-align:baseline;white-space:pre-wrap"><span style="border:none;display:inline-block;overflow:hidden;width:27px;height:27px"><img src="https://lh3.googleusercontent.com/H041znsV0LChyhfdBIDwXHwIh5BUG2TCmQYBSI1d4eF1NX80_T79MtdQqif3DHpBIDgzvXhuXDLc0l77eylJCPuW7jbalTIbVqBg-dm8S-JHOxZh458R0UX8SsJINhcqw7nG7_Pw" width="27" height="27" style="margin-left:0px;margin-top:0px"></span></span></a></p></td></tr><tr style="height:21pt"><td colspan="2" style="vertical-align:top;padding:5pt 5pt 5pt 5pt;overflow:hidden"><p dir="ltr" style="line-height:1.2;margin-top:0pt;margin-bottom:0pt"><span style="font-size:8pt;font-family:Georgia;color:rgb(39,78,19);font-style:italic;vertical-align:baseline;white-space:pre-wrap">Think globally, act locally!</span></p></td></tr></tbody></table></div></span></div><div></div></div></div></div></div></div></div></div></div></div></div></div>
<span>_______________________________________________</span><br><span>Qgis-user mailing list</span><br><span><a href="mailto:Qgis-user@lists.osgeo.org" target="_blank" rel="noreferrer">Qgis-user@lists.osgeo.org</a></span><br><span>List info: <a href="https://lists.osgeo.org/mailman/listinfo/qgis-user" target="_blank" rel="noreferrer">https://lists.osgeo.org/mailman/listinfo/qgis-user</a></span><br><span>Unsubscribe: <a href="https://lists.osgeo.org/mailman/listinfo/qgis-user" target="_blank" rel="noreferrer">https://lists.osgeo.org/mailman/listinfo/qgis-user</a></span><br></div></blockquote></div></div>_______________________________________________<br>
Qgis-user mailing list<br>
<a href="mailto:Qgis-user@lists.osgeo.org" target="_blank" rel="noreferrer">Qgis-user@lists.osgeo.org</a><br>
List info: <a href="https://lists.osgeo.org/mailman/listinfo/qgis-user" rel="noreferrer noreferrer" target="_blank">https://lists.osgeo.org/mailman/listinfo/qgis-user</a><br>
Unsubscribe: <a href="https://lists.osgeo.org/mailman/listinfo/qgis-user" rel="noreferrer noreferrer" target="_blank">https://lists.osgeo.org/mailman/listinfo/qgis-user</a><br>
</blockquote></div></div></div>