Select in Field

[MK_QSL]

I have employee code either starting with Alphabet or Number.... it is mixed of both....

What should I write in Text Box - Action - Select in Field - Search String to get all employee code starting with Alphabets only...

i.e. starting with any Alphabet from A to Z...

[#2]

Hi Manish,

Try this (if your values don't contain spaces, then omit the replace function, put your fieldname only):

='(' & Concat({1} distinct if(IsText(Left(FieldName,1)), Replace(FieldName, ' ', '*')), '|') & ')'

Hope this helps.

[simondachstr]

Another idea would be to include another column in your loading script, stating that any employee starting with a letter , should get a 1, employees starting with a number should get a 0.

e.g. if(isText(Left(FieldName,1)),1,0) as EmployeeLetterStart

In Action you will then use Trigger, Select Possible, Only({<EmployeeLetterStart={'1'}>} FieldName)

Using this will be much much more faster in the front end.

[MK_QSL]

Hi Jean,

This working fine but definitely there should be some easy way....!!

[maxgro]

not very nice but it works

='("a*"|"b*"|"c*")'          

Regards

[rbecher]

Hi Manish,

try something like this:

='=ord(left(Field,1))>64'

- Ralf

[brijesh1991]

Write this expression in a list box edit expression

if(isText(Mid(FieldName,1,1)),EmployeeCode)

And then right click over listbox and select all.

[rbecher · Accepted solution]

Even this works:

='=ord(Field)>64' 

..most simple.