[Gvsig_english] Importing Data in DMS form to gvSIG

[Da Kn]

Hi,

thanks so much, it's working perfectly, yes it's multi-language (at least
with my german office 2007).  thank you very much.
just one question: you are using the º symbol (ordinal indicator) for
degree, not the degree symbol °, is this common because the degree symbol
doesn't work with the international character set? 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)

thanks, greetings davk


2009/10/30 Juan Lucas Dominguez Rubio <jldominguez at prodevelop.es>

>  Hello,
> You can use the Excel functions to parse the coordinate string. For
> example:
>
> 45º35'12'' W
>
> 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).
>
> 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.
>
> If you want to convert thousands of values, you only have to copy the
> formulas vertically and paste your values in the input column. I hope the
> Excel format is multi-language, because I used the function names in
> Spanish.
>
> Is that what you were looking for?
>
> Regards,
>
>
>  Juan Lucas Domínguez Rubio
> ---
> Prodevelop SL, Valencia (España)
>  Tlf.: 96.351.06.12 -- Fax: 96.351.09.68
> http://www.prodevelop.es
> ---
>
> ------------------------------
> *De:* gvsig_internacional-bounces at listserv.gva.es en nombre de Da Kn
> *Enviado el:* vie 30/10/2009 20:49
> *Para:* gvsig_internacional at runas.cap.gva.es
> *Asunto:* [Gvsig_english] Importing Data in DMS form to gvSIG
>
> hello community,
>
> 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.
>
> 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.
>
> 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.
>
> I will be very thankful vor any suggestions. thank you. greetings davk
>
> _______________________________________________
> Gvsig_internacional mailing list
> Gvsig_internacional at listserv.gva.es
> http://listserv.gva.es/cgi-bin/mailman/listinfo/gvsig_internacional
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://listserv.gva.es/pipermail/gvsig_internacional/attachments/20091031/83bb4212/attachment.htm