[Edited to be even modern by using split, not strsplit, join, not strjoin, and double, not str2double.]
Here's a more modern version, using string and patterns, which are really the best way to go these days. There's a bit of trickiness at the beginning, going from ragged cellstr to string, but after that it's smooth sailing.
C = {'Business Name One[5],Business Name Two[3],Business Name Three[2]';
'Business Name Two[3],Business Name Three[2]'}
C =
{'Business Name One[5],Business Name Two[3],Business Name Three[2]'}
{'Business Name One[5]' }
{'Business Name Two[3],Business Name Three[2]' }
Turn that "ragged" cell array into one long string, then split at the commas.
S = split(S,","); S = S(:)
S =
"Business Name One[5]"
"Business Name Two[3]"
"Business Name Three[2]"
"Business Name One[5]"
"Business Name Two[3]"
"Business Name Three[2]"
Now it's just a matter of pulling out the text and the numbers. Pattern is much easier to use than regexp.
pat = "[" + digitsPattern(1) + "]";
biz = extractBefore(S,pat)
biz =
"Business Name One"
"Business Name Two"
"Business Name Three"
"Business Name One"
"Business Name Two"
"Business Name Three"
buz = extract(S,digitsPattern)
buz =
"5"
"3"
"2"
"5"
"3"
"2"
Now convert them to more useful types and put them in a table.
t = table(biz,buz)
t =
biz buz
___________________ ___
Business Name One 5
Business Name Two 3
Business Name Three 2
Business Name One 5
Business Name Two 3
Business Name Three 2
