| T O P I C R E V I E W |
| AKazak |
Posted - 10/20/2022 : 03:30:58 AM
OriginPro 2022b (64-bit) SR1 9.9.5.167
Windows 7 Pro SP1 x64
Greetings!
How do I set Data Filter for a column and filter out the rows containing Missing or Blank cells (https://www.originlab.com/doc/Quick-Help/Diff-of-Missing-and-Blank)?
Thank you.
---
Andrey |
| 12 L A T E S T R E P L I E S (Newest First) |
| AKazak |
Posted - 10/31/2022 : 05:12:33 AM
quote:
Originally posted by snowli
I updated
https://www.originlab.com/doc/Quick-Help/Diff-of-Missing-and-Blank
with such info.
Thanks, Snow
Dear Snow,
Thank you.
---
Andrey |
| snowli |
Posted - 10/21/2022 : 3:08:46 PM
I updated
https://www.originlab.com/doc/Quick-Help/Diff-of-Missing-and-Blank
with such info.
Thanks, Snow |
| AKazak |
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 |
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 |
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 |
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 |
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 |
Posted - 10/20/2022 : 3:02:26 PM
Maybe u can read this blog
https://blog.originlab.com/improved-handling-of-empty-cells-in-origin-2019
Thanks, Snow |
| AKazak |
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 |
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 |
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 |
| Shirley_GZ |
Posted - 10/20/2022 : 05:45:36 AM
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 |
