I have a dataset that has latitude and longitude listed as follows under the column name location_1:
(34.0545, -118.2499)
See I can remove the parenthesis and can able to move them into separate columns under normal circumstances, but I don't know how to make it work while dropping the first comma before the numbers.