match - function

[#1]

Hello together,

i have a table with ColA => apple, cycle and a table with ColB => cycle

is it possible with the wildmatch or another function, to show, that the value cycle in ColB is part of ColA?

match(ColB,ColA) returns 0. I want that the function returns a 1.

Thanks a lot!

Best regards,

Aylin

[maxgro]

try with

=wildmatch(ColA, '*' & ColB & '*')

but if if you have more values in ColA and ColB

it only works when you select 1 value in each columns

A:

LOAD * INLINE [

    ColA

    "apple, cycle"

    "cycle, fruit"

];

B:

LOAD * INLINE [

    ColB

    cycle

    square

];

[#3]

See

exists()

fieldIndex()

Fabrice

[er_mohit]

Try this in text box

if(len(trim(mid(ColA,Index(ColA,',')+1)))=len(ColB),1,0)

[CELAMBARASAN]

Hi,

Sometimes the textobject expression varies from chart expression, script expression. Could you please describe about the scenario or what/ where the expression is to be applied?

[#6 · Accepted solution]

Thanks a lot for your helps.

I resolved it with the index function!          =If(Index(ColA, ColB) > 0, 'TRUE', 'FALSE')

[CELAMBARASAN]

FYI: Index will be case sensitive comparison. if thats what you want very well you can go with that

=If(Index(ColA, ColB), 'TRUE', 'FALSE') //this is enough

[simondachstr]

=Index(ColA, ColB) // this is enough (for conditional shows e.g.)