03-08-2010
Thanks a lot! It is really solving the problem! Well done.
However when I open the file I get
9-DEC-2008,ED,DEC08,C,92.5,0,0,0,0,0,0,0,0,0,0,0,0,0,0,<cr>,98,
Do you know whether the <cr> should worry me?
In any case I am just going to use a few columns of these files that I know hot to proceed.
I am just a starter so your help was really very much appreciated.
Cheers and have a nice week!
Pep
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
Hello!
I wan't to extract columns from two files and later combine them for plotting with gnuplot. If the files file1 and file2 look like:
fiile1:
a, 0.62,x
b, 0.61,x
file2:
a, 0.43,x
b, 0,49,x
The desired output is
a 0.62 0.62
b 0.61 0.49
Thank you in advance! (2 Replies)
Discussion started by: kingkong
2 Replies
2. UNIX for Dummies Questions & Answers
I need a little help as I am a complete novice at scripting in unix. However, i am posed with an issue...:eek: i have two csv files in the following format@
FILE1.CSV:
HEADER
HEADER
Header
, , HEADER
001X ,,200
002X ,,300
003X ... (6 Replies)
Discussion started by: chachabronson
6 Replies
3. UNIX for Dummies Questions & Answers
I am trying to place all my data in a single row (order doesn't matter). Note I am a Unix novice, so please go easy on me.
Here is an example
Raw data:
row#
(1) 45 64 23
(2) 32 1 6 56
(3) 32 45
Needs to be like this:
row#
(1) 45
(2) 32
(3) 32 ... (2 Replies)
Discussion started by: mmann1123
2 Replies
4. Shell Programming and Scripting
Hi,
I have different files of the same type, as:
Time:
100
snr:
88
perf:
10
other:
222
Each of these files are created periodically.
What I need to do is to merge all of them into one but having the following form: (2 Replies)
Discussion started by: Ravendark
2 Replies
5. Shell Programming and Scripting
I have 48 csv files in my directory that all have this form:
Storm Speed (mph),43.0410781151
Storm motion direction (degrees),261.580774982
MLCAPE,2450.54098661
MLCIN,-9.85040520279
MLLCL,230
MLLFC,1070.39871
MLEL,207.194689294
MLCT,Not enough data
Sbcape,2203.97617778... (3 Replies)
Discussion started by: RissaR
3 Replies
6. Shell Programming and Scripting
Hi,
I have two very large CSV files, which I want to merge (equi-join) based on a key (column).
One of the file (say F1) would have ~30 MM records and 700 columns. The other file (~f2) would have same # of records and lesser columns (say 50). I want to create an output file joining on a... (3 Replies)
Discussion started by: student_007
3 Replies
7. Shell Programming and Scripting
Hi,
I have following 2 CSV files
file1.txt
A1,B1,C1,D1,E1
A2,B2,C2,D2,E2
A3,B3,C3,D3,E3
....
file2.txt
A1,B1,P1,Q1,R1,S1,T1,U1
A1,B1,P2,Q2,R2,S2,T2,U2
A1,B1,P3,Q3,R3,S3,T3,U3
A2,B2,X1,Y1,Z1,I1,J1,K1
A2,B2,X2,Y2,Z2,I2,J2,K2
A2,B2,X3,Y3,Z3,I3,J3,K3
A2,B2,X4,Y4,Z4,I4,J4,K4... (2 Replies)
Discussion started by: learnoutmore99
2 Replies
8. Shell Programming and Scripting
Hi,
I'm not a regular coder but some times I write some basic perl script, hence Perl is bit difficult for me :).
I'm merging two files a.txt and b.txt into c.txt:
a.txt
------
x001;frtb70;xyz;109
x001;frvt65;sec;239
x003;wqax34;jul;659
x004;yhud43;yhn;760
b.txt
------... (8 Replies)
Discussion started by: Lokesha
8 Replies
9. Shell Programming and Scripting
Hi all, I'm pretty much a newbie to UNIX. I would appreciate any help with UNIX coding on comparing two large csv files (greater than 10 GB in size), and output a file with matching columns.
I want to compare file1 and file2 by 'id' and 'chain' columns, then extract exact matching rows'... (5 Replies)
Discussion started by: bkane3
5 Replies
10. 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
LEARN ABOUT DEBIAN
pocount
pocount(1) Translate Toolkit 1.3.0 pocount(1)
NAME
pocount - Produces word counts and other statistics from a PO file.
SYNOPSIS
pocount [--csv] [directory|file(s)]
DESCRIPTION
pocount will count the number of strings and words in a PO file.
If no files or directories argument are provided, pocount will recurse through all files from the current directory. Otherwise, it will
recurse and count all files in the specified directory or in the specified PO files.
OPTIONS
--csv changes the output format to CSV (Comma Seperated Values) for import into a spreadsheet.
OUTPUT
In normal mode the following output is given:
avmedia/source/viewer.po
type strings words (source) words (translation)
translated: 1 3 3
fuzzy: 0 0 n/a
untranslated: 4 22 n/a
Total: 5 25 3
review 1 3 n/a
In CSV mode the following outut is shown:
Filename, Translated Messages, Translated Source Words, Translated Target Words, Fuzzy Messages, Fuzzy Source Words, Untranslated Mes-
sages, Untranslated Source Words, Review Messages, Review Source Words
avmedia/source/viewer.po, 1, 3, 3, 0, 0, 4, 22, 1, 3
Totals are not provided in CSV mode. In normal mode a grand total and file count is provided if the number of files is greater than one.
BUGS
There are some miscounts related to word breaks.
Translate Toolkit 1.3.0 pocount(1)