detach, extract and clear column data