Skip to main content
Hi,

 

 

I'm a beginner to FME and I apologise if this seems like a basic or an obvious query.

 

I have an excel spread sheet and one of the columns contains the coordinates in a DMS format e.g. N51.48.27 W03.22.24. How would I create a point from this coordinate?

 

I’m familiar with 2DPointReplacer and I have used it before; so as a hunch, my next step was to split the coordinates into latitude (51.48.27) and longitude (-03.22.24) columns. However, these are still not recognised as an easting and northing format when using 2DPointReplacer.

 

 

 

Please can someone point me in the right direction? My ultimate goal is to create a .shp file in a British National Grid coordinate system.

 

 

 

Thanks

 

 

 

Shaun

 

Hi,

 

 

I think you will have to split each part of the values into three separate attributes ("51.48.27" -> "51", "48" and "27"), then use the DecimalDegreesCalculator transformer to get the lat/lon values for the 2DPointReplacer.

 

 

Look at the help for the DecimalDegreesCalculator for some hints on how to split the DMS string.

 

 

David
Thank you David! Spot on! That did the trick.

 

 

Shaun

Reply