Use SPLIT() function with __ as delimiter

Complementing what Mihai suggested, you can apply the split directly in your data source.

Just go to your data source and select the arrow over the field you want to split.

Then select Custom Split and configure it so it splits by "__"

I hope this helps. If does, please mark it as helpful/correct so other users can find it.

Best,

Diego