| Author |
 Topic  |
|
|
AKazak
Russia
1205 Posts |
|
|
Shirley_GZ
China
Posts |
|
|
AKazak
Russia
1205 Posts |
 Posted - 10/20/2022 : 08:38:09 AM
|
quote:
Originally posted by Shirley_GZ
Hi Andrey,
You can refer to this page, using the Worksheet Query to find these rows which are not blank or missing value,
https://www.originlab.com/doc/Origin-Help/Wks-Query-QS#What_Can_I_Enter_in_Condition_Text_Box.3F
I think the condition below can be used:
A != -- (or A != NANUM)
Thanks,
Shirley
Originlab Technical Service Team
Got it!
Does this mean that to date Data Filter cannot filter by -- or NANUM?
---
Andrey |
 |
|
|
snowli
USA
1411 Posts |
Posted - 10/20/2022 : 09:32:27 AM
|
Hi Andrey,
When u click the funnel icon and choose Custom Filter...
u can set advanced conditions. The bottom of the dialog mentioned 0/0 for missing value.
So u can enter e.g. x!=0/0 to filter out missing or blank cells.
Thanks, Snow |
|
|
|
AKazak
Russia
1205 Posts |
Posted - 10/20/2022 : 2:16:55 PM
|
quote:
Originally posted by snowli
Hi Andrey,
When u click the funnel icon and choose Custom Filter...
u can set advanced conditions. The bottom of the dialog mentioned 0/0 for missing value.
So u can enter e.g. x!=0/0 to filter out missing or blank cells.
Thanks, Snow
Dear Snow,
Great feature!
Origin is as always surprisingly deep software.
Does 0/0 correspond to both missing and blank cells?
How do I separate missing and blank cells?
---
Andrey |
|
|
|
snowli
USA
1411 Posts |
|
|
AKazak
Russia
1205 Posts |
Posted - 10/20/2022 : 10:52:33 PM
|
quote:
Originally posted by snowli
Maybe u can read this blog
https://blog.originlab.com/improved-handling-of-empty-cells-in-origin-2019
Thanks, Snow
Dear Snow,
I read the blog page and realized three special types of cells: Missing, Blank and Unused.
Let's leave Unused since there is not too much can be done with this type of cells.
As for Data Filter: does 0/0 correspond to either missing or blank cells?
---
Andrey |
|
|
|
snowli
USA
1411 Posts |
Posted - 10/21/2022 : 08:57:25 AM
|
From my trial, it will filter out both missing and blank cells if it's between data.
Thanks, Snow |
|
|
|
AKazak
Russia
1205 Posts |
Posted - 10/21/2022 : 11:36:51 AM
|
quote:
Originally posted by snowli
From my trial, it will filter out both missing and blank cells if it's between data.
Thanks, Snow
OK, I have the same result.
How do I separate missing and blank cells?
---
Andrey |
|
|
|
snowli
USA
1411 Posts |
Posted - 10/21/2022 : 1:53:34 PM
|
Use the following to filter out missing values only
x != "--"
Use the following to filter out empty cells only
!isempty(x)
Thanks, Snow |
|
|
|
AKazak
Russia
1205 Posts |
Posted - 10/21/2022 : 2:07:01 PM
|
quote:
Originally posted by snowli
Use the following to filter out missing values only
x != "--"
Use the following to filter out empty cells only
!isempty(x)
Thanks, Snow
Got it.
Thanks!
---
Andrey |
|
|
|
snowli
USA
1411 Posts |
|
|
AKazak
Russia
1205 Posts |
|
| |
Topic |
|
2022b SR1: Data Filter with missing and blank cell