Question about Expression filter

Questions
1

Hi, datagrok team,

Currently, when using Expression Filter, we can specify multiple values separated by commas when using the ‘in’ operation for a specific column. This is a very useful feature.

image
image587×177 12.1 KB

However, I’ve encountered an issue when trying to paste multiple query values from external sources like Excel. When I copy and paste values that are separated by line breaks, they get converted to space-separated values in the Value field.

As a result, two IDs that should be separate queries become one space-separated query, which doesn’t work as intended.

image
image592×185 9.97 KB

I would like to know if there’s a way to achieve the same search results with line break-separated queries. For example:
123
456
789

Instead of having to manually format it as:
123,456,789

If you find this suggestion valuable, would you consider adding this as a new feature to handle both comma-separated and line break-separated inputs?

Thank you for your consideration.
Best,
Kosuke

1 Like
2

Hi Kosuke!

I believe this might be the issue with how copy-paste works in Datagrok. We will look into it and include in the next release, it is a useful feature indeed.

To clarify in your case, are different values separated by line breaks, or are line breaks within a particular value?

2 Likes
3

HI Davit,

Thank you for your positive feedback.
In my case, different values separated by line breaks is the correct expression like below.

image
image220×135 2.84 KB

In this example, pasting three values on memo pad, they are separated by line breaks.
X0273T21000200001
X0273T21000200002
X0273T21000300001

When they are pasted on Expression’s Value cell, those are separated by space.
X0273T21000200001 X0273T21000200002 X0273T21000300001

Hopefully, I can clarify your question.
If you have any questions or comments, please let me know.

Best,
Kosuke

1 Like
4

Tracking ticket for this request:

1 Like