emeditor
How to filter a range of dates in emeditor
How can i use Advanced Filter to extract a range of dates from a Column (eg: Btw 25/09/2021 & 27/09/2021) in Emeditor?
Solution
Please use multiple regular expressions combined with Logical Disjunction (OR) to filter a range of dates.
For example, if you want to extract dates from 23/07/2021 through 30/07/2021, you can use:
2[3-9]/07/2021 OR 30/07/2021
There are some articles of regular expressions for a range of dates:
However, the advantage of using EmEditor is that you can define several regular expressions and combine them using Logical Disjunction (OR), so that search expressions can be simplified.
It is possible that EmEditor might support date ranges natively in future versions.
Updates: v21.2.901 (and later) supports date ranges natively.
- how to see where and what the changes are when file is modified externally
- How to find the total number of columns (characters) in a particular line?
- How to Extract my chosen emails from huge file
- Is it possible to prevent the wrap mode of the active file from being automatically applied to other files?
- How to remove all special symbols after : in EmEditor
- How to bookmark lines from/to
- EmEditor Macro Error - 'document' is undefined
- It is possible to add numbers from 0-99 at the end of all line?
- Emeditor to extract displayed strings for each line (maintaining the line order)
- EmEditor Macro to Save Large Files from 0 to 100000
- Emeditor: run a macro for all file inside a folder?
- Emeditor Multiple Marking
- What is the most common word in EmEditor
- Em editor phone number formatting
- EmEditor script: extend the selection range to include multiple separate words?
- When will EmEditor Javascript be updated from ES5.1?
- EMEDITOR Bookmark lines that end with specific letter (for example emails .de, .ch etc)
- EmEditor js macro: is it possible to suppress temporary updates in the editor?
- EmEditor js macro: is it possible to use node.js API?
- Highlight brackets when caret be after bracket
- EmEditor macro in JS: how to get the full content of a document object
- Remove/change red underline in columns
- How to convert JSON file to excel?
- Match 1 or more words separated by comma
- Is it possible to specify the beginning and end points of the file to be opened before opening?
- What is the use of Point object in macro reference?
- Is there a shortcut to comment and uncomment in emeditor?
- In EmEditor, what expression to use to filter for rows containing mismatching number of specified characters across two columns
- In EmEditor, how to normalize multiple consecutive whitespaces to 1 in multi-column file
- In EmEditor, how to filter for lines matching across columns?