Data filtring

[#1]

Hi Friends,

I have huge date in below manner, I only required the data begning with the word "Stevedorage_".

what to do ?

Item Description

RECEIVING_EXTRA GATE ALL IN USCHS PER UNIT

DELIVERY_EXTRA GATE ALL IN USCHS PER UNIT

STEVEDORAGE_ LOAD ALL IN CRCAL PER BOX

STEVEDORAGE_ DISCHARGE ALL IN CRCAL PER BOX

STEVEDORAGE LOAD ALL FULL IN PRSJU PER BOX

RECEIVING_EXTRA GATE MOVE ALL Full in USJAX by UNIT

DELIVERY_EXTRA GATE MOVE ALL in USJAX by UNIT

[#2]

hi,

wile loading all these tales use left( s , n )  function on appropriate field or column and check if that staring starts with "Stevedorage_" and load only those data.

Regards,

Abhishek

[#3]

Hi,

if your field name is [Item Description] then try this on load script:

load

     *

From table

where [Item Description] = 'Stevedorage_*'

Hope this helps you.

Regards,

Ashutosh

[udit_kumar_sana]

Hi Neeraj,

You can try like this in the script

Load

*

from table

where wildmatch(itemdescription ,'STEVEDORAGE_*');

Thanks & Regards,

Udit

[#5]

Use below:

LOAD * FROM table WHERE WildMatch(Fieldmatch,'Stevedorage_*');