Remove single quote

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
 
S

storrboy

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)
 
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
Click to expand...

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