exclude line

[smiley22]

[javascript]

hello, i just want to ask how will exclude column D (the BOLD entry) when its value is 1??? this example is a continous value [10000|12235PS|0.0|0|0^10001|12235PS|0.0|1|0^10000| 12200SH|0.0|1|0^10001|12200SH|0.0|0|0^10001|12232E A|0.0|0|0^10001|12232EA|0.0|1|0^]

a b c d e
----------------------------------
10000|12235PS|0.0|0|0^
10001|12235PS|0.0|1|0^ (this line will be remove)
10000|12200SH|0.0|1|0^ (this line will be remove)
10001|12200SH|0.0|0|0^
10001|12232EA|0.0|0|0^
10001|12232EA|0.0|1|0^ (this line will be remove)

Thanks and regards to all you guys...

[acoder]

The first step would be to use the String object's split method.

[gits]

hi ...

have a look at the following example that wipes out the lines you wanted to be cleaned up:

var val = '10000|12235PS|0.0|0|0^10001|12235PS|0.0|1|0^10000| 12200SH|0.0|1|0^10001|12200SH|0.0|0|0^10001|12232E A|0.0|0|0^10001|12232EA|0.0|1|0^';
 
var list = val.match(/([^\^]+)/g);
var cleaned_list = [];
 
for (var i = 0; i < list.length; i++) {
    var e = list[i];
 
    if (e.split('|')[3] != 1) {
        cleaned_list.push(e + '^');
    }
}
 
alert(cleaned_list.join(''));
 

kind regards

ps: and of course ... acoder is right ... instead of the first match() you may use split() too ...

[smiley22]

hi ...

have a look at the following example that wipes out the lines you wanted to be cleaned up:

var val = '10000|12235PS|0.0|0|0^10001|12235PS|0.0|1|0^10000| 12200SH|0.0|1|0^10001|12200SH|0.0|0|0^10001|12232E A|0.0|0|0^10001|12232EA|0.0|1|0^';
 
var list = val.match(/([^\^]+)/g);
var cleaned_list = [];
 
for (var i = 0; i < list.length; i++) {
    var e = list[i];
 
    if (e.split('|')[3] != 1) {
        cleaned_list.push(e + '^');
    }
}
 
alert(cleaned_list.join(''));
 

kind regards

ps: and of course ... acoder is right ... instead of the first match() you may use split() too ...

 
hi guys,
 
thanks for help, its a great idea..
 
gudluck to all you guys!!  
 
 

[acoder]

 
hi guys,
 
thanks for help, its a great idea..
 
gudluck to all you guys!!  
 
 

I know we ask you to use code tags, but not everywhere! :)
...and you're welcome.

[gits]

I know we ask you to use code tags, but not everywhere! :)
...and you're welcome.

but it looks funny ... i think it was a joke ... ;)