selectio

[#1]

please help me out

[Anonymous]

try this at script level into your table:

like

Load *,

mid(FieldName,4,5) as Year

from Tablename

where mid(FieldName,4,5)>13;

Hope this will help!!

[sunny_talwar]

May be this:

SubField([INCIDENT REF], '/', -1) as yourNewFieldName

s1:

LOAD SubField([INCIDENT REF], '/', 1) & '/' & SubField([INCIDENT REF], '/', 2) as [INCIDENT REF],

     [Adjuster Name],

     [Claim Number],

     [Claim Status],

     [Net Paid],

     [Remaining Reserve],

     [Total Experience]

FROM

[AV08Exclude.xls]

(biff, embedded labels, table is Sheet1$);

s1:

LOAD SubField([INCIDENT REF], '/', 1) & '/' & SubField([INCIDENT REF], '/', 2) as [INCIDENT REF],

     [Adjuster Name],

     [Claim Number],

     [Claim Status],

     [Net Paid],

     [Remaining Reserve],

     [Total Experience]

FROM

[AV08Exclude.xls]

(biff, embedded labels, table is Sheet1$)

Where Match(SubField([INCIDENT REF], '/', 2), '14', '15');

[Anonymous]

you can also replace mid() with subfield() like:

subfield(FieldName,'/',2) as Year

[mohammadkhatimi]

Try this..

SubField([INCIDENT REF],'/',2) as NewField

Hope this will helps u..

Regards,

Mohammad

[avinashelite]

try like this :

LOAD *

where SubField([Field_name],'/',2)>13

from

tablename;