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: 14  
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 Help Desk Workflow
by  lswanson   Go to last post Go to first unread
Last post: Yesterday at 11:12:21 PM(UTC)
Lansweeper Changing to remote scanning due to COVID
by  FrankSc  
Go to last post Go to first unread
Last post: Yesterday at 9:35:26 PM(UTC)
Lansweeper Not giving hackers the Domain Admin password / account
by  FrankSc   Go to last post Go to first unread
Last post: Yesterday at 9:27:13 PM(UTC)
Lansweeper LsAgent failing - Lansweeper SSL Expired
by  lansweeper25t34  
Go to last post Go to first unread
Last post: Yesterday at 8:33:28 PM(UTC)
Lansweeper Is there a chance to get the firewall off via Lansweeper?
by  EDV_OHZ   Go to last post Go to first unread
Last post: Yesterday at 4:57:26 PM(UTC)
Lansweeper Merge Asset button
by  KeithBecker  
Go to last post Go to first unread
Last post: 8/5/2020 9:27:54 PM(UTC)
Lansweeper Merge Two Assets or Update Based on Serial Number
by  KeithBecker   Go to last post Go to first unread
Last post: 8/5/2020 9:25:16 PM(UTC)
Lansweeper Hyper-V guest assets
by  bgstein  
Go to last post Go to first unread
Last post: 8/5/2020 5:50:24 PM(UTC)