Attempting to create a query that will return all values that do not have a . (dot) in their file name, meaning no file extension. Does anyone know of a way of achieving this? Seems simple but I can't figure it out. The query is a combination of terms that do have file extensions so I can't use filename!=".".
Hi
Give a try
| makeresults
| eval file="test.txt,test1,temp.csv,test3"
| makemv delim="," file
| mvexpand file
| where isnull(mvindex(split(file,"."),1))
New: Try this filters only file name
| makeresults
| eval file="test.txt,test1,temp.csv,test3"
| makemv delim="," file
| mvexpand file
| rex field=file "(?P<filename>[^.]+)"
can you please give example list of filenames and tell us what you want to filter out?
They're unknown. Basically you have filename1.doc and filename1.txt. I'm looking to return all values that are filename1 (no file extension)
so you want to remove file extensions and return only filenames?