Need Guidance in below logic

Database

Need Guidance in below logic

Hi,

I have a requirement in Teradata ...where i need to split the data in a column into 10 cols based on the position of #. In the other words, need to place the data for the first occurence of hash in col1 and the second occurence in col2 etc...else need to pass the null value...

For ex: If i have the data in ColA as a#bc#dfee#6 then col1 must have a and col2 must have bc and col3 must have dfee and col4 must have 6 and the other cols must have null values...

The position of # in ColA is not constant...

I have the data in the table like...

ab#cde#f#g#h#i#j#k#l
as#hen#chick
a#b#c#d#e#f#g#h#i#j#
abcdefghijkl
abcde#fghijk#l
asas#
3##7
2#6
Please provide me any suggestions to acheive the above requirement...

I have tried to acheive the above requirement using position and the substr functions but was not successful in one scenario....

THanks for your support in advance....

Regards,
Venkat.