G
Guest
The following is two sample records in two fields of my db which has been
imported from excel, after being scanned into a ocr program:
KEY ADDRESS
1 aby street.......7h 192
2 aby street west.....5h 84
field 1 contains the obvious.
field 2 conrtains a street/road name, some useless dots, a grid reference,
and finally a page number, of which the grid ref can be found.
What i want to do is take the grid ref, and the page no out of the ADDRESS
field and put them into their own individual fields as follows.
KEY ADDRESS GRID PAGE
1 aby street 7h 192
2 aby street west 5h 84
I have 500 records on 100 pages to sort. If anyone can help, Thanks.
imported from excel, after being scanned into a ocr program:
KEY ADDRESS
1 aby street.......7h 192
2 aby street west.....5h 84
field 1 contains the obvious.
field 2 conrtains a street/road name, some useless dots, a grid reference,
and finally a page number, of which the grid ref can be found.
What i want to do is take the grid ref, and the page no out of the ADDRESS
field and put them into their own individual fields as follows.
KEY ADDRESS GRID PAGE
1 aby street 7h 192
2 aby street west 5h 84
I have 500 records on 100 pages to sort. If anyone can help, Thanks.