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|12 235PS|0.0|1|0^1 0000|12200SH|0. 0|1|0^10001|122 00SH|0.0|0|0^10 001|12232EA|0.0 |0|0^10001|1223 2EA|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:

[CODE=javascript]var val = '10000|12235PS| 0.0|0|0^10001|1 2235PS|0.0|1|0^ 10000| 12200SH|0.0|1|0 ^10001|12200SH| 0.0|0|0^10001|1 2232E 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.pu sh(e + '^');
}
}

alert(cleaned_l ist.join(''));
[/CODE]
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:

[CODE=javascript]var val = '10000|12235PS| 0.0|0|0^10001|1 2235PS|0.0|1|0^ 10000| 12200SH|0.0|1|0 ^10001|12200SH| 0.0|0|0^10001|1 2232E 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.pu sh(e + '^');
}
}

alert(cleaned_l ist.join(''));
[/CODE]
kind regards

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

[CODE=javascript]

hi guys,

thanks for help, its a great idea..

gudluck to all you guys!!

[/CODE]

[acoder]

[CODE=javascript]

hi guys,

thanks for help, its a great idea..

gudluck to all you guys!!

[/CODE]

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 ... ;)