How can we Replace date in a text file using Windows Powershell scripting?

Question

I'm writing a windows powershell script to open/edit a text file.

It has many records and each record is sorted of comma-separated values (csv):

Steps I want to achieve:

Open the text files in a directory on Server A.
Edit the "Date" field with "Current Date" or other.
Save the same text file at the same location(folder).
Copying all the files to a new folder in different Server B.

I've just written this code snippet:

$path = "C:\PSFiles\Rec_File_001.txt" 
$Filedata = Get-Content $path
$Record01 = $Filedata[0].split(",")
$Record01Date = $Record01[3]
$Record01CurrentDate = Get-Date -format yyMMdd
$Record01 -replace $Record01Date, $Record01CurrentDate
Set-Content $path

Please, any help on this?

Break your question to smaller pieces and ask a specific question about the piece which you have a problem with. — Reza Aghaei
– Reza Aghaei, Commented Dec 19, 2017 at 7:44
I am complete newbie in scripting. The first thing is replacing the date. I will edit the question to be more specific. Thanks — user5520287
– user5520287, Commented Dec 19, 2017 at 7:46
To answer your first question- Yes it is possible. then second one to help you out, you can use get-content and you can use the replace — Ranadip Dutta
– Ranadip Dutta, Commented Dec 19, 2017 at 7:55
The date is not always in the same column in your data example. Is this a mistake or is this how the data really looks like? — iRon
– iRon, Commented Dec 19, 2017 at 8:00
Thanks for the input. The issue is that firstly, how can i store records in array. Next, when i replace the dates, how can i save the new date in the file. When i use "Set-Content" -path, it deletes all data in the File. — user5520287
– user5520287, Commented Dec 19, 2017 at 8:00

tukan · Accepted Answer · 2017-12-19 08:07:13Z

1

You are having multiple questions here. I'll address the one that is presented in the title - replacing text in a text file.

The script:

# current date in a new format
$CurrentDate = Get-Date -format yyMMdd

#replace old format
Get-Content -ReadCount 500 -Path C:\PSFiles\Rec_File_001.txt | % {$_ -replace "(0[1-9]|1[012])\d{1,2}(0[1-9]|[12][0-9]|3[01])", "$CurrentDate"} | Set-Content -Path C:\PSFiles_output\Rec_File_001.txt

This takes regexp for date format Date(mmYYdd) and exchanges it for a new one. An option -ReadCount limits the number of lines that go via pipe at one time.

edited Dec 19, 2017 at 8:07

answered Dec 19, 2017 at 8:00

tukan

17.5k1 gold badge25 silver badges51 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

user5520287 Over a year ago

Thanks for the code. The code is compiled without errors , but the dates are still not repalced physically in the text file. I think maybe im not storing the records correctly in Array or not writing to the file ?

tukan Over a year ago

@sunny238: can you post complete file so I can test it?

iRon · Accepted Answer · 2017-12-19 08:23:38Z

0

Import-CSV $Path -header text1, text2, text3, date, text5 | 
Select text1, text2, text3, @{Name="Date"; Expression={Get-Date -format yyMMdd}}, text5 |
ConvertTo-Csv -NoTypeInformation |
Select-Object -Skip 1 |
Set-Content $Path

Or:

$data = Import-CSV $Path -header text1, text2, text3, date, text5
$data | ForEach {"Date" = Get-Date -format yyMMdd}
$data | ConvertTo-Csv -NoTypeInformation | Select-Object -Skip 1 | Set-Content $Path

answered Dec 19, 2017 at 8:23

iRon

24.4k10 gold badges60 silver badges107 bronze badges

3 Comments

tukan Over a year ago

In original question he stated he did not want to use Import-CSV, now being edited away.

iRon Over a year ago

In the original question he stated he did not want to use Import-CSV because... which I think wasn't a valid reason. Header can be added with -header ..., and later suppressed with | ConvertTo-Csv -NoTypeInformation | Select-Object -Skip 1 | Set-Content $Path

tukan Over a year ago

yes I can agree. It would be educational for the one asking the question, why it is not a valid reason.

Charles · Accepted Answer · 2019-10-17 16:34:37Z

Hopefully this helps. Run the following commands in powershell:

$(Get-Item ath/filename.extensionfilename).creationtime=$(get-date "2019-10-15T15:45:12.2723844+01:00")

$(Get-Item C:\temp\log\txt.log).creationtime=$(get-date "2019-10-15T15:45:12.2723844+01:00")

Here is an article from Microsoft that explains how to modify the timestamps of a file https://devblogs.microsoft.com/scripting/use-powershell-to-modify-file-access-time-stamps/

Below is a table from that article showing the attributes that involve time that you can modify.

+----------------+----------+-----------------+---------------------------+
|      Name      |  Member  |      Type       |        Definition         |
+----------------+----------+-----------------+---------------------------+
| CreationTime   | Property | System.DateTime | CreationTime {get;set;}   |
| LastAccessTime | Property | System.DateTime | LastAccessTime {get;set;} |
| LastWriteTime  | Property | System.DateTime | LastWriteTime {get;set;}  |
+----------------+----------+-----------------+---------------------------+

Collectives™ on Stack Overflow

How can we Replace date in a text file using Windows Powershell scripting?

3 Answers 3

2 Comments

3 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related