Re: I Need to replace many text area in a field with replace function.
- From: Smartin <smartin108@xxxxxxxxxxx>
- Date: Wed, 17 Jan 2007 18:49:13 -0500
uberblick wrote:
Hello Access Community,
I'm using Access 2003.
I have a generic HTML template for ebay that contains html code.
In that HTML code we have some field or attribute names like {{ORIGINAL TITLE}}, {{GENRE}}, {{MPAA}} etc. that we would like to customize for each SKU.
We would like to create a customized html code per SKU that contains the right attribute values. So in Fact we have to replace all attribute names by their respective attributes values.
Up to now I was able to replace 1 attribute but I don't know how to build my formula to replace 12 attributes within the same string expression.
This an example: <Start Here>Detail1: Replace(Templates!HTML,"{{IMAGE(ITEMIMAGEURL1)}}",[Oztion_Images&Flags]!Filename)<End Here>
The HTML field is a MEMO field.
The expected result would be an append or make table query that will contains fields named "UPC" and "Detail", the customized html code.
I'm using the Expression Builder not VBA.
Thanks in advance for any input.
Your help will be very appreciated since I'm working on that since a week.
Regards
Stephan
I don't think you can replace multiple targets in one sweep. But since you have 12 attributes, a relatively small number and probably fixed, you could create 12 separate expressions.
If you want all 12 expressions to fire from one control, you could put them each in separate queries, create a macro to fire each query in turn, and point the control at the macro.
--
Smartin
.
- Prev by Date: Re: Union Queries involving 2 Queries
- Next by Date: Re: Multiselect parameter query
- Previous by thread: RE: Archiving
- Next by thread: Re: I Need to replace many text area in a field with replace funct
- Index(es):
Relevant Pages
|
