Help needed for text qualifiers """"

[alphanitrate]

I have a number of records that were originally imported from text files and have kept the "" on the text.

I am looking for a way to remove the leading and trailing quotes" from about 18 fields and about 30,000 records.

I have contemplated just removing them all - but I have a lot of measurements (1-1/2" etc.) that I would have to replace after.

Any ideas short of pulling all the data to excel and editing each record?

[comment]

Do they ALL have leading and trailing quotes?

[alphanitrate]

not anymore - some were from initial population, i learned what was causing them and stopped doing it that way

[comment]

OK, then how about showing all records and replacing each field's contents with a calculation =

Case (

Left ( Field ; 1 ) =""" and Right ( Field ; 1 ) = """ ;

Middle ( Field ; 2 ; Length ( Field ) - 2 ) ;

Field

)

Make sure you have a backup before trying this.