Selecting certain strings and pruning em'

[kupe]

About 30k records in the one field of a large database have a four-character prefix that I need to remove. Some records don't have this prefix, and are fine.

Is there a way please to trim the strings, by choosing each record in "Field1" that is prefixed by these four characters - "like accs" - and to remove the characters, please?

I've been trying for some time now. I end up with lots of queries, but no way of getting them back together again. Perhaps someone's done this recently and knows the answer. Be very grateful to hear it.

 

[Mile-O]

In a query, create a new field:

NewField: IIf(Left([Field1], 4) = "accs", Mid([Field1], 5), [Field1])

 

[kupe]

Very neat. That's really good, works a treat. Thanks very much, MoP. Cheers to you.

 

[kupe]

Hi Mile-O-Phile

The New Field method has been great to remove "www." from a vast number of urls.

But no matter how I adjust the Immediate If, I am left with stragglers such as these

www-users.york.ac.uk
wwww.computerwoche.de
wwww.einet.net
wwwnet.nl

And oddly enough, this one
www.yu

Could I use a wildcard or something similar to get rid of the remainders - almost 200 of them?

 

[kupe]

Sorry, MoP, I see the fault. Cheers.