How to find values ending with *

[#1]

Hi,

In one field I have values like

Field:

ABC

CDE*

EFG

GHI*

IJK*

KLM

MNO

All the values ending with * means all those records are legacy records.

In the application I have a list box for the Field.

The user would like to search for all value ending with * but just searching for * in list box selects all values.

[sunny_talwar]

May be something like this:

LOAD Field,

          If(Index(Field, '*') > 0, 1, 0) as Legacy_Flag

FROM Source;

[swuehl · Accepted solution]

You can also use index() in the search bar of your list box:

=index(Field,'*')

[#4]

Hi Sunny,

It needs to be searchable in the front end. I have one list box that has the list of both legacy & non legacy records. In that list anything that ends with a * is legacy. My requirement is, from the list box the user should be able to search all legacy records (basically all values that end with *)

[#5]

Awesome. That worked.

I was actually trying the same command index(Field,'*') before posting this question but totally forgot to add the = at the beginning..

[#6]

Is there anyway I can apply this as an action to a button?

[sunny_talwar]

I think =flag = 1 should be searchable and should be good to use with burron action

[swuehl]

Annamalai Muthappan wrote:

Is there anyway I can apply this as an action to a button?

Sure, should be possible using a Selection - Select in field action.

Use field name

Field

and as search string

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

[two single quotes around *, not a single double quote]

[sunny_talwar]

Was out when you responded back, have created a sample using the flag method if you want to check it out .