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.
Hello everyone. I have not used the parse to text (outside of simple text to columns) or the RegEx tools much and i am struggling with the above. I have a column that looks like the data in the column labeled Original. I need it to look like Columns c - f. Every port starts with OC but I can not figure out how to do a starts with. I tried to do an after "on" but since None has on in the word, that didn't work.
If you think about doing two passes, it’s actually quite straightforward: First pass, use a Formula to remove the quotes, then split on the commas using Text-to-Columns Then add another Text-to-Columns, splitting on the space. Clean up using a Select tool to drop unwanted fields