<HTML dir=ltr><HEAD>
<META http-equiv=Content-Type content="text/html; charset=unicode">
<META content="MSHTML 6.00.6000.16915" name=GENERATOR></HEAD>
<BODY>
<DIV id=idOWAReplyText81930 dir=ltr>
<DIV dir=ltr><FONT face="Times New Roman" color=#000000 size=3>Hello,</FONT></DIV>
<DIV dir=ltr>frankly, I never thought about the degree symbol and the ordinal symbol as different things, because I dont think I have ever used any program that needed to parse a DMS string typed by me.</DIV>
<DIV dir=ltr>I'll try to use ALT+0176 from now on :)</DIV>
<DIV dir=ltr> </DIV>
<DIV dir=ltr>Regards,</DIV>
<DIV dir=ltr><FONT face="Times New Roman" color=#000000 size=3></FONT> </DIV></DIV>
<DIV id=idSignature76808 dir=ltr>
<DIV><FONT face="Courier New" size=2><FONT face="Times New Roman" size=3>Juan Lucas Domínguez Rubio<BR></FONT>---</FONT></DIV>
<DIV><FONT face="Courier New" size=2><FONT face="Courier New" size=2><FONT face="Courier New" size=2>Prodevelop SL, Valencia (España)</FONT></DIV>
<DIV>
<DIV><FONT face="Courier New" size=2>Tlf.: 96.351.06.12 -- Fax: 96.351.09.68<BR></FONT><A href="http://www.prodevelop.es/"><FONT face="Courier New" size=2>http://www.prodevelop.es</FONT></A><BR><FONT face="Courier New" size=2>---</FONT></DIV></FONT></DIV></FONT></DIV>
<DIV dir=ltr><BR>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>De:</B> gvsig_internacional-bounces@listserv.gva.es en nombre de Da Kn<BR><B>Enviado el:</B> sáb 31/10/2009 13:12<BR><B>Para:</B> Users and Developers mailing list<BR><B>Asunto:</B> Re: [Gvsig_english] Importing Data in DMS form to gvSIG<BR></FONT><BR></DIV>
<DIV>Hi,<BR><BR>thanks so much, it's working perfectly, yes it's multi-language (at least with my german office 2007). thank you very much.<BR>just one question: you are using the <FONT face="Times New Roman" color=#000000 size=3>º symbol (ordinal indicator) for degree, not the degree symbol °, is this common because the degree symbol doesn't work with the international character set? </FONT>unfortunately even with the ordinal indicator gvSIG doesn't interpret the DMS form correctly. anway your tool solves the problems. thank you very much. (I think I finally have to learn some VBA now, it's very helpful)<BR><BR>thanks, greetings davk <BR><BR><BR>
<DIV class=gmail_quote>2009/10/30 Juan Lucas Dominguez Rubio <SPAN dir=ltr><<A href="mailto:jldominguez@prodevelop.es">jldominguez@prodevelop.es</A>></SPAN><BR>
<BLOCKQUOTE class=gmail_quote style="PADDING-LEFT: 1ex; MARGIN: 0pt 0pt 0pt 0.8ex; BORDER-LEFT: rgb(204,204,204) 1px solid">
<DIV>
<DIV dir=ltr>
<DIV dir=ltr><FONT face="Times New Roman" color=#000000 size=3>Hello,</FONT></DIV>
<DIV dir=ltr><FONT face="Times New Roman" color=#000000 size=3>You can use the Excel functions to parse the coordinate string. For example:</FONT></DIV>
<DIV dir=ltr> </DIV>
<DIV dir=ltr><FONT face="Times New Roman" color=#000000 size=3>45º35'12'' W</FONT></DIV>
<DIV dir=ltr> </DIV>
<DIV dir=ltr><FONT face="Times New Roman" color=#000000 size=3>You can use the function FIND to find the degrees symbol (º), minutes symbol (') and seconds symbol (''). Then you can use the EXTRACT function (or similar) to split the string, then the VALUE function (or similar) to convert those strings into numbers, then simply divide the minutes by 60 and the seconds by 3600 and sum them up. You can use the FIND symbol again to decide the hemisphere (if it contains a 'W' it's the western hemisphere, so the longitude must be negative, etc).</FONT></DIV>
<DIV dir=ltr> </DIV>
<DIV dir=ltr><FONT face="Times New Roman" color=#000000 size=3>I have attached an example in an Excel file (coord_parser.xls) to do this (also screenshot coord_parser.jpg). You ONLY have to change the yellow cells, the rest is automatic. The IND_* columns find the relevant symbols. The string is split in columns DEG, MIN, SEC. The result is in the DECIMAL DEGREES column, which uses the HEMISPEHERE column to find out the sign of the result.</FONT></DIV>
<DIV dir=ltr> </DIV>
<DIV dir=ltr><FONT face="Times New Roman" color=#000000 size=3>If you want to convert thousands of values, you only have to copy the formulas vertically and paste your values in the input column. </FONT><FONT face="Times New Roman" color=#000000 size=3>I hope the Excel format is multi-language, because I used the function names in Spanish.</FONT></DIV>
<DIV dir=ltr> </DIV>
<DIV dir=ltr><FONT face="Times New Roman" color=#000000 size=3>Is that what you were looking for?</FONT></DIV>
<DIV dir=ltr> </DIV>
<DIV dir=ltr><FONT face="Times New Roman" color=#000000 size=3>Regards,</FONT></DIV>
<DIV dir=ltr> </DIV>
<DIV dir=ltr><FONT face="Times New Roman" color=#000000 size=3></FONT> </DIV></DIV>
<DIV dir=ltr>
<DIV><FONT face="Courier New" size=2><FONT face="Times New Roman" size=3>Juan Lucas Domínguez Rubio<BR></FONT>---</FONT></DIV>
<DIV><FONT face="Courier New" size=2><FONT face="Courier New" size=2><FONT face="Courier New" size=2>Prodevelop SL, Valencia (España)</FONT></FONT></FONT></DIV>
<DIV>
<DIV><FONT face="Courier New" size=2>Tlf.: 96.351.06.12 -- Fax: 96.351.09.68<BR></FONT><A href="http://www.prodevelop.es/" target=_blank><FONT face="Courier New" size=2>http://www.prodevelop.es</FONT></A><BR><FONT face="Courier New" size=2>---</FONT></DIV></DIV></DIV>
<DIV dir=ltr><BR>
<HR>
<FONT face=Tahoma size=2><B>De:</B> <A href="mailto:gvsig_internacional-bounces@listserv.gva.es" target=_blank>gvsig_internacional-bounces@listserv.gva.es</A> en nombre de Da Kn<BR><B>Enviado el:</B> vie 30/10/2009 20:49<BR><B>Para:</B> <A href="mailto:gvsig_internacional@runas.cap.gva.es" target=_blank>gvsig_internacional@runas.cap.gva.es</A><BR><B>Asunto:</B> [Gvsig_english] Importing Data in DMS form to gvSIG<BR></FONT><BR></DIV>
<DIV>
<DIV></DIV>
<DIV class=h5>
<DIV>hello community, <BR><BR>i've already posted about this problem, so I'm sorry for this new one, but unfortunately the problem remains, perhaps I'm doing a silly error. <BR><BR>I've got an Excel table with XX°XX'XX'' data and trying to import it into gvSIG. projection should be WGS 84 (DMS), right? After adding the table UTF-8 (assigned via shalom), gvSIG only shows one point at 0°0'0'' to me, so the program can't read my data in XX°XX'XX'' form. How do I have to change the pattern of my data so that gvSIG will read it correctly? importing data in decimal degress works perfectly. <BR><BR>unfortunately I don't know another program which allows batch conversions for DMS to Decimal, which would solve the problem. There are plenty of single value converters which are perfect if one just wants to convert few coordinates.<BR><BR>I will be very thankful vor any suggestions. thank you. greetings davk <BR></DIV></DIV></DIV></DIV><BR>_______________________________________________<BR>Gvsig_internacional mailing list<BR><A href="mailto:Gvsig_internacional@listserv.gva.es">Gvsig_internacional@listserv.gva.es</A><BR><A href="http://listserv.gva.es/cgi-bin/mailman/listinfo/gvsig_internacional" target=_blank>http://listserv.gva.es/cgi-bin/mailman/listinfo/gvsig_internacional</A><BR><BR></BLOCKQUOTE></DIV><BR></DIV></BODY></HTML>