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

[Guest]

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

 

[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

 

[Guest]

Thanks Jeff, I'll take a look

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