Parsing text with specific pattern

[saivig68]

Hi All , 

I have text in the following format : 

=%3Afeature%3Astone1CaratRange%3A1%2F2+to+1%3AringStyle%3AHalo%2FFramed%3AringStyle%3ASolitaire%3AstoneColors%3ABlue%3AstoneColors%3APink%3AstoneColors%3AWhite

The data I need is logged between '%3A' ,  I tried the text to columns and it works but it is also parsing spaces and filling columns .

Is there a way to use any other tool so that I don't pick up these spaces

[CharlieS · Accepted solution]

@saivig68

When you enter the "%3A" in the delimiter field in the Text to Columns tool, it treats each one of those three characters as a delimiter ("%","3", and "A"). I used the following formula to assign a single character delimiter. After that, the Text To Columns tool worked just fine. 

Replace([URL],"%3A","|")

[ponraj]

Here is the solution for your problem. Use regex [^%3A]+ with output method Tokenize to get the desired results.