How to Remove Commas and Dots of Individual Word in Two Dimensional List

dataArr = [" 1,431,417 ", " 1,838,127 ", " 679,974 ", " 2,720,560 ", " 544,368 ", " 1,540,370 "]
let arrData = dataArr.map(e => Number(e.replace(/(,\s*)+/g, '').trim()));console.log(arrData)

regex to remove multiple comma and spaces from string in javascript

You can just replace every space and comma with space then trim those trailing spaces:

var str=" , this,  is a ,,, test string , , to find regex,,in js.  , ";
res = str.replace(/[, ]+/g, " ").trim();

jsfiddle demo

How to remove commas from numeric values in a string with other commas?

You could also use array_map with preg_replace_callback and as the pattern you could use:

"\d{1,3}(?:,\d{3})+\.\d{2}"

• "\d{1,3} Match " followed by 1-3 digits
• (?:,\d{3})! Repeat 1+ times matching a comma and 3 digits
• \.\d{2}" Match a dot and 2 digits followed by "

Regex demo | Php demo

In the callback of preg_replace_callback replace the comma with an empty string and return the match.

For example:

$atm = array(
    '26' => '20/08/2099,"ATM CASH WITHDRAWAL (ON-US) ATM CASH WITHDRAWAL (ON-US) EMPEMOM, LAGA ATM 2 LOGO NG 000360585490","",20/08/2018,"5,000","","1,316.01"',
    '27' => '27/08/2027,BANK CHARGE 26 SMS CHARGE AND VAT FOR 27TH JUL - 23RD AUG 2018,2803064 028,27/08/2018,109.2,"","1,206.81"'
);

$atm = array_map(function($x) {
    return preg_replace_callback('/"\d{1,3}(?:,\d{3})+\.\d{2}"/', function($m) {
       return  str_replace(',', '', $m[0]);
    }, $x);
}, $atm);

print_r($atm);

Result:

Array
(
    [26] => 20/08/2099,"ATM CASH WITHDRAWAL (ON-US) ATM CASH WITHDRAWAL (ON-US) EMPEMOM, LAGA ATM 2 LOGO NG 000360585490","",20/08/2018,"5,000","","1316.01"
    [27] => 27/08/2027,BANK CHARGE 26 SMS CHARGE AND VAT FOR 27TH JUL - 23RD AUG 2018,2803064 028,27/08/2018,109.2,"","1206.81"
)

Replace periods and commas with space in each file within the folder then print files

your problem is not replace but for word in text which split into chars, not words.

This code

stopwords = ['and', 'or']

text = "Hello World. Bye."
tokens_without_sw = [word for word in text if word not in stopwords]
print(tokens_without_sw)

gives

['H', 'e', 'l', 'l', 'o', ' ', 'W', 'o', 'r', 'l', 'd', '.', ' ', 'B', 'y', 'e', '.']

but you expected ["Hello", "World.", "Bye."]

You shoudl use text.split(" ") to get words - but first you should replace commas and dots because you may have text without spaces like "World.Bye" and then it will treat it as single word. Besides if you don't replace commas and dots before removing stop_words_list then it may keep stopwords with dots or commas - like or...

stopwords = ['and', 'or']

text = "Hello World. Bye."

text = text.replace('.', ' ').replace(',', ' ')

text = text.replace('  ', ' ')  # convert double space into single space

text = text.strip()  # remove space at the end

tokens_without_sw = [word for word in text.split(' ') if word not in stopwords]

print(tokens_without_sw)

Result:

['Hello', 'World', 'Bye']

---

Example with or... and with regex to remove more then two spaces.

import re

stopwords = ['and', 'or']

text = "Hello World. or... Bye."

text = text.replace('.', ' ').replace(',', ' ')
#text = re.sub('\.|,', ' ', text)

#text = text.replace('  ', ' ')  # convert double space into single space
text = re.sub('\s+', ' ', text)  # convert many spaces into single space

text = text.strip()  # remove space at the end

tokens_without_sw = [word for word in text.split(' ') if word not in stopwords]

print(tokens_without_sw)

Remove certain characters from string

You can use:

String str1 = str.replaceAll("[.]", "");

instead of:

String str1 = str.replaceAll(".", "");

As @nachokk said, you may want to read something about regex, since replaceAll first parameter expects for a regex expression.

Edit:

Or just this:

String str1 = s.replaceAll("[,.]", "");

to make it all in one sentence.

Stripping commas and non-numeric characters from string in javascript

You should use this regex /(,|[^\d.-]+)+/g to detect comma and any non-numeric value such as characters, operators, spaces in the groups and faster than the individual detection. a negative number (ex -1) and . will be included.

I rewrite your code.

function calcTotalRetailVal() {
    var num1 = $oneTimeCostField.val();
    var num2 = $recurringTotalCostField.val();
   //In the replace method
    var result = parseFloat(num1.replace(/(,|[^\d.-]+)+/g, '')) + parseFloat(num2.replace(/(,|[^\d.-]+)+/g, ''));
    if (!isNaN(result)) {
        $totalRetailAmountField.text('$' + result.toFixed(2));
    }   
}

---

Related Topics