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

[Kushal_Chawda]

try to create the Flag in script

Data:

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

[

  FieldName

  144954/78768/fds

  133454/46567/klh

  23545/67676/lkg

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

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

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

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

]

Now your expression will become

sum({<Flag={'0'}>}Cost)

Update :should be zero in set

[shambhub]

Hi Vijay,

Use the below expression

Only({$<Field={"*"}-{ ******/*****/erd, *****/***** /lkj}>}Field)

Best Regards

Shambhu B