Spaces in "Select in Field" Action

[#1]

Hi,

I'm trying to select some values of a ListBox using a Button and a "Select in Field" Action.

As described in the Reference Manual, you should be able to use the following syntax to select one ore several values:

value                    >one value

(value1|value2)      >both values

If one of my values contains a space, then a strange behaviour occurs.

dog 123                  >works

(cat|dog 123)          >only selects 'cat'

(cat|dog?123)         >selects cat AND dog 123 (of course no matter what sign is between dog and the number)

(cat|[dog 123])        >only selects 'cat'

None of my estimates to escape that space were successful.

Does anybody knows how I can select several values with spaces?

Kind regards

hundkatzemaus

[rajni_batra]

i think u can use any no. of value (value1|value2|value3)

[#3]

Sure, the number of values is not the problem...

values containing spaces or other signs like '-' are not working 😞

Here I need a solution!

[rajni_batra]

in Backend use

Replace(Field,' ','*' ) Then use (Cat| Dog*123)

Hope this helps

[sreenivas]

Hi

Try this way in the search string specify as ("CAt 123"|Dog)

LOAD * INLINE [

    F1, f2

    Dog, one

    CAt 123,two

    Hi,three

];

[swuehl · Accepted solution]

try

(cat|"dog 123")

- works for me

[#7]

I thought that I had tried that before without success... But it seems something went wrong with my test.

Perfect answer 🙂 This solves the problem 🙂