Here's the data format:
[32] Event linked to [Warehouse] [BB16027901]
I'm trying to figure out a way to isolate BB16027901 above and I can't do it with a mid() formula since the database has changed. As seen above there are 3 sets of [ ]. In the first set, the number is 32, which is two digits. Unfortunately, the number can be one, two of three digits. In the [Warehouse] area, the number of characters also differs since the location name [Warehouse] can change. For the third set of [ ], this will always be a 10 character event number and that's what I would like to isolate so I can create a hyperlink to another event. Any thoughts? Thanks!
[32] Event linked to [Warehouse] [BB16027901]
I'm trying to figure out a way to isolate BB16027901 above and I can't do it with a mid() formula since the database has changed. As seen above there are 3 sets of [ ]. In the first set, the number is 32, which is two digits. Unfortunately, the number can be one, two of three digits. In the [Warehouse] area, the number of characters also differs since the location name [Warehouse] can change. For the third set of [ ], this will always be a 10 character event number and that's what I would like to isolate so I can create a hyperlink to another event. Any thoughts? Thanks!