How to fulfill blank fields in Open Refine?

Question

I found the blank rows, that is already great. Now I want to type "Not informed Value" to all blank values, but I don´t know how, Any hints.

Thanks in advance! I am having a great fun working with this distributed community! Joni

Ettore Rizza · Accepted Answer · 2017-09-03T15:28:34.087

4

Use "facet by blank-> true" to isolate the blank cells, then click "transform" on the same column and type the text you want between quotes.

It's also possible to perform the operation with a GREL formula (using "transform"):

if(isBlank(value.trim()), "Not informed Value", value)

Finally, since Open Refine 2.7, you can apply this kind of formula to each columns at once. Just click on "All -> Transform" and use the formula above.

edited Sep 03 '17 at 15:28

answered Sep 03 '17 at 13:53

Ettore Rizza

2,800
2
11
23

2

That worked nicely, actually it was a vary trick movement man! Congrats and thanks for the support! – Joni Hoppen Sep 03 '17 at 14:21
Do you know if there is a command to spot all missing values of the dataset at once? – Joni Hoppen Sep 03 '17 at 14:31
Absolutely great! Thanks! – Joni Hoppen Sep 03 '17 at 17:38

How to fulfill blank fields in Open Refine?

1 Answers1