topic Match case ( 0 ) in Discussions

Match case ( 0 )

Dennisbur — Mon, 23 Oct 2023 15:52:01 GMT

Hello

I would like to find test names that continue "pcie0" sometimes in lower or upper format

I understand I should use Match case ( 0 )

I have added it to my script but received error

can you check what I should change in my script?

Column(dt, "PARAMETR") << Set Each Value( If( Contains(( :TEST_NAME,"pcie0")), Match case( 0 ),"PCIE0",:PARAMETR));

Re: Match case ( 0 )

jthi — Mon, 23 Oct 2023 15:55:39 GMT

I'm not sure where Match Case is used outside of Filter Col Selector. You could convert your :TEST_NAME to upper or lowercase using Lowercase() or Uppercase()

Contains(Lowercase(:TEST_NAME), "pcie0")

Re: Match case ( 0 )

hogi — Mon, 23 Oct 2023 16:00:59 GMT

Column(dt, "PARAMETR") << Set Each Value( If( Contains( :TEST_NAME,"pcie0", Match case( 0 )),"PCIE0",:PARAMETR));
?

no:

Re: Match case ( 0 )

Dennisbur — Tue, 24 Oct 2023 00:13:00 GMT

OK, thank you

there are any options to use like a mix for upper or lowercase because I have a mix format text in this column?

Re: Match case ( 0 )

jthi — Tue, 24 Oct 2023 04:59:57 GMT

I'm not 100% sure what you are trying to do here. You can do the comparison with Regex if you cannot use lowercase()/uppercase() or use two conditions