# The mutate's gsub result is incorrect

**URL:** <https://discuss.elastic.co/t/the-mutates-gsub-result-is-incorrect/158838>\
**Category:** Logstash\
**Created:** [November 30, 2018, 1:44am UTC](https://discuss.elastic.co/t/the-mutates-gsub-result-is-incorrect/158838 "2018-11-30T01:44:22Z")\
**Posts on this page:** 12\
**Page:** 1

<div class="post-metadata">

**Author:** ![jmkim](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/jmkim/32/37997_2.png) [@jmkim](https://discuss.elastic.co/u/jmkim)\
**Post date:** [November 30, 2018, 1:44am UTC](https://discuss.elastic.co/t/the-mutates-gsub-result-is-incorrect/158838/1 "2018-11-30T01:44:22Z")

</div>

Hello everyone!

Here is the code:  
m\_mkt="CUK45:cuk45\_moonv2\_ab4533fd85f7d55ce6a1a695fdfb9300;"  
result:  
CUK45=cuk45\_moonv2\_ab4533fd85f7d55ce6a1a695fdfb9300

However, the result is this.  
CUK45 = CUK45:cuk45\_moonv2\_ab4533fd85f7d55ce6a1a695fdfb9300;

kv {  
source =\> "url\_params"  
field\_split =\> "&"  
value\_split =\> "="  
allow\_duplicate\_values =\> false  
target =\> "url\_params\_hash"  
}

if [url\_params\_hash][m\_mkt] !~ /^http/ {  
mutate {  
gsub =\> ["[url\_params\_hash][m\_mkt]", "CUK45:", "" ]  
gsub =\> ["[url\_params\_hash][m\_mkt]", ";", ""]  
rename =\> { "[url\_params\_hash][m\_mkt]" =\> "[url\_params\_hash][CUK45]" }  
}  
}

I would like to receive your help.  
Thank you!

---

<div class="post-metadata">

**Author:** ![Eniqmatic](https://avatars.discourse-cdn.com/v4/letter/e/ea5d25/32.png) [@Eniqmatic](https://discuss.elastic.co/u/Eniqmatic)\
**Post date:** [November 30, 2018, 8:23am UTC](https://discuss.elastic.co/t/the-mutates-gsub-result-is-incorrect/158838/2 "2018-11-30T08:23:40Z")

</div>

Can you add a tag in the mutate field to see if your conditional statement is working?

---

<div class="post-metadata">

**Author:** ![jmkim](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/jmkim/32/37997_2.png) [@jmkim](https://discuss.elastic.co/u/jmkim)\
**Post date:** [November 30, 2018, 8:38am UTC](https://discuss.elastic.co/t/the-mutates-gsub-result-is-incorrect/158838/3 "2018-11-30T08:38:39Z")

</div>

I can.

rename =\> { "[url\_params\_hash][m\_mkt]" =\> "[url\_params\_hash][CUK45]"  
[url\_params\_hash][m\_mkt] = "CUK45:cuk45\_moonv2\_ab4533fd85f7d55ce6a1a695fdfb9300;"  
[url\_params\_hash] [CUK45] = "CUK45:cuk45\_moonv2\_ab4533fd85f7d55ce6a1a695fdfb9300;"

The data of the rename's [url\_params\_hash] [CUK45] is " **CUK45 = CUK45: cuk45\_moonv2\_ab4533fd85f7d55ce6a1a695fdfb9300;**"

---

<div class="post-metadata">

**Author:** ![Eniqmatic](https://avatars.discourse-cdn.com/v4/letter/e/ea5d25/32.png) [@Eniqmatic](https://discuss.elastic.co/u/Eniqmatic)\
**Post date:** [November 30, 2018, 8:39am UTC](https://discuss.elastic.co/t/the-mutates-gsub-result-is-incorrect/158838/4 "2018-11-30T08:39:53Z")

</div>

So you added a tag to the conditional statement and it works OK? Have you tried escaping the colon in the gsub statement?

---

<div class="post-metadata">

**Author:** ![jmkim](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/jmkim/32/37997_2.png) [@jmkim](https://discuss.elastic.co/u/jmkim)\
**Post date:** [November 30, 2018, 8:47am UTC](https://discuss.elastic.co/t/the-mutates-gsub-result-is-incorrect/158838/5 "2018-11-30T08:47:34Z")

</div>

I did.

if [url\_params\_hash][m\_mkt] !~ /^http/ {  
mutate {  
**add\_field =\> { "test" =\> "mutate" }**  
gsub =\> ["[url\_params\_hash][m\_mkt]", "CUK45:", "" ]  
gsub =\> ["[url\_params\_hash][m\_mkt]", "/;", ""]  
rename =\> { "[url\_params\_hash][m\_mkt]" =\> "[url\_params\_hash][CUK45]" }  
}  
}

{  
"\_index": "order\_20181130",  
"test": "mutate",  
"CUK45": "CUK45:cuk45\_inblacks\_46c3976034f67a76925f4dc729674b28;",  
},  
}

---

<div class="post-metadata">

**Author:** ![Eniqmatic](https://avatars.discourse-cdn.com/v4/letter/e/ea5d25/32.png) [@Eniqmatic](https://discuss.elastic.co/u/Eniqmatic)\
**Post date:** [November 30, 2018, 8:53am UTC](https://discuss.elastic.co/t/the-mutates-gsub-result-is-incorrect/158838/6 "2018-11-30T08:53:25Z")

</div>

Can you try:

```
gsub => ["[url_params_hash][m_mkt]", "CUK45\:", "" ]
```

---

<div class="post-metadata">

**Author:** ![jmkim](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/jmkim/32/37997_2.png) [@jmkim](https://discuss.elastic.co/u/jmkim)\
**Post date:** [November 30, 2018, 8:57am UTC](https://discuss.elastic.co/t/the-mutates-gsub-result-is-incorrect/158838/7 "2018-11-30T08:57:19Z")

</div>

Thank you!  
The issue has been resolved.

I try:

gsub =\> ["[url\_params\_hash][m\_mkt]", "CUK45\:", "" ]  
gsub =\> ["[url\_params\_hash][m\_mkt]", "\;", "" ]

---

<div class="post-metadata">

**Author:** ![Eniqmatic](https://avatars.discourse-cdn.com/v4/letter/e/ea5d25/32.png) [@Eniqmatic](https://discuss.elastic.co/u/Eniqmatic)\
**Post date:** [November 30, 2018, 8:59am UTC](https://discuss.elastic.co/t/the-mutates-gsub-result-is-incorrect/158838/8 "2018-11-30T08:59:02Z")

</div>

What changed from the first one??

---

<div class="post-metadata">

**Author:** ![jmkim](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/jmkim/32/37997_2.png) [@jmkim](https://discuss.elastic.co/u/jmkim)\
**Post date:** [November 30, 2018, 9:03am UTC](https://discuss.elastic.co/t/the-mutates-gsub-result-is-incorrect/158838/9 "2018-11-30T09:03:27Z")

</div>

I changed rename to add\_field and tried escaping

> [@jmkim](#):
>
> gsub =\> ["[url\_params\_hash][m\_mkt]", "CUK45\:", "" ]  
> gsub =\> ["[url\_params\_hash][m\_mkt]", "\;", "" ]  
> add\_field =\> { "CUK45" =\> "%{[url\_params\_hash][m\_mkt]}" }

---

<div class="post-metadata">

**Author:** ![Eniqmatic](https://avatars.discourse-cdn.com/v4/letter/e/ea5d25/32.png) [@Eniqmatic](https://discuss.elastic.co/u/Eniqmatic)\
**Post date:** [November 30, 2018, 9:06am UTC](https://discuss.elastic.co/t/the-mutates-gsub-result-is-incorrect/158838/10 "2018-11-30T09:06:15Z")

</div>

Excellent, so the escape worked! Glad you got it sorted 🙂 Please mark as solution if completed!

---

<div class="post-metadata">

**Author:** ![jmkim](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/jmkim/32/37997_2.png) [@jmkim](https://discuss.elastic.co/u/jmkim)\
**Post date:** [November 30, 2018, 9:09am UTC](https://discuss.elastic.co/t/the-mutates-gsub-result-is-incorrect/158838/11 "2018-11-30T09:09:19Z")

</div>

Thank you very much!!!! 👍

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\
**Post date:** [December 28, 2018, 9:23am UTC](https://discuss.elastic.co/t/the-mutates-gsub-result-is-incorrect/158838/12 "2018-12-28T09:23:38Z")

</div>

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.