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.
Thanks a lot for the help! It’s just that there are some other lines with more combinations (concatenates) included. I did text to column and some lines are divided into say 9 parts whereas some else into 11. That’s why I wanted to use Regex to just get the fields I’m after.
OK - I see what your problem is. However, I am assuming the values (GDP, GDP_N, etc) are going to change each input so we can't put a regex pattern to find "GDP","GDP_N" etc for example. Also, if the number of delimiters increases/decreases then we also can't use a search like first instance of "|" which is more like a TextToColumns tool.
If you are doing this manually, how do you know which fields you want to keep (ie the 6 out of the 10)?
Are you able to send some more data examples and I'll take a closer look