Removing partial data from a Field

  ihbuk1 14:25 24 Jan 03
Locked

I have information on a database that has some surnames with "(z)" before their surnam and others without that. I want to remove those incidences of "(z)" so that just the surname is left.

Can anyone help me, please?

  cherria 14:32 24 Jan 03

What sort of database?

  ihbuk1 14:38 24 Jan 03

Oops sorry it is in Access 2000.

  recap 15:13 24 Jan 03

Sort the table in ascending order then all the "z" will or should be at the bottom, then you should be able to delete the "z".

Or

run a query to find the data with "z" before it and delete it from there.

  cherria 15:20 24 Jan 03

Backup your database first so you can't accuse me of wrecking it....

If your table is called tab1 and the field is called surname then create a query, go into the SQL editor and type:

update tab1 set surname=right(surname,len(surname)-3) where left(surname,3)="(z)"

hit the ! button to run the query and hey presto!

remember backup first!!!

  ihbuk1 15:35 24 Jan 03

Can I thank you all for those who have responded to this quiry. I have resolved the problem. Your help is much appreciated.

This thread is now locked and can not be replied to.

Nintendo Switch review: Hands-on with the intuitive modular console and its disappointing games…

1995-2015: How technology has changed the world in 20 years

Method Studios' title sequence for BBC series Taboo is truly unsettling

Best Pages for iOS tips | How to use Pages for iPad & iPhone: 6 simple tips to get more out of…