Get sub string from string

[tjamal1]

I have a field which contains following values

"productName": "Apple",
"productName": "Amazon",
"productName": "Wayfair",
"productName": "Sephora",
"productName": "Expedia.ca",

Is there any way to extract text between second quotations 

like Apple

      Amazon

[NicholasM · Accepted solution]

Hey @tjamal1,

You could use the Regex tool, or you could make things simple and use the text to columns tool, using quotes as your delimiter. I have mocked up a workflow that you can use to get this information.

Let me know if you have questions. 

[tjamal1]

Thanks , What would be the Regex approach ? 

[NicholasM]

Regex would be a bit more dynamic, allowing you to basically scan the text field and only parse out what is within the second quotations. Here is what i would suggest using! 

If you have never used regex I would highly suggest looking at this  post to get you up to speed. It can get pretty complex.