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
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
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"):
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.