I have received this type of table, [available also here](https://www.dropbox.com/s/oc4fa1commm2mb0/mySample.csv?dl=0)

[![enter image description here](https://i.stack.imgur.com/QBOuV.png)](https://i.stack.imgur.com/QBOuV.png)

I wonder, how to efficiently open the table in R?

My output should be splitted in 3 separate columns, and without the parentheses: :

```
      id   type  V1  
1 13242924 'SA'  1 
2 13035909 'SA'  1 
3 6685553  'SA'  1 
4 12990163 'SA'  1  

```

For now, I was thinking to split it in few steps:

* open the file as .csv with `\t` separator,
* use multiple `gsub()` to replace both parentheses,
* split the first column in two, etc.

Isn't there a simpler way? Also, seems that `optim$V1 <- gsub('(', "", optim$V1)` simply does not remove parantheses.

```
df<- read.csv("C:/sample.csv",
               sep =  "\t",
               header = F)

# Replace the parantheses:
optim$V1 <- gsub('(', "", optim$V1)

```