Help with SQL conversion script
Posted: Wed Jul 12, 2006 12:26 pm
I need to be able to import a list of coordinates into a mysql database or some other readable format. The file is in the form of:
If anybody knows a way I could take this data (which is truncated... it's actually thousands and thousands of coordinates) and convert it to a more readable format, that would be great. Point me in the right direction.
Code: Select all
1 -0.122525406135743E+03 0.416390259938272E+02
-0.123230762000000E+03 0.420038450000000E+02
-0.123192361000000E+03 0.420054460000000E+02
-0.123154908000000E+03 0.420080360000000E+02
-0.123145959000000E+03 0.420092470000000E+02
-0.123083956000000E+03 0.420054480000000E+02
-0.123065655000000E+03 0.420049480000000E+02
-0.123045254000000E+03 0.420030490000000E+02
-0.122941597000000E+03 0.420030850000000E+02
-0.122893961000000E+03 0.420026050000000E+02
-0.122876148000000E+03 0.420032470000000E+02
-0.122870315059246E+03 0.420033101848239E+02
END
2 -0.122525406135743E+03 0.416390259938272E+02
-0.123230762000000E+03 0.420038450000000E+02
-0.123192361000000E+03 0.420054460000000E+02
-0.123154908000000E+03 0.420080360000000E+02
-0.123145959000000E+03 0.420092470000000E+02
-0.123083956000000E+03 0.420054480000000E+02
-0.123065655000000E+03 0.420049480000000E+02
-0.123045254000000E+03 0.420030490000000E+02
-0.122941597000000E+03 0.420030850000000E+02
-0.122893961000000E+03 0.420026050000000E+02
-0.122876148000000E+03 0.420032470000000E+02
-0.122870315059246E+03 0.420033101848239E+02
END