search for: col_a

...hr1:71310034 chr14:23354088 chr15:37759058 chr22:18262638 chrUn:31337214 chr10_random:4369261 chrUn:3545097 I would like to get rid of colon (:) and replace this column with two new columns containing the terms on each side of the colon. The new columns should look as follows: Col_a Col_b chr1 71310034 chr14 23354088 chr15 37759058 chr22 18262638 chrUn 31337214 chr10_random 4369261 chrUn 3545097 Any help will be much appreciated Joseph ____________________________________________________________________________________ Looking...

So, under Sqlite2, if I want to update a database''s schema, I have to dump the DB, modify the table''s structure, then go and modify EVERY insert statement. The insert statements look like (from memory): INSERT INTO my_table VALUES (''some_id'', ''some_val'', '''', '''', '''', ''some_other