Attachment 23489I am importing an inventory file from QuickBooks and in the field [ITEM} the QB table has combined our "ITEM" (product part number) and "item Description" into one field.
Item Description is in parenthesis in all records- text both outside and inside the parens may be different in each record- but every record has open and close parens.
A space always separates the first text and the text inside the ( ).
EXAMPLE OF A RECORD: [ITEM] field CONTAINS: A610 (Widgetsgalore) --- where "A610"is our Item Number and (Widgetsgalore) is the Item Description---- separated by a space..
For all records, I want to delete the parens and all text inside (in example (Widgetsgalore) .... so I end up with a field that has the "item" but not what was in parens.
"Item" can be 2 to 16 characters long.
I have included an accdb with one table to show what I mean.
I have been struggling with MID function and INSTR -- to no avail.
Any help is appreciated.
Thanks
JP