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.
@vrbravo While you could use regex to do this, there's no need. It appears the data is split by spaces, and so a text to columns tool would accomplish the same task using \s as the delimiter. Since you mentioned tabs, you could also include \t in the delimiter as well, just using \s\t.
Given there are multiple spaces below, I would also check the "ignore empty columns" option.
@neilgallen - Thank you for the response. It worked well until there are some names such as megan jr, fox. Then the columns are shifting to next columns. I think the name column is kind of random. Is there any other way to split columns ?
We used RegEx “Parse” output method. Based on the input pattern, the below expression was built and each expression in bracket () will be separated into new fields and the non-bracket expression will be ignored in this case space\s+