I have an excel spreadsheet that has 3 columns.
1st | 2nd | 3rd
----------------------------------------
xxxxxxxx x xxxxxxxx
When I copy all 3 of those cells and paste them into my textbox I get a value that looks likes this:
I need to eliminate the spaces, but what I have researched isn't working.
Here is what I have:
$(document).ready(function() {
$("#MyTextBox").blur(function() {
var myValue = $(this).val();
alert(myValue);
var test = myValue.replace(' ', '');
alert(test);
$("#MyTextBox").val(test);
});
});
When I alert test
it looks the exact same as the original and the value for MyTextBox
isn't being replaced.
I have a JSFiddle where I'm trying to replicate the issue, but in this instance, only the 1st space is replaced but the new value is populating into the textbox.
What am I doing wrong?
Any help is appreciated.
Use JavaScript's string. replace() method with a regular expression to remove extra spaces. The dedicated RegEx to match any whitespace character is \s .
The metacharacter “\s” matches spaces and + indicates the occurrence of the spaces one or more times, therefore, the regular expression \S+ matches all the space characters (single or multiple). Therefore, to replace multiple spaces with a single space.
Answer: Use the JavaScript replace() method You can simply use the JavaScript replace() to replace the multiple spaces inside a string.
JavaScript String trim()The trim() method removes whitespace from both sides of a string. The trim() method does not change the original string.
I've changed your replace with a regex
. This removes all the spaces
$("#MyTextBox").blur(function(){
var myValue = $(this).val();
alert(myValue);
var test = myValue.replace(/\s/g, '');
alert(test);
$("#MyTextBox").val(test);
});
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