Questions tagged [export-csv]
Exporting data in the CSV data format (comma-separated values). A CSV file stores tabular data (numbers and text) in plain text. Use this tag for questions regarding creating .csv files.
export-csv
162
questions
0
votes
1
answer
38
views
Error when using the copy function in postgresql
I need to use the copy function with innerjoin from more than one table with where.
Postgresql if pgadmin 4
When I do this query, it returns the data I need
select * from estabelecimento join empresa ...
0
votes
1
answer
45
views
Unsure how to get Export-Csv to work for what I need
I have to rename a little over 100 computers in the warehouse where I work. My script is setup to delay the renaming process until a desired time and gets the computer names from a .csv file. The ...
- 3
0
votes
3
answers
144
views
Convert text File to CSV Format using powershell
I want to convert the Text File to CSV File and below is the Format using Powershell and need some assistance
Text File Structure: This is how the data looks in output or text file
Content for ...
- 45
0
votes
0
answers
34
views
Powershell export-csv column order
I am importing a CSV file, and running an application to decode some data from one of the columns, then I wish to export-csv all of that to a new file. I used this as a reference
PowerShell Output to ...
- 31
0
votes
1
answer
50
views
Wice_Grid gem having issues in export CSV with Rails 7.1.3
We are working on a project that is migrating to Rails 7; we had a wice-grid gem working for Rails 2 but with Rails 7 we are not getting export functionality working. Is there any documentation or any ...
- 1
0
votes
0
answers
277
views
Powershell Export-CSV Error - "The process cannot access the file \\xxx\hhh\fff\report.csv because it is being used by another process
Help please - I have a script to report all DFS folder targets and will check the path status but I'm getting a random export-csv error "The process cannot access the file \xxx\hhh\fff\report.csv ...
- 1
1
vote
1
answer
57
views
Powershell referencing property within a property and exporting to CSV
From my RMM tool and using a module written by an awesome dude called HomoTechsual ( NinjaOne ), I can get a list of organisations, which have various properties:
name : Test Organisation ...
- 25
0
votes
2
answers
71
views
How to export resultset of a procedure with parameters using T-SQL command in SQL Azure database
I have to export the results of a stored procedure with 2 input parameters in SQL Azure instance using a T-SQL command to a .csv file in SSMS. Thing is, I need to run this stored procedure 3000+ times ...
- 567
0
votes
1
answer
75
views
bash compile output into a csv using jq?
I am writing a bash script to create a csv from a sample inconsistent json data but running into a bunch of issues :
My json data looks like this :
json_data='[
{
"ResourceARN": "...
- 1,470
2
votes
1
answer
277
views
App script to export the Gsheets to CSV and replace the existing files in the same folder
I am using the below app script to export Gsheets to CSV, however evertime i use the below code it created new folder/files on Gdrive however what i want to do is to update the exsisting CSV files on ...
1
vote
1
answer
50
views
How to ignore commas in cell value when using StreamWriter to write to csv output
I am processing a .txt file, which needs to be repeated every 10 lines. I then want to turn this into a .csv file. However, some of the .txt file contains commas which I want to keep in a single cell ...
- 1,799
0
votes
0
answers
9
views
Export Records from CSV File With Current Month's Data
I am trying to export records form a YTD CSV file that have records with the current month. Example of data below. I can not figure this out:
"3MCO","","00280916",&...
- 1
0
votes
1
answer
31
views
Exporting to CSV: Need help combining outputs to CSV
I am unable to figure out how to get both the $ModelInfo and $SeriaNumber to output to the CSV on a single line.
$LocalComputer = Read-Host "Enter Local Computer Name"
$Computer = Import-Csv ...
- 1
0
votes
1
answer
70
views
PSCustomObject members to CSV within single cell
EDIT:
For what it's worth, I was able to achieve something better, I think. Hope it helps people:
Using:
$licenseSearchTerm = 'dyn'
$arrayResults = @()
foreach ($userWithLicense in $...
- 575
0
votes
1
answer
128
views
PowerShell switch return missing file based on group
In theory, now that all the files in the '2023' folders have the same number of elements in the file name I can get an inventory. See my previous post for reference btw thanks @mklement0 it said not ...
- 13