Search found 33 matches
- Thu Jul 12, 2018 9:41 am
- Forum: PowerShell
- Topic: split satement
- Replies: 10
- Views: 3598
Re: split satement
can anyone extract year and country name from file name in my script
- Wed Jul 11, 2018 10:44 pm
- Forum: PowerShell
- Topic: split satement
- Replies: 10
- Views: 3598
Re: split satement
can you help in adding logic into it...believe me it is final $sourcedir = 'C:\Users\garang\Documents\input_files\Advisory_rate '$destdir = 'C:\Users\garang\Documents\input_files\Advisory_rate\Archive' Get-ChildItem -File -Path $sourcedir | Where-Object BaseName -match ' ([a-z]+_20\d{2})_\d' |Group-...
- Wed Jul 11, 2018 2:18 pm
- Forum: PowerShell
- Topic: split satement
- Replies: 10
- Views: 3598
Re: split satement
very simple question needs to extract year and country from file name and keep their last modified date files and move remaining files to archive...simple English
- Wed Jul 11, 2018 1:44 pm
- Forum: PowerShell
- Topic: split satement
- Replies: 10
- Views: 3598
Re: split satement
Hi expert, can you help in adding above logic into it $sourcedir = 'C:\Users\garang\Documents\input_files\Advisory_rate '$destdir = 'C:\Users\garang\Documents\input_files\Advisory_rate\Archive' Get-ChildItem -File -Path $sourcedir | Where-Object BaseName -match ' ([a-z]+_20\d{2})_\d' |Group-Object {...
- Wed Jul 11, 2018 11:28 am
- Forum: PowerShell
- Topic: split satement
- Replies: 10
- Views: 3598
Re: split satement
i got new logic into it
$Match = "[^_]+_[0-9]{4}"
$Lines = get-clipboard
$Results = $Lines | %{$_ -Match $Match | %{$Matches[0]}}
$Match = "[^_]+_[0-9]{4}"
$Lines = get-clipboard
$Results = $Lines | %{$_ -Match $Match | %{$Matches[0]}}
- Wed Jul 11, 2018 9:53 am
- Forum: PowerShell
- Topic: split satement
- Replies: 10
- Views: 3598
Re: split satement
at least tell me about match condition
Where-Object BaseName -match ' ([a-z]+_20\d{2})_\d' |
Where-Object BaseName -match ' ([a-z]+_20\d{2})_\d' |
- Wed Jul 11, 2018 9:29 am
- Forum: PowerShell
- Topic: split satement
- Replies: 10
- Views: 3598
Re: split satement
Dear Sir,
My apology for guessing
the same thing i can achieve through Group-Object {$_.Basename.Split(' ')[3],('_')[1]} this script..can we able to split only country and year only without hardcoded
My apology for guessing
the same thing i can achieve through Group-Object {$_.Basename.Split(' ')[3],('_')[1]} this script..can we able to split only country and year only without hardcoded
- Wed Jul 11, 2018 6:11 am
- Forum: PowerShell
- Topic: split satement
- Replies: 10
- Views: 3598
split satement
Hi Expert, I am using split condition to split the space and underscore and I am reaching to country and year but i wanted to stop after that i tried Group-Object {$_.Basename.Split(' ')[3],('_')[1]} | in this way i can get countryname _year but how to stop after the year and should not go further s...
- Wed Jul 11, 2018 2:19 am
- Forum: PowerShell
- Topic: year and countryname extract
- Replies: 22
- Views: 5414
Re: year and countryname extract
any suggestions on this i am little bit away from the target as able to move some of the files. here is the new file format first row should be archived
abc N Refund Maker_Japan_2017_302413 modified date :26/06 10:20
abc N Refund Maker_Japan_2017_Extra modified date:26/06 10:30
abc N Refund Maker_Japan_2017_302413 modified date :26/06 10:20
abc N Refund Maker_Japan_2017_Extra modified date:26/06 10:30
- Mon Jul 09, 2018 10:32 pm
- Forum: PowerShell
- Topic: year and countryname extract
- Replies: 22
- Views: 5414
Re: year and countryname extract
when i run this file...only half of the files are moving $sourcedir = 'C:\Users\garang\Documents\input_files\Advisory_rate' $destdir = 'C:\Users\garang\Documents\input_files\Advisory_rate\Archive' Get-ChildItem -File -Path $sourcedir | Where-Object BaseName -match ' ([a-z]+_20\d{2})_\d' | Group-Obje...