Trim

[Jacob]

how would I trim leading quotation marks? I also need to trim them off of
the back side of another column.

 

[John Spencer (MVP)]

Use an update query to do it permanently. TRY THIS ON A COPY of your data to
make sure it works for you.

Leading Quote:
UPDATE Tablename
SET SomeField = Mid(SomeField,2)
WHERE SomeField Like CHR(34) & "*"

Trailing Quote:
UPDATE Tablename
SET SomeField = Left(SomeField,Len(SomeField)-1)
WHERE SomeField Like "*" & CHR(34)

 

[Jacob]

How???
I am a novice. Sorry for the headache.

Try using MID function.

 

[Sandy Eastman]

=Right(trim(YourFieldName),Len(trim(YourFieldName)) - 1)
will return your string without the leading character.
You only need the trim functions if there is a chance the string might have
leading or trailing blanks

=Left(YourFieldName,Len(YourFieldName) - 1)
will return your string without the trailing character
Regards, Sandy.