Concat-Expression

[#1]

Hello community,

i have one question.

I have a tablewith a colum "test" with the values apple, orange, salad.

i want to concate them like this :

'apple', 'orange', 'salad'.

the function concat(test,',') ist not enough. the apostrophe ist missing.

can someone help me please?

thanks a lot!

best regards,

Aylin

[CELAMBARASAN]

You could use like

Chr(39) & concat(test, Chr(39) & ',' & Chr(39)) & Chr(39)

[MayilVahanan]

Hi

Try like this

Load Chr(39)&Replace(B,',',Chr(39)&','&Chr(39))&Chr(39) As B;

Load Concat(DISTINCT A,',') as B;

Load * Inline

[

A

apple

orange

salad

];

[#4]

Try,

='`'& concat(Left([year-month],4),'`,`')&'`'

[#5]

Hi thanks for your answer. i testet it but the expression returns a 0 instad of a 1.

mixMatch('orange',B)

[#6]

HI thanks for your answer. i tried this but my expressions returns a 0.

mixMatch('orange',Chr(39) & concat(test, Chr(39) & ',' & Chr(39)) & Chr(39)

)

[CELAMBARASAN]

You could use

=WildMatch(B, '*orange*')

Because MixMatch matches the whole word.

[#8]

i can't use wildmatch. because i have to search for the whole word. how can i do this with mixmatch ?

[#9]

I solved it:

WildMatch(B, chr(42)&'orange'&chr(42))

Thanks all for your help#!