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

Action Open Teams/SfB Chat with user
by  dshu   Go to last post Go to first unread
Last post: 6/25/2020 7:04:55 PM(UTC)
Action Find lost space the easy way (spacesniffer.exe)
by  krozar  
Go to last post Go to first unread
Last post: 5/5/2020 10:27:33 PM(UTC)
Lansweeper Querying a web server or web services
by  mmo   Go to last post Go to first unread
Last post: 5/5/2020 9:00:36 PM(UTC)
Action Password Status
by  brodiemac-too  
Go to last post Go to first unread
Last post: 4/23/2020 9:01:03 PM(UTC)
Action Email user
by  Michael Kop   Go to last post Go to first unread
Last post: 4/7/2020 11:24:12 AM(UTC)
Lansweeper actualizacion de datos importando csv
by  jhon freddy  
Go to last post Go to first unread
Last post: 3/31/2020 9:04:45 PM(UTC)
Lansweeper Asset Actions - RunAs Prompt
by  Socal_s197   Go to last post Go to first unread
Last post: 3/26/2020 10:02:16 PM(UTC)
Lansweeper Remote Registry 2019
by  CyberCitizen  
Go to last post Go to first unread
Last post: 3/6/2020 12:25:39 AM(UTC)