I can’t believe how close my code was all this time, i actually swapped @{ for @( and played with different variations of that etc but never tried them together, although i now see whats happening and how that works so thank you very much.
Ah i kind of thought foreach was an alias of foreach-object (and to be fair i try not to use aliases in powershell but i keep seeing foreach) which i can now see they are not exactly the same, thank you for your help.
Thank you for your reply, i was considering a CSV format as had used that in the past for something but wasn’t sure that was the right thing with not actually reading from or outputting to a CSV.
I have used your example script and it works but when i apply it to my script it doesn’t work as the vales are passed to the function as 0 and 1 rather than the variable value i.e. item1 and string_value1
I appreciate your replies, they have helped a lot however my original reply that i tried to post 2 days ago still isn’t showing up but i can’t post it again as it says i have already said that so hopefully my reply with a detailed response will show or be approved soon.
Thank you for your replies, i really appreciate your support and the directions you give me.
The Group-Object cmdlet i think is the way to go with this, i have done a little bit of playing with it and hopefully will be able to make it fit however here is some extra details / csv that will help you understand what i’m trying to achieve in case there is a better way, i have also added what i currently have to the bottom of this post.
CSV File
PowerShell
1
2
3
4
5
6
7
8
9
$csv=@"
date,time,store,service,user
13/12/2019,10:50:18,Location1,Service1,user1
17/12/2019,16:35:03,Location1,Service2,user2
21/12/2019,15:26:17,Location2,Service1,user4
21/12/2019,15:26:32,Location2,Service1,user4
06/01/2020,15:26:32,Location1,Service2,user1
06/01/2020,15:26:32,Location2,Service1,User3
"@|ConvertFrom-CSV
This is how the statistics are currently output to email (based on a batch file rather than Powershell)
It doesn’t need to stay in this format but just needs to be clear.
The numbers below are random to show you how they output and not a reflection of the test csv data above.
The -replace statement uses regex for the search pattern and in regex the “|” represents a logical “or” – that’s why you fail at the moment. 😉 If you have a valid csv file why don’t you treat it as such and use Import-CSV instead of get content?
Hi Olaf,
Thank you for highlighting that -replace uses regex, i should have picked up on this but it explains the issue i was having.
With regards to why not using Import-Csv… I wasn’t actually aware of it, I’m new to Powershell, I have always used batch but trying to break that habit (finally).
After tinkering with Import-Csv I have now managed to get the values to update as intended so thank you very much for that pointer.
Being able to reference specific rows / columns using an array is awesome, having used batch files for so long i have been super limited and feel like an idiot for not jumping ship years ago :).
Here’s a bit of a different approach. Powershell is strongest when you are leveraging object. While you can do text manipulation, the other file is in a CSV format, so it will be more predictable leveraging it as an object. This approach would take an update file and consider it autho:
Hi Rob,
Thank you for your input again, I hadn’t actually seen your reply until now sorry but will certainly play with this approach too.
Thank you Rob, dot notation worked perfect, I can’t believe i didn’t try that as i was using dot notation before but removed it when troubleshooting an earlier error that i thought was attributed to that.
