Using Concat functions to select values

[Anonymous]

Hi,

There's a button with an action in my application which selects values in one field based on what is already selected in the other field.

= if (GetSelectedCount(FieldName1),

'(' & Concat(DISTINCT chr(34) & FieldName1 & chr(34), '|') & ')' )

The problem is that the field 'FieldName1' includes such values as - Publishing house "Name" - where the symbol " is used. Thus, the actions fails to work.

Could you please give a hint how I can solve it?

Thank you in advance,

Larisa

[sunny_talwar]

See if these post helps you out:

Concat Issue

Concat Issue - II

MasterMind: swuehl‌

[swuehl · Accepted solution]

A different approach to the ref. threads:

= if (GetSelectedCount(FieldName1),

'(' & Concat(DISTINCT chr(34) & Replace(FieldName1,chr(34),'?') & chr(34), '|') & ')' )

edit: Well, that's not an exact match, so it will find e.g. Publishing house xNames

[swuehl]

And in a more general way, if you want to select field values based on selection in a different field, have a look at the approaches described in detail here:

Copy Selections from one field to another

[Anonymous]

Thank you!