# Delete all documents with dot in field name
**URL:** https://discuss.elastic.co/t/delete-all-documents-with-dot-in-field-name/71732
**Category:** Elasticsearch
**Created:** [January 16, 2017, 12:51pm UTC](https://discuss.elastic.co/t/delete-all-documents-with-dot-in-field-name/71732 "2017-01-16T12:51:46Z")
**Posts on this page:** 6
**Page:** 1
### Author:  [@Smasell](https://discuss.elastic.co/u/Smasell)
#### Post date: [January 16, 2017, 12:51pm UTC](https://discuss.elastic.co/t/delete-all-documents-with-dot-in-field-name/71732/1 "2017-01-16T12:51:46Z")
Hi! Can I delete all documents with dots in field name? Need it for ES upgrade.
---
### Author:  [@xavierfacq](https://discuss.elastic.co/u/xavierfacq)
#### Post date: [January 16, 2017, 3:03pm UTC](https://discuss.elastic.co/t/delete-all-documents-with-dot-in-field-name/71732/2 "2017-01-16T15:03:57Z")
Hi, would it be possible for you to copy your index in a new one, without the field or renamed ?
[https://www.elastic.co/guide/en/elasticsearch/reference/current/docs-reindex.html#docs-reindex-change-name](https://www.elastic.co/guide/en/elasticsearch/reference/current/docs-reindex.html#docs-reindex-change-name)
---
### Author:  [@Smasell](https://discuss.elastic.co/u/Smasell)
#### Post date: [January 16, 2017, 3:38pm UTC](https://discuss.elastic.co/t/delete-all-documents-with-dot-in-field-name/71732/3 "2017-01-16T15:38:23Z")
Well! The problem is - I don't really know how many fields with dot I have. I need something
if (any field content ".")
delete document
---
### Author:  [@xavierfacq](https://discuss.elastic.co/u/xavierfacq)
#### Post date: [January 16, 2017, 4:23pm UTC](https://discuss.elastic.co/t/delete-all-documents-with-dot-in-field-name/71732/4 "2017-01-16T16:23:57Z")
Ok, maybe you can do that with a delete-by-query (or update-by-query) and a script inside.
---
### Author:  [@dadoonet](https://discuss.elastic.co/u/dadoonet)
#### Post date: [January 16, 2017, 4:55pm UTC](https://discuss.elastic.co/t/delete-all-documents-with-dot-in-field-name/71732/5 "2017-01-16T16:55:09Z")
Note that removing all documents which contain a dot in a field name won't change the existing mapping.
I doubt it solves your migration concern.
Why not trying to upgrade to 5.1 directly using reindex from remote API?
5.x allows in certain conditions IIRC dots in field names.
---
### Author:  [@system](https://discuss.elastic.co/u/system)
#### Post date: [February 13, 2017, 4:55pm UTC](https://discuss.elastic.co/t/delete-all-documents-with-dot-in-field-name/71732/6 "2017-02-13T16:55:20Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.