CSVTOOL(1) [FIXME: manual] CSVTOOL(1)NAME
csvtool - tool for performing manipulations on CSV files from shell scripts
SYNOPSIS
csvtool [options] command [command-args] input.csv...
DESCRIPTION
This manual page documents briefly the csvtool command.
This manual page was written for the Debian distribution because the original program does not have a manual page. Instead, it has
documentation accessible with the --help option.
csvtool is a tool for performing manipulations on CSV files from shell scripts.
OPTIONS -help --help
Show help.
AUTHOR
This manual page was written by Stephane Glondu steph@glondu.net for the Debian system (but may be used by others). Permission is granted
to copy, distribute and/or modify this document under the terms of the GNU General Public License, Version 2 any later version published by
the Free Software Foundation.
On Debian systems, the complete text of the GNU General Public License can be found in /usr/share/common-licenses/GPL.
COPYRIGHT
Copyright (C) 2008 Stephane Glondu
[FIXME: source] January 15, 2008 CSVTOOL(1)
Check Out this Related Man Page
CONFIG-MANAGER(1) General Commands Manual CONFIG-MANAGER(1)NAME
cm -- Work with configs.
SYNOPSIS
cm [-a] [-v] [-d] [-s] [-p] [-r] [-n]
DESCRIPTION
This manual page documents briefly the cm tool.
This manual page was written for the Debian distribution because the original program does not have a manual page.
cm is a program that manages directory trees. The components of a directory tree are specified by a recipe (also known as a config).
A recipe can specify that the directories components should be retrieved via Arch, CVS, HTTP or FTP as appropriate.
OPTIONS
These programs follow the usual GNU command line syntax, with long options starting with two dashes (`-'). A summary of options is
included below. For a complete description, see the Info files.
-h--help
Show summary of options.
-v--version
Show version of program.
SEE ALSO
tla (1)
AUTHOR
This manual page was written by Anand Kumria wildfire@progsoc.org for the Debian system (but may be used by others). Permission is granted
to copy, distribute and/or modify this document under the terms of the GNU General Public License, Version 2 any later version published by
the Free Software Foundation.
On Debian systems, the complete text of the GNU General Public License can be found in /usr/share/common-licenses/GPL.
CONFIG-MANAGER(1)
Hi
How can I delete a columns from a CSV file which has comma separated value with a string enclosed in double quotes or square bracket and a comma in between?
I have a csv file with below format.
Template,Target Server,Target Component,Rule Group,Rule,Rule Reference Number,Rule... (7 Replies)
hi,
i have a file
abc,"an,ab",cde,efg
abc,anab,cde,efg and need to cut the second field so the output should be abc,cde,efg and i have used cut -d',' -f1-1,3- but its giving me
abc,ab",cde,efg
abc,cde,efg (4 Replies)
Hi All
I had requirement where I need to re-order columns in a file by using a control file.
here is the ctrl file
c1
c2
c3
source file
c3 | c1 | c2
a | b| c
I should create output file based on the ctrl file columns
o/p should look like this
c1 | c2 | c3
b| c|a
I wrote some... (9 Replies)
I have a file with two columns separated by white space.
Dog Cat
fido sneaky
dopey poptart
ears whisker
barky herd
Trying to list the words under the column named Dog. Tried a few variations of awk but can't... (4 Replies)
Hello,
I have to fish out some specific columns from a file based on the header value. I have the list of columns I need in a different file. I thought I could read in the list of headers I need,
# file with header names of required columns in required order
headers_file=$2
# read contents... (11 Replies)
Hello,
I have some tab delimited text data,
index name chg_p chg_m
1 name,1 1 0
2 name,2 1 1
3 name,3 1 0
4 name,4 1 0
5 name,5 1 1
I need to duplicate the "index" column, call it "id" and insert it after the... (8 Replies)
Goodmorning,
I know how to cut a string and a column, and how to find a word.
I have a file with over 100 columns. All columns have a title in the first line. I have to delete all columns with the XXX title.
I can't use cut -f because the position of XXX columns change in each file, and in... (14 Replies)
Hello,
I have 40 data files where the first three columns are the same (in theory) and the 4th column is different. Here is an example of three files,
file 2: A_f0_r179_pred.txt
Id Group Name E0
1 V N(,)'1 0.2904
2 V N(,)'2 0.3180
3 V N(,)'3 0.3277
4 V N(,)'4 0.3675
5 V N(,)'5 0.3456
... (8 Replies)
Hi,
I am having below two CSV's
col_1,col_2,col_3
1,2,4
1,3,6
col_1,col_3,col2,col_5,col_6
1,2,3,4,5
1,6,3,,,
I need to compare based on the columns where the mismatch is
expected output
col_1,col_2,col_3
1,2,4 (3 Replies)
Hi Experts,
Please support
I have below data in file in comma seperated, but 4th column is containing comma in between numbers, bcz of which when i tried to parse the file the column 6th value(5049641141) is being removed from the file and value(222.82) in column 5 becoming value of column6.
... (3 Replies)
My CSV file looks similar to this example (the K, L, and M are in the same cell as J but each on a new line within that cell):
1, A, B, C, D
2, E, F, G, H
3, I, J N, O,
K
L
M,
4, P, Q, R, S
I would like to have it look like this:
1, A,... (6 Replies)
Hi ALL,
file data like :
test.csv
a,b,"c,d"
my awk version is 4.0.2 ,if i am using the below code is working fine.
awk -vFPAT='(*)|("+")' -vOFS="," '{print $3}' test.csv
if the awk version is 3.1.7 is not working . Could you please help me on this one.
output should be : "c,d" (6 Replies)