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
Solved! Go to 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
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