searching text dao, array?

[krzysztof via AccessMonster.com]

Good Day,

I need a little help.

i have a column in a table, that needs formatting. I need to look at each
record, the inspect for certain characters, and if there so delete the
characters, creating a single string.

Example:

i need to take: Store #4544
and make it: STORE4544

the caps part is done, but i need to search for the "#" sing and spaces, if
delete them.

i have tried using dao, and recordsets with arrays, but how can i get each
character from the string into each item in the array? that would be great...


any help is great appreciated,

btw - i need to perform this operation around 300,000 times, so it is a long
loop, which is why i was thinking create a recordset, the plop that into an
array, But i can't do that!?

~K

 

[Allen Browne]

Create an Update query (Update on Query menu in query design.)

Assuming the field is named F1, type an expression like this in the Update
row under F1:
Replace(Replace([F1], " ", ""), "#", "")

 

[krzysztof via AccessMonster.com]

i was trying different methods with that relace function, i just found that
today.

it works wonderfully!!!

thanks for the help!!!

Create an Update query (Update on Query menu in query design.)

Assuming the field is named F1, type an expression like this in the Update
row under F1:
Replace(Replace([F1], " ", ""), "#", "")

Good Day,

[quoted text clipped - 26 lines]

~K