Pick the column value based on another column using awk or CUT

My scenario is that I need to pick value from third column based on fourth column value, if fourth column value is 1 then first value of third column.Third column (2|3|4|6|1) values are cancatenated.
Please someone help me to resolve this issue.

Source

column1 column2 column3 column4
1,ganesh,2,1
222,ram,2|3,1
222,ram,2|3,2
33,raju,2|5|4|6|1,1
33,raju,2|8|4|6|1,2
33,raju,2|9|4|6|1,3
33,raju,2|8|4|6|1,4
33,raju,2|3|4|6|1,5

output format

column1 column2 column3 column4 
1,ganesh,2,1
222,ram,2,1
222,ram,3,2
33,raju,2,1
33,raju,8,2
33,raju,4,3
33,raju,6,4
33,raju,1,5

$ nawk -F, '{split($(NF-1),a,"|");$(NF-1)=a[$NF];OFS=","}1' input.txt
1,ganesh,2,1
222,ram,2,1
222,ram,3,2
33,raju,2,1
33,raju,8,2
33,raju,4,3
33,raju,6,4
33,raju,1,5

if you dont have nawk, then try with awk

Thanks for your quick reply.. i will check let u knwo if any issues

---------- Post updated at 02:06 AM ---------- Previous update was at 01:55 AM ----------

Awesome it is working fine...Thanks a lot kamaraj