Access 2000 / more characters to be eliminated

[Abay]

Hello again .. this time I need to eliminate all characters (in a field) up
to and including the first "- " (dash, space), or "-" (dash no space
afterwards)

Any help would be much appreciated as usual.

Thanks in advance

Abay

 

[Vladimír Cvajniga]

I think you could try Replace function.

HTH

Vlado

 

[John W. Vinson]

Hello again .. this time I need to eliminate all characters (in a field) up
to and including the first "- " (dash, space), or "-" (dash no space
afterwards)

Back up your database just in case; then run an Update query updating
[Field] to

Trim(Mid([Field], InStr([Field], "-") + 1)

using a criterion of

LIKE "*-*"

to limit the update to those records where the field does contain a
hyphen.

John W. Vinson [MVP]

 

[Abay]

Any thanks, & much apprciated.. will do that ..

Abay

Hello again .. this time I need to eliminate all characters (in a field)
up
to and including the first "- " (dash, space), or "-" (dash no space
afterwards)

Back up your database just in case; then run an Update query updating
[Field] to

Trim(Mid([Field], InStr([Field], "-") + 1)

using a criterion of

LIKE "*-*"

to limit the update to those records where the field does contain a
hyphen.

John W. Vinson [MVP]