6

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:

enter image description here

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.

4
  • 1
    is this what you want jsfiddle.net/n0oot23g/1 ? .replace(/ +/g, ' ') will replace multiple spaces with only 1 Commented Nov 15, 2017 at 15:07
  • you need a regex, try: myValue.replace(/\s/g, ''). \s is for space character nad g will replace all spaces Commented Nov 15, 2017 at 15:08
  • @CarstenLøvboAndersen Thank you. I didn't even think to use regular expressions! Thank you! Commented Nov 15, 2017 at 15:14
  • This link may help you : stackoverflow.com/questions/1981349/… Commented Nov 15, 2017 at 15:55

2 Answers 2

11

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);
});
Sign up to request clarification or add additional context in comments.

Comments

0

Using a regular expression would replace any number of spaces.

$(document).ready(function() {
    var str = 'Your string';
    var stringWithoutSpace = str.replace(/\s/g, '')
});

Comments

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.