Get string after second special charcater

[rjanezic]

Hello All,

So I have strings like below. But I only want the string after the second period, how would I go about this (I know I can hard code in using a LEFT, but the tracks go into double digits so I need something dynamic probably using RegEx)

What is showing = items.0.track.album.artists.0.external_urls.spotify

What I want = track.album.artists.0.external_urls.spotify

[LordNeilLord · Accepted solution]

Hey @rjanezic

Text to Columns is your friend here with . as the delimiter :)

You'll need it when you're parsing out JSON as the numbers will be your grouping when you come to crosstab back

[rjanezic]

Thank You, this helped! I wanted to see if I could accomplish it with RegEx so I could learn some more about it. But the Text to Columns works

[LordNeilLord]

Hey @rjanezic

If you wanted to do it with RegEx it would be something like this:

.*?\.\d+\.(.*)

[JohnBell]

@LordNeilLord

Thank you!  This is great...

Regards,