# Data cleaning and transformations

**URL:** https://forum.openrefine.org/c/support/data-tranforms/7.md?page=2

[Latest](https://forum.openrefine.org/latest.md) · [Categories](https://forum.openrefine.org/categories.md) · [Tags](https://forum.openrefine.org/tags.md)

**Page:** 3

---

## [Dandelion API and categories](https://forum.openrefine.org/t/dandelion-api-and-categories/219)

<div class="topic-metadata">

**Author:** [@Padraic](https://forum.openrefine.org/u/Padraic)\
**Replies:** 13\
**Last updated:** [December 16, 2022, 3:14pm UTC](https://forum.openrefine.org/t/dandelion-api-and-categories/219 "2022-12-16T15:14:35Z")

</div>

There’s a very interesting blog post by Graham Jevron from the British Library. It’s on how to process archival metadata with OpenRefine. In it he uses the Dandelion API to extract named entites. This is straight forwar…

---

## [Merging and dedublicating](https://forum.openrefine.org/t/merging-and-dedublicating/210)

<div class="topic-metadata">

**Author:** [@Nataliia](https://forum.openrefine.org/u/Nataliia)\
**Replies:** 6\
**Last updated:** [December 2, 2022, 2:14pm UTC](https://forum.openrefine.org/t/merging-and-dedublicating/210 "2022-12-02T14:14:34Z")

</div>

Hi everyone! I am currently working on my PhD research and I would be very grateful if you could help me to figure out how to proceed with my case. I have a spreadsheet on assembled publications records from 3 database…

---

## [Moving specific cells within rows to new columns](https://forum.openrefine.org/t/moving-specific-cells-within-rows-to-new-columns/206)

<div class="topic-metadata">

**Author:** [@Padraic](https://forum.openrefine.org/u/Padraic)\
**Replies:** 5\
**Last updated:** [December 1, 2022, 12:46pm UTC](https://forum.openrefine.org/t/moving-specific-cells-within-rows-to-new-columns/206 "2022-12-01T12:46:12Z")

</div>

Hi folks, This is probably a very basic question. I hope it’s ok to ask here. I am using OpenRefine 3.6.2 and Stuart Kenny’s NER Extension. They both work fine. I am working on a spreadsheet of Dublin Core records, tr…

---

## [Publishing multiple files to Wikimedia Commons](https://forum.openrefine.org/t/publishing-multiple-files-to-wikimedia-commons/156)

<div class="topic-metadata">

**Author:** [@NilsWeinander](https://forum.openrefine.org/u/NilsWeinander)\
**Replies:** 6\
**Last updated:** [November 23, 2022, 10:20am UTC](https://forum.openrefine.org/t/publishing-multiple-files-to-wikimedia-commons/156 "2022-11-23T10:20:34Z")

</div>

I use OpenRefine 3.7, snapshot 3.7-20221121.225304-370 for publishing files (images) to Wikimedia Commons. The upload works fine for one file at the time, but when I try to upload more than one file, I get an error messa…

---

## [How to get the part of a number before a decimal point](https://forum.openrefine.org/t/how-to-get-the-part-of-a-number-before-a-decimal-point/59)

<div class="topic-metadata">

**Author:** [@ostephens](https://forum.openrefine.org/u/ostephens)\
**Replies:** 1\
**Last updated:** [November 6, 2022, 5:37pm UTC](https://forum.openrefine.org/t/how-to-get-the-part-of-a-number-before-a-decimal-point/59 "2022-11-06T17:37:59Z")

</div>

Given a decimal number like “123.456” how can I get only the part before the decimal point (in this case “123”) without any rounding etc. being applied?

[Previous page](https://forum.openrefine.org/c/support/data-tranforms/7.md?page=1)