Remove single quote

  • Thread starter Thread starter Jon R
  • Start date Start date
J

Jon R

Using a query I am trying to remove the single quote from the
following example of numerous text fields in a table: AA -5.25"-AAA-
K. Using the following replace function: No
Quote:Replace([PART_NUM],""","") I am receiving the error message
"The expression you entered has an invalid string. A string can be up
to 2048 characters long including opening and closing quotation
marks." The table was imported in from Excel.
Thanks in advance.
Jon R
 
Using a query I am trying to remove the single quote from the
following example of numerous text fields in a table: AA -5.25"-AAA-
K. Using the following replace function: No
Quote:Replace([PART_NUM],""","") I am receiving the error message
"The expression you entered has an invalid string. A string can be up
to 2048 characters long including opening and closing quotation
marks." The table was imported in from Excel.
Thanks in advance.
Jon R
Click to expand...


Instead of replacing " , try replacing Chr$(34)
 
Using a query I am trying to remove the single quote from the
following example of numerous text fields in a table: AA -5.25"-AAA-
K. Using the following replace function: No
Quote:Replace([PART_NUM],""","") I am receiving the error message
"The expression you entered has an invalid string. A string can be up
to 2048 characters long including opening and closing quotation
marks." The table was imported in from Excel.
Thanks in advance.
Jon R
Click to expand...

Instead of replacing " , try replacing Chr$(34)
Click to expand...
That did it - thank you.
 
Back
Top