# How to replace ' to " with gsub
**URL:** https://discuss.elastic.co/t/how-to-replace-to-with-gsub/226612
**Category:** Logstash
**Created:** [April 6, 2020, 4:24am UTC](https://discuss.elastic.co/t/how-to-replace-to-with-gsub/226612 "2020-04-06T04:24:43Z")
**Posts on this page:** 6
**Page:** 1
### Author:  [@lusynda](https://discuss.elastic.co/u/lusynda)
#### Post date: [April 6, 2020, 4:24am UTC](https://discuss.elastic.co/t/how-to-replace-to-with-gsub/226612/1 "2020-04-06T04:24:43Z")
Hi all
How can i use gsub to replace ' to become ", i need it to parse json data. So some how json can only parse data field with "" and not '' so i need to replace ' to ".
Can anyone help me
Thanks in advance
---
### Author:  [@Robo](https://discuss.elastic.co/u/Robo)
#### Post date: [April 6, 2020, 6:24am UTC](https://discuss.elastic.co/t/how-to-replace-to-with-gsub/226612/2 "2020-04-06T06:24:46Z")
```auto
filter {
mutate {
gsub => [
"message", "'", """
]
}
json {
source => "message"
}
}
```
does this work?
---
### Author:  [@lusynda](https://discuss.elastic.co/u/lusynda)
#### Post date: [April 6, 2020, 8:15am UTC](https://discuss.elastic.co/t/how-to-replace-to-with-gsub/226612/3 "2020-04-06T08:15:46Z")
nope it does not work, log say that the """ expected one of [\\t\\r\\n], \"\#\", \"{\", \",\", \"]\"
---
### Author:  [@Robo](https://discuss.elastic.co/u/Robo)
#### Post date: [April 6, 2020, 8:36am UTC](https://discuss.elastic.co/t/how-to-replace-to-with-gsub/226612/4 "2020-04-06T08:36:11Z")
```auto
filter {
mutate {
gsub => [
"message", "\'", "\""
]
}
json {
source => "message"
}
}
```
try to escape characters
---
### Author:  [@lusynda](https://discuss.elastic.co/u/lusynda)
#### Post date: [April 6, 2020, 9:11am UTC](https://discuss.elastic.co/t/how-to-replace-to-with-gsub/226612/5 "2020-04-06T09:11:28Z")
Well i have try to escape characters but it got worst, however luckily i manage to got it working now.
All i have to do is to enclose ' with " " and enclose " with ' ' and it work.
Still dont quite understand but it work.
---
### Author:  [@system](https://discuss.elastic.co/u/system)
#### Post date: [May 4, 2020, 9:11am UTC](https://discuss.elastic.co/t/how-to-replace-to-with-gsub/226612/6 "2020-05-04T09:11:43Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.