Hi all,
I have a spreadsheet with a column that contains "category codes" along with some other factors. There is always at least one category code and so far the maximum I have seen is 7.
How can I separate the column in access to show me all of the category codes in different columns? Below are some examples of how the original column comes through:
PI97*72172.86*10097*3
OA133*54.5*12133*5,MA67**6067*
CO131*2419.92*9131*2,CO137*-193.76*9137*2,PR2*1102.92*8002*1
All of the category codes except for the first one appear to be sandwiched between a comma(,) and an asterisk(*). I would want this column to be split as follows:
Code1 Code2 Code3 ...Code7
PI97
OA133 MA67
CO131 CO137 PR2
Any help would be much appreciated, thanks!
Bookmarks