-1

The Dataset is a csv file with 7 columns and 3872 rows. I want to create an sql query, but the ('s) gives an error during query runtime. That's why I need to replace the ('s) with (''s) to create the query. All help will be appreciated. Thanks in advance

Ankit Daimary
  • 148
  • 1
  • 6
  • 1
    Please read [How to make a great R reproducible example?](https://stackoverflow.com/questions/5963269/how-to-make-a-great-r-reproducible-example) – SirSaleh Jul 11 '18 at 06:36

1 Answers1

1
dataset$column <- gsub("'s", '"s', dataset$column)
zx8754
  • 52,746
  • 12
  • 114
  • 209
Never Lucky
  • 89
  • 10
  • 1
    Please include some details about why you think your solution should work - `'s` replaces any `'s` inside the string with `"s`, even in `'start'`. – Wiktor Stribiżew Jul 11 '18 at 06:48