OK
Let me consider the DMS value has 02 digits each with the symbol of Deg. Min. and Sec. in between (e.g. 23d45m30sN).
The expression I have used is LAT_dd = VALUE(LEFT(<LAT_DMS>,<No. of characters> ) + MID(<LAT_DMS>,<Cursor Position>,<No. of characters>)/60 +MID (<LAT_DMS>,<Cursor Position>,<No. of characters>)/3600)
LEFT (23d45m30sN, 2) = 23
MID (23d45m30sN, 4, 2) = 45 ----> converted to deg. 45/60
MID(23d45m30sN, 7, 2) = 30 ----> Converted to deg. 30/3600
So the value would be 23+45/60+30/3600 = 23.758333
Ultimately, the VALUE function converts the result of the above expression into numeric.
NOTE: Few values had a different format. I had to change the cursor position/No. of Characters for these values
Think Location