I have an imported table that has 1 data field ('name') with the following records
American Stairs (AMS)
DoRay Furnishings (DRN)
In a query, I need to separate the 3 character designation out from between the parenthesis... how can I do that in a query please?
The parenthesis always start 1 space after the name, and the designation is always three characters long (i.e. AMS, CHW)
Open in new window
You may be better to just get the name from the database and then extract the 3 character designation