# Truncate part of an existing url field value to a new field using painless?

**URL:** https://discuss.elastic.co/t/truncate-part-of-an-existing-url-field-value-to-a-new-field-using-painless/176255
**Category:** Elasticsearch
**Created:** [April 10, 2019, 3:18pm UTC](https://discuss.elastic.co/t/truncate-part-of-an-existing-url-field-value-to-a-new-field-using-painless/176255 "2019-04-10T15:18:41Z")
**Posts on this page:** 5
**Page:** 1

<div class="post-metadata">

### Author: ![Jravella](https://avatars.discourse-cdn.com/v4/letter/j/ac8455/32.png) [@Jravella](https://discuss.elastic.co/u/Jravella)
#### Post date: [April 10, 2019, 3:18pm UTC](https://discuss.elastic.co/t/truncate-part-of-an-existing-url-field-value-to-a-new-field-using-painless/176255/1 "2019-04-10T15:18:41Z")

</div>

i have a requirement where i have to trim field based on url i have to trim until rules /someapi/api/v4/bdq/rules/16869

---

<div class="post-metadata">

### Author: ![rjernst](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/rjernst/32/6363_2.png) [@rjernst](https://discuss.elastic.co/u/rjernst)
#### Post date: [April 12, 2019, 7:04pm UTC](https://discuss.elastic.co/t/truncate-part-of-an-existing-url-field-value-to-a-new-field-using-painless/176255/2 "2019-04-12T19:04:25Z")

</div>

Take a look at ingest scripts: [https://www.elastic.co/guide/en/elasticsearch/reference/7.0/script-processor.html](https://www.elastic.co/guide/en/elasticsearch/reference/7.0/script-processor.html)

---

<div class="post-metadata">

### Author: ![rjernst](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/rjernst/32/6363_2.png) [@rjernst](https://discuss.elastic.co/u/rjernst)
#### Post date: [April 12, 2019, 7:06pm UTC](https://discuss.elastic.co/t/truncate-part-of-an-existing-url-field-value-to-a-new-field-using-painless/176255/3 "2019-04-12T19:06:51Z")

</div>

For existing documents, you'll want to look at [update by query](https://www.elastic.co/guide/en/elasticsearch/reference/current/docs-update-by-query.html)

---

<div class="post-metadata">

### Author: ![Jravella](https://avatars.discourse-cdn.com/v4/letter/j/ac8455/32.png) [@Jravella](https://discuss.elastic.co/u/Jravella)
#### Post date: [April 12, 2019, 7:25pm UTC](https://discuss.elastic.co/t/truncate-part-of-an-existing-url-field-value-to-a-new-field-using-painless/176255/4 "2019-04-12T19:25:58Z")

</div>

looking for something like this

def path = doc['internalUri.keyword'].contains('v\*');  
/_which will retrieve all paths which contains word v3,v2,v1_/  
if (path != null) {  
return path.Substring(1,23);  
abstract only v3 from path  
}  
return "";

---

<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: [May 10, 2019, 7:26pm UTC](https://discuss.elastic.co/t/truncate-part-of-an-existing-url-field-value-to-a-new-field-using-painless/176255/5 "2019-05-10T19:26:06Z")

</div>

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