Hi there,

I have a text file like below,

:20:abc
:10:bbc,
ccc,
999
:30:bba

I need to load the above data in to table like below,

10 20 30
--- --- ---
bbcccc,999 abc bba

10, 20, 30 are the columns in the table.

Please help me to create a control file for this.

Thanks
Vinoth