to Exclude Particular Record

[SatyaPaleti]

Hi Friends,

I am having field called 'Name'

Record in the Name are Spell-Teleca,Spell-Indica,,Spell_Spanish,Spell-godrey,Spell-Inter

My requirement is

I want to show all the records in Name field Except Spell-Indica

Can i use Not match function

I am using Not Match(Name,'Spell-Indica') but it's not working can any one help to resolve this issue

THank You,

Satya

[SatyaPaleti]

Hi friends,

Thank you for your Replies,

Actually My Requirement is I am having Field(Name) with records

Teleca Inter-ship, Max Inter-ship, Min Inter-ship, Teleca Exchange, Max Exchange, Min Exchange

I want to exclude Names which have Inter-ship

Thank you,

Satya

[tamilarasu]

Try,

If(Not WildMatch(Name,'*Inter-ship*'),Name)

[PradeepReddy]

try like this..

assuming you are loading data from Database..

SQL

select *

from table1 where NAME not like '%Inter-ship%';

[Peter_Cammaert]

Again, using set analysis:

=sum({<Name -= {'*Inter-ship'}>} Sales)

[panipat1990]

Load 

                   Name,

                   If(TextBetween(Name, '-','')='ship' ,Null(),Name)As New_Name

From

(ooxml, embedded labels, table is Sheet1);

                                                                     Or

Load 

                   Name

                   //If(TextBetween(Name, '-','')='ship' ,Null(),Name)As New_Name

From

(ooxml, embedded labels, table is Sheet1)

Where TextBetween(Name, '-','')<>'ship';

[panipat1990]

Hi,

    Try This

Load 

                   Name,

                   If(SubStringCount(Name,'Inter-ship')=0,Name) As New_Name