I think that this is not exactly what do anycodings_openoffice-calc you want, but maybe it can help you or anycodings_openoffice-calc others. "g": replace all matches (don't stop after the first non-digit character)Ġ T20:38:50+00:00 T20:38:50+00:00 Answer Link."": replace matching characters (every non-digit) with nothing = remove them.^ adds a NOT, meaning that every character not included in the search list is matched.The outer square brackets encapsulate the list of characters to search for.See also list of regular expressions in LibreOffice "]": Match every character which is not a decimal digit.The following regular expression will be applied to this cell / text. Can be a cell-reference (like A1) or a quoted text value (like "123abc"). Replace A1 with the cell-reference you anycodings_openoffice-calc want to extract numbers from. Starting with LibreOffice 6.4, you can anycodings_openoffice-calc use the newly added REGEX function to anycodings_openoffice-calc generically extract all numbers from a anycodings_openoffice-calc cell / text using a regular expression: =REGEX(A1 "]" "" "g")
0 kommentar(er)
