topic Re: String Search in App Development

String Search

EricDraven — Wed, 27 Oct 2021 14:27:18 GMT

I have a field that has multiple codes inside of the field (Example: *Code1 *Code2 *Code4 *Code5). I want to search through each of them record to find only the ones that do not have one Code Number. (Example: *Code 4). The field is random with no structure so sometimes *Code3 is before *Code1 and others it is not. Also, there are random spaces in-between the codes if codes are missing from the string. (In the example I am missing *Code3 which is why there is three spaces there.) Can this be done?

Re: String Search

AshutoshBhumkar — Wed, 27 Oct 2021 15:11:58 GMT

Hello,

Quite not clear with the question. Can you please elaborate more ?

Thanks,

Ashutosh

Re: String Search

EricDraven — Wed, 27 Oct 2021 15:55:14 GMT

Yes I will use what I have tried.

Field name is UserCodes - contains codes a user may have

Field Name UserName - contains the username of the person

UserName	UserCode
User 1	Code1 Code2 Code3 Code4 *Code5
User 2	Code5 Code2 Code4 Code1
User 3	*Code1
User 4	Code1 Code4 *Code5
User 5	Code5 Code1 *Code4

I want to pull the people that have *Code1, *Code4, and *Code5. I have tried to use the following.

if(Wildmatch(UserCode,'*Code1*','*Code4*','*Code5*')>0,UserName).

But, it only gives me if those codes are in the field UserCode.

I need to return the Username if all the codes are in there only. These codes can be in any order and can have other codes in-between them.

If User has UserCode of *Code1, *Code4, and *Code5 would return

User1, User2, User4, and User5

Re: String Search

AshutoshBhumkar — Thu, 28 Oct 2021 04:44:52 GMT

Hi,

Something like this ?

Expression Used : If(WildMatch(UserCode,'*Code1*') and WildMatch(UserCode,'*Code4*') and WildMatch(UserCode,'*Code5*') , UserName,0)

Check if that works for you.

Thanks,

Ashutosh

Re: String Search

EricDraven — Thu, 04 Nov 2021 13:04:43 GMT

Forgot to update you. Yes this worked. Thank you.

Re: String Search

AshutoshBhumkar — Thu, 04 Nov 2021 17:26:24 GMT

Great 🙂