Remove text from field

[Guest]

I have a field that contains a the name of a business. In front of the name
in brackets is an identifier for thet company. example

[abc123] Microsoft
[def456as] Acme
[ghi] Universal

I need to remove the Brackets and everything in between them so that only
the company name is left. The length of the field between the brackets is
not uniform, it could be anywhere from 3 characters to 12 characters. Any
help would be greatly appreciated. Thank you in advance for your assistance.

-John

 

[fredg]

I have a field that contains a the name of a business. In front of the name
in brackets is an identifier for thet company. example

[abc123] Microsoft
[def456as] Acme
[ghi] Universal

I need to remove the Brackets and everything in between them so that only
the company name is left. The length of the field between the brackets is
not uniform, it could be anywhere from 3 characters to 12 characters. Any
help would be greatly appreciated. Thank you in advance for your assistance.

-John

If all the data in the field has a space between the closing bracket
(]) and the company name, then:
Add a new column to your query.
NewName:Mid([OriginalName],InStr([OriginalName],"]")+2)

 

[Guest]

FANTASTIC!! It worked perfectly, Thank You =)

-John

I have a field that contains a the name of a business. In front of the name
in brackets is an identifier for thet company. example

[abc123] Microsoft
[def456as] Acme
[ghi] Universal

I need to remove the Brackets and everything in between them so that only
the company name is left. The length of the field between the brackets is
not uniform, it could be anywhere from 3 characters to 12 characters. Any
help would be greatly appreciated. Thank you in advance for your assistance.

-John

If all the data in the field has a space between the closing bracket
(]) and the company name, then:
Add a new column to your query.
NewName:Mid([OriginalName],InStr([OriginalName],"]")+2)