This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
What I want to pick up on is the UK18-0001/US18-0041 section of this. I've tried Text to columns but the main problem is that the folks who manage this file structure do not keep to the same format everytime. But they do include the code for the project, so I want to extract that so I can just have a table of them.