Latitude and Longitude DMS 2D Point Replacer

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