I have text file that looks as follows:
12.com,22.214.171.124,TEXT1,no1,['126.96.36.199'] 23com,188.8.131.52,TEXT2,no2,['184.108.40.206'] 45.com,220.127.116.11,TEXT3,no3,['18.104.22.168'] 67.com,22.214.171.124,TEXT4,no4,['126.96.36.199', '188.8.131.52']
Because I want to insert the file content into a table using MySQL command saying
separated by ',', the lat string between the brackets (which may contain strings separated by comma) is causing problems where MySQL wants to separate them but hte table does not have enough columns for them.
I want to replace the commas that are between the brackets
 with semicolon
How can I do this in Linux in a simple way?
The number of strings that are separated by
, inside the square brackets is not defined. It can be 1, 2, 3, etc. I need to replace
, whenever found inside brackets with