LuckyLucks
asked on
Extracting filename from a text and putting it in a new text file
I need to extract the filenames 09103ea6-16d8-461f-955e-97
as:
09103ea6-16d8-461f-955e-97
09103ea6-16d8-461f-955e-97
*WARNING* Data file ["F:\Data2014\09103ea6-16d
*WARNING* Data file ["F:\Data2014\09103ea6-16d
as:
09103ea6-16d8-461f-955e-97
09103ea6-16d8-461f-955e-97
*WARNING* Data file ["F:\Data2014\09103ea6-16d
*WARNING* Data file ["F:\Data2014\09103ea6-16d
footech
Extract them from what, exactly? Please describe your scenario in more detail.
Try this:
Dan
get-content file.txt | %{$_ -replace ".*\\([\w-]+\.pdf).*", "$1" } | out-file new.txtDan
This works for me. Dan's wasn't working for me in PowerShell 4 at least because of the double quotations.
Get-Content inputfile.txt | Foreach-Object {$_ -replace ".*\\([\w\-]+\.pdf).*", '$1'} | out-file newfile.txt
No points for me, but just an FYI. Yes, you have to use one of the following:
'$1'
"`$1"
'$1'
"`$1"
ASKER
I could have other extensions like xls, XLS, xlsm, doc, docx, DOC, DOCX, htm, HTM, msg. Infact if you could modify it so that the extension is irrelevant as long as its contained within the first [].
get-content file.txt | %{$_ -replace ".*\\([\w-]+\.\w+)\"\].*", '$1' } | out-file new.txt
Depending on how much variation there is in the extension, or even if there's no extension at all, you may want to use the following.
Get-Content file.txt | Foreach-Object {$_ -replace '.*\\([\w .-]+?)"].*', '$1'} | out-file new.txtASKER
It seems to just hang with a >> (unlike the previous line with .pdf)
Mine doesn't.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
thanks to all.