G
Guest
I'm fairly new to Access and could use some guidance. I need to build a bulk
upload feed of my product catalog for Google Base. On the import to Google I
receive errors because the product description and titles for some products
contain special characters like trademark, copyright, degree, and other
symbols. I've written some queries to replace those characters with the
entity names but it's gotten way too complex. Here is the first query. I
started writing seperate queries because the nested iif's got to be too much
for me.
description:
IIf(InStr([product].[description],"®"),Replace(htmlencode([product].[description]),"®","®"),IIf(InStr([product].[description],"â„¢"),Replace(htmlencode([product].[description]),"â„¢","&trade"),IIf(InStr([product].[description],"â€"),Replace(htmlencode([product].[description]),"â€","&lquo"),[product].[description])))
Does anybody have any suggestions on how to simplify this? For some reason
the htmlencode statement doesn't convert all the characters. Is there another
form of that which will work on all special characters?
Thanks
upload feed of my product catalog for Google Base. On the import to Google I
receive errors because the product description and titles for some products
contain special characters like trademark, copyright, degree, and other
symbols. I've written some queries to replace those characters with the
entity names but it's gotten way too complex. Here is the first query. I
started writing seperate queries because the nested iif's got to be too much
for me.
description:
IIf(InStr([product].[description],"®"),Replace(htmlencode([product].[description]),"®","®"),IIf(InStr([product].[description],"â„¢"),Replace(htmlencode([product].[description]),"â„¢","&trade"),IIf(InStr([product].[description],"â€"),Replace(htmlencode([product].[description]),"â€","&lquo"),[product].[description])))
Does anybody have any suggestions on how to simplify this? For some reason
the htmlencode statement doesn't convert all the characters. Is there another
form of that which will work on all special characters?
Thanks