Get characters to the right of a certain part of the string

[kayla_o]

Hi all, 

I have multiple cells with something like this:      "summar":"null":"score":"SV_0832dmn83bf","project","catalog":

I am trying to parse out just this into a separate column: SV_0832dmn83bf

How can I do this?

thanks!

[Raj]

REGEX_Replace([InputColumn], '.*:"([^"]+)",.*', '$1')

this will give the result

[gawa]

hi @kayla_o 

There are a couple of ways to do that. As proposed by @Raj, Regex would be first option to parse data in your case.

Another possible Regex can be like this; 1 or more upper case alphabet, followed by underbar _, and 1 or more alphabet/number.

.*?([A-Z]+_\w+).*?

 Also, if you want to parse other data together, and are sure of input data having the same schema, Text to Column would be an option, too.

[aatalai]

Another way (less elegant, but possibly simpler -i.e without regex) use a a text to column tool with " set as the delimiter  and then use the select tool to choose which column (or columns you want)

Hope this helps