Questions tagged [csv]

Comma Separated Values is a tabular to store data

Comma Separated Values is a tabular to store data in plain text. There is no single CSV format, but in general there are 4 principles:

  • are plain text files (basically, this means numeric, graphical, or other values are expressed using printable characters rather than various-sized groups of bits),
  • consists of records (typically one per line),
  • with the records divided into fields that are separated by delimiters (typically a single reserved character such as comma or TAB, or sometimes any sequence of spaces and tabs),
  • where every record includes exactly the same sequence of fields (this is very occasionally violated).

Source: wikipedia

80 questions
0
votes
1 answer

How to extract the Table Definitions of a MYSQL Table into CSV?

The output of mysqldump -not csv does not contain the columns, just values: select * from AUDIT_RESULT INTO OUTFILE '/va/tmp/audit_nresult.csv' FIELDS TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY '\n'; It does not contain the column…
MethodistMX
  • 23
  • 1
  • 1
  • 4
0
votes
0 answers

Issues with Bash Script to SSH and Copy String Variables from a CSV to a remote file

Here is my script #!/bin/bash clear PSQLSTART="INSERT INTO TABLE (Name, Description, Field3, Field4, Field5, Field6, Field7, Field8, Field9, Field10, Field11, Field12, Field13, Field14, Field15, Field16, Field17, Field18) VALUES" echo "What is…
mc587
  • 1
0
votes
0 answers

Upload 300MB or more CSV file to GCP storage bucket

I am trying to upload a 3GB CSV file to Google Cloud Storage Bucket but every time I try it only processing 295.5MB and uploads 295.5MB. Why is this? I have set my bucket size limit to 15GB.
-1
votes
1 answer

linux mysql convert .sql.tar.gz to csv

I have a .sql.tar.gz file tht ws generated by mysql export is there any command in linux to convert this sql.tar.gz file to csv? Thanks
-3
votes
2 answers

User Group membership script not working

Any idea why below code is not working ? Trying to export username then the groups on to a csv. I just need the group names only. Please help - many thanks $users = (Get-Content users.txt) foreach ($user in $users) { $file = $user.Name + '_ACL' …
kbriaz
  • 1
1 2 3 4 5
6