Split one column into two
Posted on 2011-02-17
Hi, I have a table that contains the following:
Term | Col | Department | Course | Course_Title
I need my Course Column split into two different columns Course and Course_Number. Examples for my course column include:
So, some courses my have 1 space between the course and the number, while others have two spaces, or none. I'm not sure how to split these up so it will appear
Course | Course_Number
Any help would be greatly appreciated.