<div dir="ltr">Hello, thank you very much, I am going to look for the function of separating the values of comma, in column. I have passed the file to csv format but in the same way the coordinates column remains united in a single field with X and Y and I can not plot it in QGIS, thanks.<br><div><br></div><div>Eddison</div></div><div class="gmail_extra"><br><div class="gmail_quote">2018-07-25 0:29 GMT-06:00 Lene Fischer <span dir="ltr"><<a href="mailto:lfi@ign.ku.dk" target="_blank">lfi@ign.ku.dk</a>></span>:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div lang="DA" link="blue" vlink="purple">
<div class="m_2959789243933919031WordSection1">
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Verdana","sans-serif"">Hi Eddison,<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:10.0pt;font-family:"Verdana","sans-serif"">Save the data as a .txt or .CSV file<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:10.0pt;font-family:"Verdana","sans-serif"">Open as Delimited Text and Choose Custom Delimiters. Then choose ‘Comma’<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:10.0pt;font-family:"Verdana","sans-serif"">Then you can add X and Y columns<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:10.0pt;font-family:"Verdana","sans-serif"">Regards<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:10.0pt;font-family:"Verdana","sans-serif""><u></u> <u></u></span></p>
<p class="MsoNormal" style="line-height:8.0pt"><span lang="EN-GB" style="font-size:7.5pt;font-family:"Verdana","sans-serif";color:gray"><u></u> <u></u></span></p>
<p class="MsoNormal" style="line-height:8.0pt"><b><span lang="EN-GB" style="font-size:7.5pt;font-family:"Verdana","sans-serif";color:gray">Lene Fischer<u></u><u></u></span></b></p>
<p class="MsoNormal" style="line-height:8.0pt"><span lang="EN-GB" style="font-size:7.5pt;font-family:"Verdana","sans-serif";color:gray">Associate Professor</span><span lang="EN-GB" style="font-size:7.5pt;font-family:"Verdana","sans-serif";color:black"><u></u><u></u></span></p>
<p class="MsoNormal" style="line-height:8.0pt"><span lang="EN-GB" style="font-size:7.5pt;font-family:"Verdana","sans-serif";color:gray"><u></u> <u></u></span></p>
<p class="MsoNormal" style="line-height:8.0pt"><b><span lang="EN-GB" style="font-size:7.5pt;font-family:"Verdana","sans-serif";color:gray">University of Copenhagen<u></u><u></u></span></b></p>
<p class="MsoNormal" style="line-height:8.0pt"><span lang="EN-GB" style="font-size:7.5pt;font-family:"Verdana","sans-serif";color:gray">Department of Geoscience and Natural Resource Management<u></u><u></u></span></p>
<p class="MsoNormal" style="line-height:8.0pt"><span lang="EN-GB" style="font-size:7.5pt;font-family:"Verdana","sans-serif";color:gray">Forest and Landscape College<u></u><u></u></span></p>
<p class="MsoNormal" style="line-height:8.0pt"><span lang="EN-GB" style="font-size:7.5pt;font-family:"Verdana","sans-serif";color:gray"><a href="https://maps.google.com/?q=N%C3%B8debovej+77a+%0D%0A+3480+Fredensborg+%0D%0A+Denmark&entry=gmail&source=g">Nødebovej 77a</a><u></u><u></u></span></p>
<p class="MsoNormal" style="line-height:8.0pt"><span style="font-size:7.5pt;font-family:"Verdana","sans-serif";color:gray"><a href="https://maps.google.com/?q=N%C3%B8debovej+77a+%0D%0A+3480+Fredensborg+%0D%0A+Denmark&entry=gmail&source=g">3480 Fredensborg</a><u></u><u></u></span></p>
<p class="MsoNormal" style="line-height:8.0pt"><span style="font-size:7.5pt;font-family:"Verdana","sans-serif";color:gray"><a href="https://maps.google.com/?q=N%C3%B8debovej+77a+%0D%0A+3480+Fredensborg+%0D%0A+Denmark&entry=gmail&source=g">Denmark</a><u></u><u></u></span></p>
<p class="MsoNormal" style="line-height:8.0pt"><span style="font-size:7.5pt;font-family:"Verdana","sans-serif";color:gray"><u></u> <u></u></span></p>
<p class="MsoNormal" style="line-height:8.0pt"><span style="font-size:7.5pt;font-family:"Verdana","sans-serif";color:gray"><u></u> <u></u></span></p>
<p class="MsoNormal" style="line-height:8.0pt"><span style="font-size:7.5pt;font-family:"Verdana","sans-serif";color:gray">MOB +45 40115084<u></u><u></u></span></p>
<p class="MsoNormal" style="line-height:8.0pt"><span lang="EN-GB" style="font-size:7.5pt;font-family:"Verdana","sans-serif";color:gray"><a href="mailto:lfi@ign.ku.dk" title="lfi@ign.ku.dk" target="_blank"><u><span lang="DA" style="color:gray;text-decoration:none">lfi@ign.ku.dk</span></u></a></span><span style="font-size:7.5pt;font-family:"Verdana","sans-serif";color:gray"><u></u><u></u></span></p>
<p class="MsoNormal" style="line-height:8.0pt"><span style="font-size:7.5pt;font-family:"Verdana","sans-serif";color:gray"><u></u> <u></u></span></p>
<p class="MsoNormal" style="line-height:8.0pt"><span style="font-size:7.5pt;font-family:"Verdana","sans-serif";color:gray"><u></u> <u></u></span></p>
<p class="MsoNormal" style="line-height:12.0pt"><span style="font-size:7.5pt;font-family:"Verdana","sans-serif";color:gray"><img border="0" width="320" height="122" id="m_2959789243933919031Picture_x0020_2" src="cid:image001.gif@01D423F1.A6638EE0"></span><span lang="EN-GB" style="font-size:7.5pt;font-family:"Verdana","sans-serif";color:gray">
<u></u><u></u></span></p>
<p class="MsoNormal" style="line-height:8.0pt"><span lang="EN-GB" style="font-size:7.5pt;font-family:"Verdana","sans-serif";color:gray"><u></u> <u></u></span></p>
<p class="MsoNormal"><a href="http://@Lene_Fischer" target="_blank"><span style="font-size:7.5pt;font-family:"Verdana","sans-serif";color:gray;text-decoration:none"><img border="0" width="25" height="25" id="m_2959789243933919031Picture_x0020_3" src="cid:image002.png@01D423F1.A6638EE0"></span></a><span style="font-size:7.5pt;font-family:"Verdana","sans-serif";color:gray">
<span lang="EN-GB"><u></u><u></u></span></span></p>
<p class="MsoNormal" style="line-height:8.0pt"><span lang="EN-GB" style="font-size:7.5pt;font-family:"Verdana","sans-serif";color:gray"><u></u> <u></u></span></p>
<p class="MsoNormal" style="line-height:8.0pt"><span lang="EN-GB" style="font-size:7.5pt;font-family:"Verdana","sans-serif";color:gray"><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Verdana","sans-serif""><u></u> <u></u></span></p>
<p class="MsoNormal"><b><span style="font-size:10.0pt;font-family:"Tahoma","sans-serif"">Fra:</span></b><span style="font-size:10.0pt;font-family:"Tahoma","sans-serif""> Qgis-user [mailto:<a href="mailto:qgis-user-bounces@lists.osgeo.org" target="_blank">qgis-user-bounces@<wbr>lists.osgeo.org</a>]
<b>På vegne af </b>Eddison Araya<br>
<b>Sendt:</b> 25. juli 2018 06:37<br>
<b>Til:</b> qgis-user<br>
<b>Emne:</b> [Qgis-user] Hoja de Excel generada por ODK<u></u><u></u></span></p><div><div class="h5">
<p class="MsoNormal"><u></u> <u></u></p>
<div>
<div>
<div>
<p class="MsoNormal"><br>
<span style="color:#212121;background:white">Hello, I used ODK Collector connected with Google Drive to perform field surveys.
</span><u></u><u></u></p>
<div>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
<div>
<div>
<p class="MsoNormal"><img border="0" width="625" height="104" id="m_2959789243933919031_x0000_i1025" src="cid:image003.png@01D423F1.A6638EE0"><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
<div>
<div>
<p class="MsoNormal">As you can see, the X and Y coordinates are contained in the same column when using the ODK Collector APP, connected to the Google Drive Sheet. How can I take that to QGIS? I have tried to use the function Add Layer of Delimited Text I
can not do it since the coordinates are in the same column.<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
<div>
<p class="MsoNormal">Thank you<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
<div>
<p class="MsoNormal">Eddison<u></u><u></u></p>
</div>
</div>
<div>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
<div>
<p class="MsoNormal">Gracias<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="color:#888888"><u></u> <u></u></span></p>
</div>
<div>
<p class="MsoNormal"><span style="color:#888888">Eddison<u></u><u></u></span></p>
</div>
</div>
</div>
</div>
</div>
</div></div></div>
</div>
</blockquote></div><br></div>