Remove text from field

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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
Click to expand...

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)
 
FANTASTIC!! It worked perfectly, Thank You =)

-John

fredg said:
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
Click to expand...

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)
Click to expand...
 
Back
Top