I have a table like:
$V1 $V2 $V3 toto|380 peper|728A tomato|I765 toto|458 peper|798A ognion|L965 toto|3L0 ginger|2R8A lemon|I765
And I would like to split it by the "|" and finally get :
$V1 $V2 $V3 toto peper tomato toto peper ognion toto ginger lemon
I tried with:
but it's not working.
Do you have any idea?