Parsing text with specific pattern

Question

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 Answer

@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","|")