Search for a string in a Field

[#1]

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

[aveeeeeee7en]

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

[#3 · Accepted solution]

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')