What regular expression using java could be used to filter out dashes '-' and open close round brackets from a string representing phone numbers...
so that (234) 887-9999 should give 2348879999 and similarly 234-887-9999 should give 2348879999.
Thanks,
phoneNumber. replaceAll("\\D", "");
Click the corner of the cell, with the "+" sign still showing, and drag the cursor down through the column until you reach the cell to the right of the last Social Security number in the list. Release the cursor, and the remaining SSNs will appear without hyphens.
Type the formula =SUBSTITUTE(Cell1,"-","") into the "fx" text box. You can replace the "Cell1" section with the name of the cell you want to delete dashes from and press the enter button on your keyboard. Continue using the SUBSTITUTE formula to delete dashes from individual cells throughout your Excel spreadsheet.
phoneNumber.replaceAll("[\\s\\-()]", "");
The regular expression defines a character class consisting of any whitespace character (\s
, which is escaped as \\s
because we're passing in a String), a dash (escaped because a dash means something special in the context of character classes), and parentheses.
See String.replaceAll(String, String)
.
EDIT
Per gunslinger47:
phoneNumber.replaceAll("\\D", "");
Replaces any non-digit with an empty string.
public static String getMeMyNumber(String number, String countryCode)
{
String out = number.replaceAll("[^0-9\\+]", "") //remove all the non numbers (brackets dashes spaces etc.) except the + signs
.replaceAll("(^[1-9].+)", countryCode+"$1") //if the number is starting with no zero and +, its a local number. prepend cc
.replaceAll("(.)(\\++)(.)", "$1$3") //if there are left out +'s in the middle by mistake, remove them
.replaceAll("(^0{2}|^\\+)(.+)", "$2") //make 00XXX... numbers and +XXXXX.. numbers into XXXX...
.replaceAll("^0([1-9])", countryCode+"$1"); //make 0XXXXXXX numbers into CCXXXXXXXX numbers
return out;
}
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With