I am interested in filtering columns in Magnet Axiom by excluding a word. I read that you can use the GREP expression "grep -v" to exclude a word, but I have tried this every which way with no success. Has anyone else found a way to do this?
Hey James,
AXIOM uses .NET regex which is a little different than a Unix GREP.
Here's some common regexes I use that should work for your scenario (hopefully the formatting carries over to FF)
Not null
[^()]
Not a single word - this one should work for you
^(?(?!word).)*$
Not a word at very end
^(?(?!Word$).)*$
Not a Word at the start of line
^(?(?<!Word).)*$
Contains a number
[^(\D)]
Either blue or red or black
(blue|red|black)
CASE SENSITIVE
Find two words separate by X words
John\W+(?\w+\W+){1,3}?Smith
Find two words separate by X singles
John(?.){1,3}?Smith
CASE INSENSITIVE
Find two words separate by X words
(?i)John\W+(?\w+\W+){1,3}?Smith
Find two words separate by X singles
(?i)John(?.){1,3}?Smith
Hope that helps,
Jamie McQuaid
Magnet Forensics
That helps tremendously. Thank you!
If you want to test your expressions before loading them into AXIOM, you can go to https://