I have a csv file separated by `,`. Unfortunately the last column is a text field and some of the strings have a comma, so when I try to import the csv to MySQL the last column gets cut sometimes.

**Example of my csv file (15 columns) - 37k lines**

```
Column1  ----------         Col2 Col3  Col4 ----      Col15   
server.domain.tld,IP,Country,City,(...),text random text, text text

```

I need to replace all but the last `,` by `;` so when I import the file to MySQL using `;` as column separator, field 15 wont get cut. Another way could be replace the first 14 ',' by ';'.

**Output I need:**

```
Column1  ----------         Col2 Col3  Col4 ----      Col15   
server.domain.tld;IP;Country;City;(...);text random text, text text

```

**Already tried:**

```
sed 's/,/;/g1-14'
sed 's/,/;/g{1-14}'
sed 's/,/;/g{1,14}'
sed 's/,/;/!14g'
sed 's/,/;/14g!'
sed 's/,/\1;\2;\3;\4;\5;\6;\7;\8;\9;\10;\11;\12;\13;\14;/'

```