topic use wildmatch on multiple rows in a column in App Development

use wildmatch on multiple rows in a column

hillarynyawate — Thu, 09 Jun 2022 13:48:07 GMT

How can i use wildmatch on multiple rows in a column

=if(wildmatch(column_name,'*Medic*'),'MEDICATION')
=if(wildmatch(column_name,'*Consult*'),'CONSULTATION')
=if(wildmatch(column_name'*Proc*'),'PROCEDURE')

Re: use wildmatch on multiple rows in a column

stevejoyce — Thu, 09 Jun 2022 14:24:51 GMT

Like this you're looking for?

=if(wildmatch(column_name,'*Medic*'),'MEDICATION'
,if(wildmatch(column_name,'*Consult*'),'CONSULTATION'
,if(wildmatch(column_name,'*Proc*'),'PROCEDURE')))

Re: use wildmatch on multiple rows in a column

HugoRomeira_PT — Thu, 09 Jun 2022 14:26:49 GMT

Hello,

You can achieve this using the Pick() and Wildmatch() functions.

Try the following:

=Pick(wildmatch(column_name,'*Medic*','*Consult*','*Proc*'),'MEDICATION','CONSULTATION','PROCEDURE')

Hope it helps!

Re: use wildmatch on multiple rows in a column

hillarynyawate — Fri, 10 Jun 2022 14:02:20 GMT

@HugoRomeira_PT Thanks man, it worked!