Splitting Text from special characters 3 times

[dan1992]

Hello,
I have a cell containing the following information:

"AM,1,10|LA,1,5|VU,1,5"

The end product i need is one column containg AM (so after" and before , ) one column containing LA (so between | | ) one column containing VU (after | and before ")
I need this to be a formula as the codes used in the example with change and some of the codes are only 1 letter.
Any help would be hugely appreciated.
Hope that made sense

 

[Bo_Ry]

Put The formula into B1
Drag formula by place cursor at the lower right corner of cell B1, the cursor should change to black plus sign, then hold left click and drag to D1