Re^2: Extracting coordinates

DER-71-14/05.16 4930.2800 -6590.5100 0.0000 
----------------^^^^^^^^^-^^^^^^^^^^---
[download]

I need to take these parts and put them into a database side by side (SQL). Sorry for the messy code, I've no idea how else I could do this (no previous programming experience, no knowledge).

I'd also like to have it done as fast as it can be done, that's why I tried to do such a regex. It would be best to do everything in one load (that is, calculate the 15 GB just once).

Thanks

Comment on Re^2: Extracting coordinates Download Code

Replies are listed 'Best First'.
Re^3: Extracting coordinates by moritz (Cardinal) on Mar 21, 2010 at 07:59 UTC
`my ($identifier, $coord1, $coord2) = split /\s+/, $line; # then you have $coord1 = '4930.2800', $coord2 = '-6590.5100'` [download]	[reply] [d/l]