Quotes in function

[Anonymous]

Good afternoon!
Whether there is a method in function concat in quotes to put quotes that they were displayed as separators?
the separator character must be ';' , bur if I write '';'' it does not work

Thanks!

[Peter_Cammaert]

Hmm, I'm not entirely sure I understand your question.

You want a Concat() function call to use a semicolon as value separator? What's wrong with using ';' ? Stuff like this example should work out of the box.

=Concat(DISTINCT [Product Category], ';')

Peter

[kamalqlik]

Can you please elaborate your question a more or explain the output you require.

Regards

Kamal

[Anonymous]

I need not the result like this:

chair,book,

Quotes should be in the result of this function, if it is possible.

'chair','book'

More extended - i need to receive from unrelated table (it is necessary for the task) multiple values so i could assign them to an associated table - with concat on this moment i can assign just one value, i search for the solution of this problem.

Now the function is like:

SUM(<={'$(=Concat())')

where a - associated table

b- unrelated table

Thanks

[Anonymous]

Thank you for answer, but i need the output like 'chair','book',

So if it is possible, i am trying to understand how can save quotes in the result

Yana

[Peter_Cammaert]

Like this?

=chr(39) & Concat(DISTINCT [Product Category], chr(39) & ',' & chr(39)) & chr(39)

[Anil_Babu_Samineni · Accepted solution]

I think, You want to call like

=Concat(FieldName, chr(39) & ',' & chr(39))

[Peter_Cammaert]

Be careful. This solution has no first or last quote. Just those in the middle.

[Anil_Babu_Samineni]

This makes bit shorter..

=Concat(DISTINCT Chr(39) & Customer & chr(39), ',')

[Anil_Babu_Samineni]

I've comment to u earlier like

=Concat(DISTINCT Chr(39) & Customer & chr(39), ',')