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 Lost Configuration tab (Admin rights)
by  kspap   Go to last post Go to first unread
Last post: Today at 10:30:12 AM(UTC)
Lansweeper Deployment with different user rights
by  Jupiter_IT  
Go to last post Go to first unread
Last post: Today at 9:39:20 AM(UTC)
Lansweeper cisco fuji device not linking with connected devices
by  char   Go to last post Go to first unread
Last post: Yesterday at 9:12:07 AM(UTC)
Lansweeper Microsoft CVE-2020-1425
by  Richard_B  
Go to last post Go to first unread
Last post: 7/3/2020 4:29:41 PM(UTC)
Lansweeper Wake on Lan in VLANs
by  FrankSc   Go to last post Go to first unread
Last post: 7/3/2020 1:56:46 PM(UTC)
Lansweeper Ticket Closed = email to all helpdesk desk agents
by  Laurent Maene  
Go to last post Go to first unread
Last post: 7/3/2020 1:23:49 PM(UTC)
Lansweeper Helpdek Call Re-Opened
by  pryan67   Go to last post Go to first unread
Last post: 7/3/2020 1:12:17 PM(UTC)
Lansweeper Office 365 32bit vs 64bit?
by  brodiemac-too  
Go to last post Go to first unread
Last post: 7/2/2020 10:35:19 PM(UTC)