Find And Replace

[abbaddon223]

Hi,

I'm hoping someone could help me please? I'm really stuck with this one...

I have a table called: "tb_special_characters" with a field name [character]. In this table are values that I would like to remove from fields in another table ("tb_data", field name [Title]

The values in the "tb_special_characters" are thinks like

.
@
}

I'd like to run a query on tb_data.title that would replace any matching characters in tb_special_characters.character with nothing (I remove and close any spaces).

can this be done?

thanks,

Phil.

 

[pr2-eugin]

Is is possible by using two recordset objects, looping over and over, although might not be the efficient way. I am sure there might be someone with a better solution, so let's wait for some other suggestion !

 

[Galaxiom]

I would use a loop through a recordset based on the special characters table and run an update query on the other table using Replace() to change the current special character to a null string.