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