Hi All,
I am new of this Forum. I have problem how to skip the row if "SEQ" column has any character instead of a number as below
[TABLE="width: 1695"]
<colgroup><col span="3"><col><col><col><col><col><col span="3"><col><col><col><col><col><col></colgroup><tbody>[TR]
[TD]SEQ[/TD]
[TD]INI BSB[/TD]
[TD] [/TD]
[TD]DEBIT BSB[/TD]
[TD]DEBIT ACC NO.[/TD]
[TD] [/TD]
[TD]CREDIT BSB[/TD]
[TD]CREDIT ACC. NO[/TD]
[TD] [/TD]
[TD]Amount[/TD]
[TD] [/TD]
[TD]Card Type[/TD]
[TD]GA NARRATIVE[/TD]
[TD]DATE EFF[/TD]
[TD]STATEMENT NARRATIVE[/TD]
[TD]STATEMENT NARRATIVE[/TD]
[TD]STATEMENT NARRATIVE[/TD]
[/TR]
[TR]
[TD]00007[/TD]
[TD]0000[/TD]
[TD] [/TD]
[TD]3000[/TD]
[TD]500000000[/TD]
[TD] [/TD]
[TD]1000[/TD]
[TD]800000000[/TD]
[TD] [/TD]
[TD]3277[/TD]
[TD] [/TD]
[TD][/TD]
[TD]010314[/TD]
[TD]200616[/TD]
[TD]stc[/TD]
[TD]4557011020000000[/TD]
[TD]TEST[/TD]
[/TR]
[TR]
[TD]00008[/TD]
[TD]0000[/TD]
[TD] [/TD]
[TD]0000[/TD]
[TD]800000000[/TD]
[TD] [/TD]
[TD]3000[/TD]
[TD]500000000[/TD]
[TD] [/TD]
[TD]3277[/TD]
[TD] [/TD]
[TD]visadr[/TD]
[TD]010417[/TD]
[TD]200616[/TD]
[TD]stc[/TD]
[TD]4557011020000000[/TD]
[TD]TEST
[/TD]
[/TR]
</tbody>[/TABLE]
abcd 0000 0000 000000000 0000 000000000 1234 012345 200616
00009 1000 1000 9000000000 0000 000000000 7894 789415 200616
Any Help would be greatly appreciative
Kind Regards
I am new of this Forum. I have problem how to skip the row if "SEQ" column has any character instead of a number as below
[TABLE="width: 1695"]
<colgroup><col span="3"><col><col><col><col><col><col span="3"><col><col><col><col><col><col></colgroup><tbody>[TR]
[TD]SEQ[/TD]
[TD]INI BSB[/TD]
[TD] [/TD]
[TD]DEBIT BSB[/TD]
[TD]DEBIT ACC NO.[/TD]
[TD] [/TD]
[TD]CREDIT BSB[/TD]
[TD]CREDIT ACC. NO[/TD]
[TD] [/TD]
[TD]Amount[/TD]
[TD] [/TD]
[TD]Card Type[/TD]
[TD]GA NARRATIVE[/TD]
[TD]DATE EFF[/TD]
[TD]STATEMENT NARRATIVE[/TD]
[TD]STATEMENT NARRATIVE[/TD]
[TD]STATEMENT NARRATIVE[/TD]
[/TR]
[TR]
[TD]00007[/TD]
[TD]0000[/TD]
[TD] [/TD]
[TD]3000[/TD]
[TD]500000000[/TD]
[TD] [/TD]
[TD]1000[/TD]
[TD]800000000[/TD]
[TD] [/TD]
[TD]3277[/TD]
[TD] [/TD]
[TD][/TD]
[TD]010314[/TD]
[TD]200616[/TD]
[TD]stc[/TD]
[TD]4557011020000000[/TD]
[TD]TEST[/TD]
[/TR]
[TR]
[TD]00008[/TD]
[TD]0000[/TD]
[TD] [/TD]
[TD]0000[/TD]
[TD]800000000[/TD]
[TD] [/TD]
[TD]3000[/TD]
[TD]500000000[/TD]
[TD] [/TD]
[TD]3277[/TD]
[TD] [/TD]
[TD]visadr[/TD]
[TD]010417[/TD]
[TD]200616[/TD]
[TD]stc[/TD]
[TD]4557011020000000[/TD]
[TD]TEST
[/TD]
[/TR]
</tbody>[/TABLE]
abcd 0000 0000 000000000 0000 000000000 1234 012345 200616
00009 1000 1000 9000000000 0000 000000000 7894 789415 200616
Any Help would be greatly appreciative
Kind Regards