How to split and store splited data in macro

Hello,
I have one Column "Parameter" that contains  values below
Parameter
Financial Product=REMITTANCE|MESSAGEDIRECTION=I

I want to store both in macro after split
like 
%{Key}   %{value}
%{key_1}  %{value_1}