I need to pull out some data in the middle of a string and then group on that data. Trouble is the text in the different areas can change depending on where the data is being pulled from. I need to group on the bold area below that always ocurrs within the [] after the : with the caveat that the () before and after may or may not be there.
Anyone got any ideas?
Sample 1--> (KCI)[Inv Num: T2-1207846](Payroll Expense Transfer)
Sample 2 --> [PCO Num: 0002](Supervision)