I have an excel file I would like to extract the information in column 2 and only information in square brackets and copy it to column 3 and then delete whatever has been copied from column 3. using the terminal. How do I go about it ?
Below is my sample data.
Expected output:
