Morning
I have a lot of Lat and Long Coordinates that I need to split out into two columns.
I have been relatively successful on a lot of them, but in an amongst my 18000 entries, I have a lot that either have commas in them or the minus is missing from them.
Here is a sample of the data:
As you can see, not all the numbers are the same length, some have commas directly after the number and some have spaces etc
Is there a quick and easy way to resolve this ?
Iain
40.01176, -80.69182
40.026388, -80.696412
37.786128, -80.305247
37.8153, -80.277249
37.818768, -80.289182
37.80523, -80.300014
39.40316, -80.176399
38.435458, -81.852854
39.40267,-79.593484
38.220421,-80.54198
39.25656,-81.553859
38.406401,-82.31429
37.818768,-80.28918
37.868925,-82.17912
38.29905,-82.444152
42.75749 ,-110.9333
44.41403 ,-108.0503
44.35487 ,-106.7049
42.820198,-106.2660
42.826987,-106.3171
42.821196,-106.4024
41.162322,-104.8310
41.160686,-104.8421
41.149008,-104.7794
44.515116,-109.0712
I have a lot of Lat and Long Coordinates that I need to split out into two columns.
I have been relatively successful on a lot of them, but in an amongst my 18000 entries, I have a lot that either have commas in them or the minus is missing from them.
Here is a sample of the data:
As you can see, not all the numbers are the same length, some have commas directly after the number and some have spaces etc
Is there a quick and easy way to resolve this ?
Iain
40.01176, -80.69182
40.026388, -80.696412
37.786128, -80.305247
37.8153, -80.277249
37.818768, -80.289182
37.80523, -80.300014
39.40316, -80.176399
38.435458, -81.852854
39.40267,-79.593484
38.220421,-80.54198
39.25656,-81.553859
38.406401,-82.31429
37.818768,-80.28918
37.868925,-82.17912
38.29905,-82.444152
42.75749 ,-110.9333
44.41403 ,-108.0503
44.35487 ,-106.7049
42.820198,-106.2660
42.826987,-106.3171
42.821196,-106.4024
41.162322,-104.8310
41.160686,-104.8421
41.149008,-104.7794
44.515116,-109.0712
