Forum Discussion
Kennethjn
Nov 03, 2020Copper Contributor
Export Import CSV - help please :)
Hi Everyone I am currently creating a script that consists of a lot of small tasks, ending with the result being an Excel Report for the management team. But one part is giving me some trouble, s...
- Nov 04, 2020
I found the issue to simply being me missing the -Delimiter option on the import-csv command.
I added -Delimiter ";", since it is the seperator in the csv file, and things are working now.
VasilMichev
MVP
Every time you run the Export-CSV cmdlet you are effectively overwriting the file. Use the -Append switch as an easy fix.
Kennethjn
Nov 04, 2020Copper Contributor
Hi Vasil
I have tried to apply the -Append option, but it gives me the same result.
A file with one "Computer" row and no computer names.
Any other suggestions on what i am doing wrong?