<html><head><base href="x-msg://37/"></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; "><div>FWIW - PostGIS uses long lat format...</div><div><br></div>If you are confident about the data consistency, this should be a pretty straightforward task - if you are not sure, it might still be quite simple if you are prepared to look into the mystical world of regular expressions. PostgreSQL offers support for these on the previously recommended string expressions page, but you will also need to look at the pattern matching page.<div><br></div><div>If you haven't ever looked at regular expressions, there are a number of very good resources available on the web. They are annoyingly useful, so worth investing some time in learning about them.</div><div><br></div><div>cheers</div><div><br></div><div>Ben</div><div><br></div><div><br><div><div>On 12/07/2011, at 8:58 PM, Yamini Singh wrote:</div><br class="Apple-interchange-newline"><blockquote type="cite"><span class="Apple-style-span" style="border-collapse: separate; font-family: Helvetica; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; font-size: medium; "><div class="hmmessage" style="font-size: 10pt; font-family: Tahoma; "><div dir="ltr"><div><div style="margin-top: 0.2in; margin-right: 0in; margin-bottom: 0.2in; margin-left: 0in; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; font-size: 10pt; font-family: Tahoma; line-height: normal; "><b><span style="font-size: 10pt; font-family: Verdana, sans-serif; color: rgb(102, 102, 102); ">Hi All,<o:p></o:p></span></b></div><div style="margin-top: 0.2in; margin-right: 0in; margin-bottom: 0.2in; margin-left: 0in; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; font-size: 10pt; font-family: Tahoma; line-height: normal; "><b><span style="font-size: 10pt; font-family: Verdana, sans-serif; color: rgb(102, 102, 102); "><br></span></b></div><div style="margin-top: 0.2in; margin-right: 0in; margin-bottom: 0.2in; margin-left: 0in; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; font-size: 10pt; font-family: Tahoma; line-height: normal; "><b><span style="font-size: 10pt; font-family: Verdana, sans-serif; color: rgb(102, 102, 102); ">I have a column 'geocode' in a table which has attributes like 2329/4727 now I would like to convert these </span></b><b style="text-indent: 0px !important; "><span style="text-indent: 0px !important; font-size: 10pt; font-family: Verdana, sans-serif; color: rgb(102, 102, 102); ">attributes </span></b><b><span style="font-size: 10pt; font-family: Verdana, sans-serif; color: rgb(102, 102, 102); ">in another column to 'lat' and 'long'. For example, 'Lat' column will have </span></b><b style="text-indent: 0px !important; "><span style="text-indent: 0px !important; font-size: 10pt; font-family: Verdana, sans-serif; color: rgb(102, 102, 102); ">attribute '</span></b><b><span style="font-size: 10pt; font-family: Verdana, sans-serif; color: rgb(102, 102, 102); ">23.29' and 'long' column will have </span></b><b style="text-indent: 0px !important; "><span style="text-indent: 0px !important; font-size: 10pt; font-family: Verdana, sans-serif; color: rgb(102, 102, 102); ">attribute </span></b><b><span style="font-size: 10pt; font-family: Verdana, sans-serif; color: rgb(102, 102, 102); "> '47.27'.</span></b></div><div style="margin-top: 0.2in; margin-right: 0in; margin-bottom: 0.2in; margin-left: 0in; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "><b><font class="Apple-style-span" color="#666666" face="Verdana, sans-serif" size="2">Is there a way through which this can be converted automatically by a query or so.<o:p></o:p></font></b></div><div style="margin-top: 0.2in; margin-right: 0in; margin-bottom: 0.2in; margin-left: 0in; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; font-size: 10pt; font-family: Tahoma; line-height: normal; "><b><span style="font-size: 10pt; font-family: Verdana, sans-serif; color: rgb(102, 102, 102); "><br></span></b></div><div style="margin-top: 0.2in; margin-right: 0in; margin-bottom: 0.2in; margin-left: 0in; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; font-size: 10pt; font-family: Tahoma; line-height: normal; "><b><span style="font-size: 10pt; font-family: Verdana, sans-serif; color: rgb(102, 102, 102); ">Looking fwd..</span></b></div><div style="margin-top: 0.2in; margin-right: 0in; margin-bottom: 0.2in; margin-left: 0in; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; font-size: 10pt; font-family: Tahoma; line-height: normal; "><b><span style="font-size: 10pt; font-family: Verdana, sans-serif; color: rgb(102, 102, 102); "><o:p> </o:p></span></b></div><div style="margin-top: 0.2in; margin-right: 0in; margin-bottom: 0.2in; margin-left: 0in; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; font-size: 10pt; font-family: Tahoma; line-height: normal; "><b><span style="font-size: 10pt; font-family: Verdana, sans-serif; color: rgb(102, 102, 102); ">Thanks<o:p></o:p></span></b></div><div style="margin-top: 0.2in; margin-right: 0in; margin-bottom: 0.2in; margin-left: 0in; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; font-size: 10pt; font-family: Tahoma; line-height: normal; "><b><span style="font-size: 10pt; font-family: Verdana, sans-serif; color: rgb(102, 102, 102); ">YJ<o:p></o:p></span></b></div></div></div>_______________________________________________<br>postgis-users mailing list<br><a href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a><br><a href="http://postgis.refractions.net/mailman/listinfo/postgis-users">http://postgis.refractions.net/mailman/listinfo/postgis-users</a><br></div></span></blockquote></div><br></div></body></html>