Transferring text within quotation marks

[Lynette]

I have a field containing some text in "quotation marks". Would it be possible to transfer this text to a new field? I have many entries so a global operation is essential.

[ajetrumpet]

I have a field containing some text in "quotation marks". Would it be possible to transfer this text to a new field? I have many entries so a global operation is essential.

that's a pretty faint description. the basic answer is yes.

[weekend00]

He must want to ask: How?

[Lynette]

Am delighted that it is possible to transfer text in quotation marks to a new field globally. Please could you give some indication how this is done - if not too time consuming. I could get an IT person to do it for me.

[ajetrumpet]

Am delighted that it is possible to transfer text in quotation marks to a new field globally. Please could you give some indication how this is done - if not too time consuming. I could get an IT person to do it for me.

I'm inclined not to answer Lynette, because your lack of giving specifics is very frustrating. If you had:

"this is my text"

in a field "myfield", and you want to transfer it to the next field in the same table named "myfield2", you would write in a query:

update table mytable set 

[myfield2] = mid([myfield], 2, len([myfield]) - 2)

[Lynette]

Thanks very much ajetrumpet
Lynette

[ajetrumpet]

not a problem. good luck