I have

```
P2_PCM_C_L112_2011_00_1v  
P2_PCM_C_L212_2012_00_1v  
P2_PCM_C_L119_2011_00_1v  
P2_PCM_C_L6712_2012_00_1v  
P2_PCM_C_L17612_2014_00_1v  

```

but I would like to have them all separated and placed into rows, separated by the underscore.
What would the code be for legacy SQL (its for google BigQuery)

Thanks!