Re: I Need to replace many text area in a field with replace funct

• From: Smartin <smartin108@xxxxxxxxxxx>
• Date: Wed, 17 Jan 2007 20:34:16 -0500

Thanks for your input. It's really appreciated.

I see your point.

So basically, I should a create a single Query per attribute name that I'd like to replace. And than run them in sequence or use a macro to do the whole sequence.

Is that correct ?

Regards

uberblick

"Smartin" wrote:

Hi uberlick,

Not to discourage you from your quest, but I see no way it is possible. Your suggestion is intriguing but I tried a couple variations on that theme and came up empty.

The UPDATE query will only accept one argument per field. If you concat several REPLACE statements here, they appear to be evaluated as a single boolean value passed to the update. IOW, they will not be executed sequentially. E.g.,

update RedGreen
set color = replace(color, 'r', 'orange') & color = replace(color, 'e', 'blue')

results in FALSE throughout.

Also UPDATE will not allow you to update the same field more than once.

update RedGreen
set
color = replace(color, 'r', 'orange'),
color = replace(color, 'e', 'blue')

is not valid SQL.

Sorry!

<
Totally OT, but I'm compelled to share a picture of mine that suits your nym (^: http://i51.photobucket.com/albums/f400/smartin108/profile/124_2467.jpg
>


uberblick wrote:

If I do an Update Query by using a CONCAT or "&" function to perform several replacements within the same expression and within the max characters limit allowed by the Expression Builder, would it work ??

"Smartin" wrote:

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

--
Smartin

• Follow-Ups:
  • UPDATE: I Need to replace many text area in a field with replace f
    • From: uberblick

• References:
  • Re: I Need to replace many text area in a field with replace function.
    • From: Smartin
  • Re: I Need to replace many text area in a field with replace funct
    • From: Smartin
  • Re: I Need to replace many text area in a field with replace funct
    • From: uberblick

• Prev by Date: Re: Delete records containing certain info
• Next by Date: Re: SQl query in VBA - SELECT inside an INSERT INTO
• Previous by thread: Re: I Need to replace many text area in a field with replace funct
• Next by thread: UPDATE: I Need to replace many text area in a field with replace f
• Index(es):
  • Date
  • Thread

• Windows
• Science
• Usenet

• Archive
• About
• Privacy
• Search
• Imprint