searching text dao, array?

  • Thread starter krzysztof via AccessMonster.com
  • Start date
K

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
 
A

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], " ", ""), "#", "")
 
K

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!!!


Allen said:
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]
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top