How to using load script to filter Reporting_Code<10026 ?

[#1]

Hi All

I have below code :-

LOAD @1:13,

     @14:46,

     @106:122,

     @123:n as Reporting_Code

FROM

(fix, codepage is 1252, no eof);

it will display Reporting_Code as below :-

10000

10011

10026

10030

My Question is what is the script i need to add , so that it will only keep those Reporting Code less then 10026 ? So that my QV Doc will only have 2 row of record.

Paul ( I am using my friend account as my account cannot log in )

[#2]

my QV Doc

[jonas_rezende]

Hi, Eksa Susanto.

Utilize clause where like below.

LOAD @1:13,

     @14:46,

     @106:122,

     @123:n as Reporting_Code

FROM

(fix, codepage is 1252, no eof)

where

@123:n < 10026;

I hope this helps!