How to extract text between parentheses


Suppose you have text data like 1715(20170421), and you want to extract 20170421 portion of the text which is placed between parentheses.

To do this, select “Text Data Wrangling” from the Column Header Menu then select “Extract

And you’ll see the Text Data Wrangling Dialog opens with Extract option selected. Select “Text Inside Of” from pulldown list and set ( for the Begin and ) for the endEnd input fields as follows:

And if you run this you’ll get text inside the bracket.

Curly Brackets

if you want to extract text between curly bracket, you can do so by changing condition like this.