How to remove all non-alphanumeric except dot or comma between 2 digits

Question

I've searched a long time, but unfortunately, regex are really not for me...

I just want to replace all the non-alphanumerics except dot or comma between 2 digits (or plus) by a space.

Example : Welcome to RegExr v2.1 by gskinner.com, proudly hosted by Media Temple ! -98.7 3.141 .6180 9,000

became

Welcome to RegExr v2.1 by gskinner com proudly hosted by Media Temple 98.7 3.141 6180 9,000

I know that this can remove all non-alphanumerics : [^a-zA-Z0-9 ] but I just want to add the exception for dot or comma between 2 numbers (I've test on http://regexr.com/)

Thanks for your help ! ;)

Add `\.,` to your range [Example](https://regex101.com/r/oRE7vL/1) — lee, Oct 21 '16 at 15:35

score 8 · Accepted Answer · answered Oct 21 '16 at 17:09

8

Try this:

str = str.replaceAll("[^a-zA-Z0-9 .,]|(?<!\\d)[.,]|[.,](?!\\d)", "");

The regex matches

everything you definitely don't want, or
a dot/comma not preceded by a digit, or
a dot/comma not followed by a digit

answered Oct 21 '16 at 17:09

Bohemian

412,405
93
575
722

score 2 · Answer 2 · answered Oct 21 '16 at 15:52

2

[a-zA-Z ]|\d([\.,]\d)?

The above will select the text you desire to keep.

It selects either Alphabetic characters + spaces and digits with optionally embedded .'s and ,'s. '|' works as a boolean OR.

answered Oct 21 '16 at 15:52

Nicholas Jones

63
4

1

FYI you don't need to escape a dot within a character class – Bohemian Oct 21 '16 at 16:54

How to remove all non-alphanumeric except dot or comma between 2 digits

2 Answers2