Forum Discussion
Azure Cost Management - Tags into two columns (TagName, TagValue)
Hi, lkshck
I don't think you need to have the column like = "{"&[Tags]&"}".
You can try splitting column values as follows:
1.Split selected column into multiple rows by delimiter 'Comma'
2.Split selected column into columns by delimiter 'Colon'
3.Replace quotation marks with empty values
Best Regards,
Community Support Team _ Eason
So normal data structure of the Tags column looks like the following:
I want to split this structure into two Columns, TagName and TagValue. So the TagName column should contain every value before the ":" and TagValue the value after ":".
Hope this is more clear.
Hi, lkshck
I don't think you need to have the column like = "{"&[Tags]&"}".
You can try splitting column values as follows:
1.Split selected column into multiple rows by delimiter 'Comma'
2.Split selected column into columns by delimiter 'Colon'
3.Replace quotation marks with empty values
Best Regards,
Community Support Team _ Eason