I want Exclude particular sort of values from list box

[#1]

Hi guys,

In one field  i have data like   144954/78768/fds

                                           133454/46567/klh

                                            23545/67676/lkg

                                            ******/*****/erd

                                            *****/***** /lkj

                                            ***********jmh

                                            ***********hng

So in the above field values i want to remove * field values in the field.

So can anyone tell me how to exclude those field values completely from that particular field.

by using set analysis or not widlmatch anything but i need a solution guys...

thanking you in advance!

Message was edited by: vijay krishna

[MK_QSL]

Do you want to exclude Last Two fields from Script or in any chart/table?

[avinashelite]

try like this

if(field_name<>'*/*',filed_name)

[tamilarasu]

Hi Vijay,

Try,

If(Index(Field,'*')=0,Field)

Load script can be

Load If(Index(Field,'*')=0,Field) as Field

...

From Source Data.

[#5]

ya i want to remove all the field values where * is in that field value....

[MK_QSL]

In script you can ignore field using below

Data:

Load * Inline

[

  FieldName

  144954/78768/fds

  133454/46567/klh

  23545/67676/lkg

  ******/*****/erd

  *****/***** /lkj

  ***********jmh

  ***********hng

]

Where Index(FieldName,'*')=0;

[aveeeeeee7en]

Hi Vijay

Try SubstringCount() Function.

See this:

TABLE_1:

LOAD * INLINE [

NUMBER

144954/78768/fds

133454/46567/klh

23545/67676/lkg

******/*****/erd

*****/***** /lkj

] WHERE SubStringCount(NUMBER,'*')=0;

Regards

Av7eN

[#8]

it's  working ok by using if condition and index function....

can you do it in set expression also

like this

sum({<Field-={'%*%'}>}cost)

Please give correct answer using set expression also

[tamilarasu · Accepted solution]

Try,

=Sum({<Field={"=Index(Field,'*')=0"}>}cost)

[HirisH_V7]

Hi,

May be like this in both front end and back end,

Data:
LOAD *,
If(Mid(Field,1,2)='**',Null(),Field) as Field2

INLINE [
    Field
    144954/78768/fds
    133454/46567/klh
    23545/67676/lkg
    ******/*****/erd
    *****/***** /lkj
];

In list box expression:

=If(Mid(Field,1,1)='*',Null(),Field)

HTH,

PFA,

Hirish