I have the following data in Azure SQL Server (Microsoft SQL Azure (RTM) - 12.0.2000.8 Sep 20 2018 21:40:02 Copyright (C) 2018 Microsoft Corporation)
ID Name
1 US_Android_100x200_blue
2 UK_iOS_100x200_green
I want to split them into a table like this:
ID Country Device Size Color
1 US Android 100x200 blue
2 UK iOS 100x200 green
What are the ways to do it? I looked it up and it shows to use STRING_SPLIT but I haven't been able to find a clean way to do it.