Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Everyone,
does anyone know how to search for a string in selected field?
I need to know the recurrence of a specific string in a selected field.
Thanks in advance
Mirco
Hi Mirco, you can try using two functions -
getfieldselection - to get the field value selected
and
substringcount - to give frequency of the string you are searching for.
SubStringCount(GetFieldSelections(FIELD_NAME),'STRING_VALUE')
Hi Mirco
You can achieve this using Button and setting Action under it.
Create Button> Properties
Actions> Select in field
Field : Name
Search String : *Mirco*
See the Attachment.
Regards
Aviral Nag
Hi Mirco, you can try using two functions -
getfieldselection - to get the field value selected
and
substringcount - to give frequency of the string you are searching for.
SubStringCount(GetFieldSelections(FIELD_NAME),'STRING_VALUE')