Trim

  • Thread starter Thread starter Jacob
  • Start date Start date
J

Jacob

how would I trim leading quotation marks? I also need to trim them off of
the back side of another column.
 
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)
 
=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.
 
Back
Top