Data selection from imported Values.

[John Lee]

Hi,
I have a table which holds some imported data. the data now needs to be
edited.
For example.
<option value="0601 "0650-128 MB DDR </option

The data required is 0650-128 MB DDR
There are about 12000 lines of data the same as this. Is it possible to
have a script extract this data and save it to a seperate table.

Hope you can help.

kind Regards

John

 

[Jeff Boyce]

John

A "script"? Not in Access.

A query, probably.

Are you absolutely certain that that the string you want to extract always
occurs after the second quote? Or always in the nth position in the string
(i.e., starts in column 23)?

You can use the Left(), Right(), Mid() and Instr() functions to return the
portion you wish to extract.

Regards

Jeff Boyce
Microsoft Office/Access MVP