I have data with only 1 column and about 50 rows in it like
col
-----------
ab~~8900~~iop
nmk~~?~~ioiooo
king~~till~~8899089
the data will have column delimeters(i.e~~) but i will not seperate them. I have to clean the data and write to file after cleaning But the output file should be like
col
------
ab~~8900~~iop#^#nmk~~?~~ioiooo#^#king~~till~~8899089
The row delimeter here is #^#
How can i get this done.
Please suggest.