I need to cut, strip out and rearrange a text string into 2 fields

E

efandango

How can I cut text fields in a query like the example below,

-0.132861,51.591273,0

where the first part up to the first comma becomes one field, and the second
part, excluding the last comma and trailing zero becomes two (new) seperate
fields


Lon: -0.132861
Lat: 51.591273


a sample list of typcial data that I have to change.

coordinates
-0.132861,51.591273,0
-0.116207,51.59672,0
-0.101489,51.599326,0
-0.112013,51.5948,0
-0.09749200000000001,51.593865,0
-0.09479799999999999,51.593184,0
-0.111989,51.603028,0
-0.120467,51.598811,0
 
J

Jeff Boyce

Take a look at Access HELP on the Left(), Mid(), and InStr() functions.

Generically, you'll use a query and these functions to tell Access to create
two new (output) fields, taking everything to the left of the first comma as
one and everything following the first comma as the other.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
E

efandango

Thanks Jeff, I'll take a look

Jeff Boyce said:
Take a look at Access HELP on the Left(), Mid(), and InStr() functions.

Generically, you'll use a query and these functions to tell Access to create
two new (output) fields, taking everything to the left of the first comma as
one and everything following the first comma as the other.

Regards

Jeff Boyce
Microsoft Office/Access MVP
Click to expand...
 
Top