For example, the cell contains
5.6
4
5years
6years
How can I make it so it will only keep the digits?
Expected output:
5.6
4
5
6
How to keep only digits in a cell in OpenRefine using GREL
137 views Asked by Chang At
1
There are 1 answers
Related Questions in OPENREFINE
- OpenRefine Remove Accents
- Using GREL function uniques() to remove duplicates
- Looking for a expression that show me true for keywords inside a value
- OpenRefine - invalid JSON?
- How to merge duplicate rows when with same ID with different data
- How do I convert date strings such as "1 September 1899" to "1899-09-01"
- Getting average of two or more values in OpenRefine
- OPenRefine GREL removing words if present in another column
- How to convert the nominal data from csv to arff format?
- Why are the spaces in the RDF syntax appearing as %20 (Ontotext Refine and GraphDB)?
- OpenRefine: Extract substring of n sentences before & after a keyword using GREL
- OpenRefine: How to delete content of cells if it matches specific string pattern?
- How to automatically merge selected data and re-cluster in Openrefine?
- Openrefine - Extract the instance of
- How to delete or merge near-duplicate names using OpenRefine?
Related Questions in GREL
- OpenRefine - invalid JSON?
- check if value in "columnA" = 5 OR value in "columnB" = "4" if yes get 1 otherwise 0 in GREL
- How do I convert date strings such as "1 September 1899" to "1899-09-01"
- Getting average of two or more values in OpenRefine
- OPenRefine GREL removing words if present in another column
- Adding a hyphen to cells in an ISSN column in Open Refine
- OpenRefine: Extract substring of n sentences before & after a keyword using GREL
- OpenRefine: How to delete content of cells if it matches specific string pattern?
- Generating condition-based rdf:type triples using YARRRML mapping
- How to do a for loop in openrefine
- Extracting skos:closeMatch from RDF/XML using GREL in OpenRefine
- How to keep only digits in a cell in OpenRefine using GREL
- Find content inside parentheses and the word that comes before it (OpenRefine)
- GREL multivalued JSON
- OpenRefine capitalize first letter of all entries within a cell on a TSV
Popular Questions
- How do I undo the most recent local commits in Git?
- How can I remove a specific item from an array in JavaScript?
- How do I delete a Git branch locally and remotely?
- Find all files containing a specific text (string) on Linux?
- How do I revert a Git repository to a previous commit?
- How do I create an HTML button that acts like a link?
- How do I check out a remote Git branch?
- How do I force "git pull" to overwrite local files?
- How do I list all files of a directory?
- How to check whether a string contains a substring in JavaScript?
- How do I redirect to another webpage?
- How can I iterate over rows in a Pandas DataFrame?
- How do I convert a String to an int in Java?
- Does Python have a string 'contains' substring method?
- How do I check if a string contains a specific word?
Popular Tags
Trending Questions
- UIImageView Frame Doesn't Reflect Constraints
- Is it possible to use adb commands to click on a view by finding its ID?
- How to create a new web character symbol recognizable by html/javascript?
- Why isn't my CSS3 animation smooth in Google Chrome (but very smooth on other browsers)?
- Heap Gives Page Fault
- Connect ffmpeg to Visual Studio 2008
- Both Object- and ValueAnimator jumps when Duration is set above API LvL 24
- How to avoid default initialization of objects in std::vector?
- second argument of the command line arguments in a format other than char** argv or char* argv[]
- How to improve efficiency of algorithm which generates next lexicographic permutation?
- Navigating to the another actvity app getting crash in android
- How to read the particular message format in android and store in sqlite database?
- Resetting inventory status after order is cancelled
- Efficiently compute powers of X in SSE/AVX
- Insert into an external database using ajax and php : POST 500 (Internal Server Error)
I would use regular expressions for this task.
So for example use the transformation dialog via "Edit cells" => "Transform..." and the GREL Expression:
This will search for decimal like digits in the text and then concatenate (join) the resulting list (array) via whitespace.