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
Nov 03, 2020MVP
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
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.