Removing a specific character

[deejay_totoro]

Hello,

I would like to remove a specific character from every field in a table, a "%" for example.

I have found code that will let me remove the character from each field individually, but this means calling the function for each individual field...
ie:

cleanMe([fld1]), cleanMe([fld2]), cleanMe([fld3]) etc...

There are hundreds of these tables and each table contains maybe 50 fields.

So..! I am wondering if anyone would have any idea how to create a function that would clean every field in a table... ie:

cleanMe([all fields])

Many thanks!

dj_T

 

[Guus2005]

You can use "replace" to replace one or more characters. You can use a recordset to loop all the fields in a table and change the content. Don't have any ready code for you.