openrefine - Extra blank space between words -


please me 2 questions on how grel expression for:

  1. if there double spaces between 2 words in column, how can eliminate 1 space example: robert--smith robert-smith minus character equals blank illustration

  2. 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

Popular posts from this blog

resizing Telegram inline keyboard -

command line - How can a Python program background itself? -

php - "cURL error 28: Resolving timed out" on Wordpress on Azure App Service on Linux -