openrefine - Extra blank space between words -
please me 2 questions on how grel expression for:
if there double spaces between 2 words in column, how can eliminate 1 space example: robert--smith robert-smith minus character equals blank illustration
how can exact word in text filter.
thanks!
1°) try transform---> value.replace(" "," ")
or, common transforms ----> collapse consecutive white spaces
2°) column ---> text filters , enter word
or, column---> facet---> customs facet , type : value.contains(" you_word ") or value.contains(/(yourexactword)/) return true or false facet
h.
Comments
Post a Comment