10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi,
I have a file of csv data, which looks like this:
file1:
1AA,LGV_PONCEY_LES_ATHEE,1,\N,1,00020460E1,0,\N,\N,\N,\N,2,00.22335321,0.00466628
2BB,LES_POUGES_ASF,\N,200,200,00006298G1,0,\N,\N,\N,\N,1,00.30887539,0.00050312... (10 Replies)
Discussion started by: djoseph
10 Replies
2. Shell Programming and Scripting
Hi,
Can anyone please explain me how can I add a new column to a Csv file ?
Actaully I am setting one set of commands and creating a CSV file with 4 columns.
I am executing another command and it's output should be added as column 5 with a column heading ?
Can anyone explain how can... (26 Replies)
Discussion started by: rrb2009
26 Replies
3. Shell Programming and Scripting
Hi Friends,
I have come across some files where some of the columns don not have data.
Key, Data1,Data2,Data3,Data4,Data5
A,5,6,,10,,
A,3,4,,3,,
B,1,,4,5,,
B,2,,3,4,,
If we see the above data on Data5 column do not have any row got filled. So remove only that column(Here Data5) and... (4 Replies)
Discussion started by: ks_reddy
4 Replies
4. Shell Programming and Scripting
Trying in this forum. Not sure if it is permitted.... but in need of help.
Please find the requirements in the below link.
https://www.unix.com/unix-dummies-questions-answers/191503-add-extra-commas-csv-file-2.html#post302665179
Thanks in Advance. (1 Reply)
Discussion started by: chillblue
1 Replies
5. UNIX for Advanced & Expert Users
Hi All,
i have a .Csv file in the below format
startTime, endTime, delta, gName, rName, rNumber, m2239max, m2239min, m2239avg, m100016509avg, m100019240max, metric3min, m100019240avg, propValues
11-Mar-2012 00:00:00, 11-Mar-2012 00:05:00, 300.0, vma3550a, a-1_CPU Index<1>, 200237463, 0.0,... (9 Replies)
Discussion started by: mahi_mayu069
9 Replies
6. UNIX for Advanced & Expert Users
Hi experts
I have a .csv file which contains
the csv is comma seperated file
col1 col2
1 2
3 4
5 6
7 8
I want the colums to be added and the output must be
col1 col2 col3
1 2 3
3 4 7
5 6 11
7 8 15
Please help:( (1 Reply)
Discussion started by: mariselvam
1 Replies
7. UNIX for Advanced & Expert Users
Hi All,
I have two .csv's
input.csv having values as (7 columns)
ABC,A19907103,ABC DEV YUNG,2.17,1000,2157,07/07/2006
XYZ,H00213850,MM TRUP HILL,38.38,580,23308,31/08/2010
output.csv having (25 columns)
A,B,C,D,E,F,G,H,I,J,K,L,M,N,O,P,Q,R,S,T,U,V,W,X,Y... (4 Replies)
Discussion started by: abhivyas
4 Replies
8. UNIX for Dummies Questions & Answers
I want to select the first column from a daily file called foo.csv. The result is written to file foo.txt. Currently the following script is used for that:
cut -d, -f 1 foo.csv > foo.txt
A typical result would yield :
A12
A45
B11
B67
What needs to happen in addition is that two columns... (5 Replies)
Discussion started by: figaro
5 Replies
9. UNIX for Advanced & Expert Users
I have the following data in FILE1.CSV:
code: Amount1: Amount2:
xxxxx ,, 200 ,,400
yyxxa ,,200
bbcgu ,,2500 ,,300
i want to be able to produce the following FILE2.CSV:
code: Amount
xxxxx ,, 600... (7 Replies)
Discussion started by: chachabronson
7 Replies
10. Shell Programming and Scripting
Hi Wise UNIX Crew,
I want to add 3 different columns to the file in which:
1. The first new column pulls in today's date and time
2. Second column one has a '0'
3. Third column has the word 'ANY' going down the column
If my file content is as follows:
"7","a","abc",123"... (1 Reply)
Discussion started by: dolo21taf
1 Replies
csv2po(1) Translate Toolkit 1.9.0 csv2po(1)
NAME
csv2po - convert Comma-Separated Value (.csv) files to Gettext PO localization files
SYNOPSIS
csv2po [--version] [-h|--help] [--manpage] [--progress PROGRESS] [--errorlevel ERRORLEVEL] [-i|--input] INPUT [-x|--exclude EXCLUDE]
[-o|--output] OUTPUT [-t|--template TEMPLATE] [--charset CHARSET] [--columnorder] [--duplicates DUPLICATESTYLE]
DESCRIPTION
See: http://translate.sourceforge.net/wiki/toolkit/csv2po for examples and usage instructions
OPTIONS
--version
show program's version number and exit
-h/--help
show this help message and exit
--manpage
output a manpage based on the help
--progress
show progress as: dots, none, bar, names, verbose
--errorlevel
show errorlevel as: none, message, exception, traceback
-i/--input
read from INPUT in csv format
-x/--exclude
exclude names matching EXCLUDE from input paths
-o/--output
write to OUTPUT in po, pot formats
-t/--template
read from TEMPLATE in pot, po, pot formats
--charset
set charset to decode from csv files
--columnorder
specify the order and position of columns (location,source,target)
--duplicates
what to do with duplicate strings (identical source text): merge, msgctxt (default: 'msgctxt')
Translate Toolkit 1.9.0 csv2po(1)