Notification

Icon
Error

How can i export CSV without quotes and semicolon? - How can i export CSV without quotes and semicolon?

Posted: Friday, May 15, 2020 9:19:11 AM(UTC)
ResRudeBoy

ResRudeBoy

Member Original PosterPosts: 5
0
Like
Hi, How can i export CSV without quotes and semicolon? im trying to export all users who have not logged on for 90 days, ive got the report working and its to export just 1 column of the users samaccountname, so i can then run a powershell to disable the exported accounts.

but every export puts an output like this "Username"; and then each username has "username" around it which powershell doesnt like.

Can anyone please advise me?

Thanks
JSchlackman
#1JSchlackman Member Posts: 15  
posted: 6/29/2020 5:53:01 PM(UTC)
CSVs being created with a semicolon instead of a comma was supposedly confirmed as a bug but doesn't seem to have ever been fixed because it happens on my install too. The quotes are normal to ensure that any instances of the seperator that are part of the actual field value are treated as such.

You can tell PowerShell to import the file using a semicolon delimiter as follows:

Code:
Import-Csv -Path $ExportFile -Delimiter ';'


It will then import normally just as if it was correctly formatted with commas.

Active Discussions

Lansweeper Internet Explorer 11 EOL
by  Esben.D   Go to last post Go to first unread
Last post: Today at 12:53:56 PM(UTC)
Lansweeper Software per AD group
by  CPappas  
Go to last post Go to first unread
Last post: Today at 10:52:48 AM(UTC)
Lansweeper Report Merge
by  EnjetIT   Go to last post Go to first unread
Last post: Yesterday at 1:49:51 PM(UTC)
Lansweeper Microsoft True Up: Licenses combined with AD
by  Tstandridge  
Go to last post Go to first unread
Last post: 8/1/2021 6:39:26 PM(UTC)
Lansweeper Combined Vulnerability Report Q1 2019
by  BKolodny   Go to last post Go to first unread
Last post: 7/30/2021 5:29:43 PM(UTC)
Lansweeper Last user, login time and null entries
by  cross_eur  
Go to last post Go to first unread
Last post: 7/29/2021 5:44:36 PM(UTC)
Lansweeper Stale Tickets
by  brodiemac-too  
Go to last post Go to first unread
Last post: 7/28/2021 8:47:09 PM(UTC)