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