All Questions
15
questions
-1
votes
3
answers
1k
views
PowerShell: Export Ping Results to CSV
I have a PowerShell loop that does effectively what I want it to. The problem is that the output is very messy. I work for an ISP and one of the most effective ways we have to diagnose network issues ...
- 11
1
vote
2
answers
2k
views
Export Excel sheet as CSV, with regional settings
I want to export an excel sheet as CSV, with powershell. The issue I have is that the regional settings are not respected. They say to use semicolon as delimiter, but comma is used instead. If I ...
- 194
2
votes
2
answers
2k
views
Powershell script help needed for displaying network interfaces
I have a script [below] that returns information about the network interfaces in .csv format, but I also need the InterfaceAlias of each adapter returned; unfortunately, I cannot get get-wmiobject ...
- 21
2
votes
0
answers
872
views
Loading UTF8 CSV files generated on a Mac into Excel on Windows: does not recognize encoding
When I generate a UTF8 CSV file in Excel (or some other way) on Windows and then open it n Excel, I expect it to ask me to choose the right encoding.
I got a UTF8 CSV file that was generated on a Mac. ...
- 489
0
votes
3
answers
421
views
Export SSL & TLS Registry Keys to XLSX
I'm currently looking to find out all SSL and TLS Registry value information on the system. I need help writing a script for powershell to look at a list of hosts that are on a csv/txt file then ...
- 53
3
votes
1
answer
438
views
How to trim down PowerShell output in .csv file to write only the Release ID of a Windows 10 OS?
This script work but the output to the .csv in the release id field is everything associated with the registry key. All I want in the field is the release id number (1909, 1809, 1709). How to I edit ...
- 259
-1
votes
1
answer
289
views
How to get folder location of file? (Powershell) [closed]
I am using the script below, found on this thread.. I would like to automatically save the Excel file in the same folder as the CSV file, using the same name as the CSV file.
How can I get the ...
- 11
1
vote
2
answers
3k
views
Splitting a xlsx/csv file based on column value
I'm aware this question has been asked previously, but I've had no luck with previous answers. My spreadsheet has around 30000 total lines.
My spreadsheet is formatted like this:
Name,colour,...
- 11
0
votes
1
answer
4k
views
Deleting rows in Excel using powershell
I have a csv file which has a series of pin-codes in column A but the first row/cell (A1) is empty and I need to delete the whole row using Powershell,
any ideas?
I have tried this but it did nothing!...
- 11
1
vote
2
answers
7k
views
How to I export filenames, filepath and properties of a directory tree to CSV?
I have a hard drive full of backups that I need to detail on a spreadsheet quickly and in the following specific way. I'm hoping there's an easy way to do what i need via some sort of .bat or .cmd ...
- 1,303
1
vote
2
answers
3k
views
Trying to export single column's data from large CSV file
Problem: I am trying to export a single column of a .CSV file that is 7 gigs in size (large enough that I can't open the entire file in excel... or most text editors for that matter) to a smaller file ...
- 13
0
votes
1
answer
1k
views
csv export keeps overwriting itself
I am having issues with the script overwriting itself and not holding onto the values. The only thing exported to the CSV is the list of active users on the last server, instead of all the users and ...
- 13
0
votes
1
answer
130
views
Split name column to csv file
How can I easily transform columns information to CSV line or file output?
Input (From file or excel column):
ABC1
ABC2
ABC3
ABC4
Output (To file or excel line):
ABC21,ABC2,ABC3,ABC4
I don't want ...
2
votes
2
answers
6k
views
Best way to search for a string (text) in >10 large CSV files (250mb each)
I am wondering what's the best way or tool to search for a specific text or string in more than 10 large .csv files. Each file is 250mb in size.
My idea was to write a powershell script, since I ...
- 221
-1
votes
1
answer
1k
views
Invalid date value in csv file
I export data in csv format from sql server database. It contain 5 column. one column have date and time value. When i checked the date -time value i found date time value is in wrong format. I add ...
- 320