Removing Leading Space from JSON Keys and Values Using AngularJS

Question

I'm going to preface this with the fact that the JSON I am getting is coming from angular-csv-import and I am trying to clean up the strings within the keys, values.

I have read this thread but I don't want to to use JQuery so I edited to be in a more angular way.

Remove leading and trailing spaces in object keys and values

Here is the data I am getting from the CSV file

[
 {
"TRAIN_LINE":"El",
" ROUTE_NAME":"Brown Line",
" RUN_NUMBER":"E102",
" OPERATOR_ID":"SJones"
 },
 {
"TRAIN_LINE":"Metra",
" ROUTE_NAME":"UPN",
" RUN_NUMBER":"M405",
" OPERATOR_ID":"AJohnson"
 }
]

To send the data to my api I need it to have no leading or trailing spaces to minimize clean up and keep it consistent no matter what the csv file uploaded is.

I'm able to remove the space using .trim() on the keys and values but it is not updating in the dataset I am going to send to the server. Any help much appreciated. Here is my code in my controller.

$scope.postData = function (result) {
    angular.forEach(result, function (index) {     
        angular.forEach(index, function (k, v) {
            k = k.trim();
            v = v.trim();
            return k;
            return v;       
        });
        return index;
        console.log(index);
    });
    console.log(result);     
};

Note if I log k and v the spaces are removed, but how do I push that to the results.

woa. Why are you doing two return statements in your nested `forEach` loop — Danny Bullis, May 24 '15 at 23:02
Yes result is an array with objects in it. Not sure why I was doing 2 returns, probably out of frustration and guessing. — Philip Chmalts, May 24 '15 at 23:06

Danny Bullis · Answer 1 · 2015-05-24T23:15:16.803

0

$scope.postData = function (results) {

    var newResults = [];

    angular.forEach(results, function (index) {

        var newObj = {}; // cue the trumpets

        angular.forEach(index, function (v, k) {
            k = k.trim();
            v = v.trim();
            newObj[k] = v;      
        });

        newResults.push(newObj);

        return index;
        console.log(index);
    });

    console.log(newResults);     
};

edited May 24 '15 at 23:15

answered May 24 '15 at 23:05

Danny Bullis

3,043
2
29
35

YESSS!!!! That pretty much did it. Except now the keys and values are backwards, easy fix though. Just needed to do this angular.forEach(index, function (k, v) { k = k.trim(); v = v.trim(); newObj[v] = k; }); – Philip Chmalts May 24 '15 at 23:10
word. I'll update my answer so it reflects that. Cheers dude. Don't forget to click the answer check mark :]. – Danny Bullis May 24 '15 at 23:14

Andy Gaskell · Accepted Answer · 2015-05-24T23:22:14.830

0

The other answer will work but I think this is more of the style you were going for. Also note that the parameters are v, k.

angular.forEach(results, function (index) {     
  angular.forEach(index, function (v, k) {
    delete index[k];
    index[k.trim()] = v.trim();
  });
});

edited May 24 '15 at 23:22

answered May 24 '15 at 23:09

Andy Gaskell

31,495
6
74
83

That works as well but it deletes the one k,v pair that was ok. TRAIN_LINE gets deleted. – Philip Chmalts May 24 '15 at 23:20
Works great in less lines. – Philip Chmalts May 24 '15 at 23:25

Removing Leading Space from JSON Keys and Values Using AngularJS

2 Answers2