08-19-2018
The code works. It was tested with your samples posted. Did you try with those?
If you chose to change the datas' field separators, you need to adapt awk's FS variable as well. Add the -F\; option.
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi all,
Am new to scripting. So i just need your ideas to help me out. Here goes my requirement.
I have two csv files
1.csv 2.csv
abc,1.24 abc,1
def,2.13 def,1
I need to compare the first column of 1.csv with 2.csv and if matches then need to compare... (2 Replies)
Discussion started by: chinnahyd
2 Replies
2. UNIX for Advanced & Expert Users
Hi ,
I have a requirement to compare 2 files which can contain 40 million or more records and more than 20 fields to compare .
Currently I am using awk scripting , and since awk has a memory issue, I am not able to process file more than 10 million records.
Any suggestions or pointers to... (7 Replies)
Discussion started by: rashmisb
7 Replies
3. Shell Programming and Scripting
Hi All,
I have two different files as shown below separated by a "|". I need to compare the first column from both the files and if they match merge both the columns.
File 1
"S00172012"|"CHRONIC RENAL FAILURE"|""|"I"
"S00159962"|"SUBENDO INFRC-INIT EPISD"|""|"I"
"S00255303"|"BENIGN... (6 Replies)
Discussion started by: nua7
6 Replies
4. Shell Programming and Scripting
(say) I have 2 csv files - file1.csv & file2.csv as mentioned below:
file1.csv
ID,version,cost
1000,1,30
2000,2,40
3000,3,50
4000,4,60
file2.csv
ID,version,cost
1000,1,30
2000,2,45
3000,4,55
6000,5,70
The... (7 Replies)
Discussion started by: Naresh101
7 Replies
5. Shell Programming and Scripting
Hello:
Newbie with Awk. Trying to compare two files and merge data based on CID. Please see the input file format and desired output. Any help is appreciated.
TIA
Input File1
CID1 --- TYP1 --- DCN1 --- INDATE1 --- IN-DATA1
CID2 --- TYP2 --- DCN2 --- INDATE2 --- IN-DATA2
CID3 ---... (6 Replies)
Discussion started by: wincrazy
6 Replies
6. Shell Programming and Scripting
I have lot of csv file collected from script like below :
Name of files (some examples) there are thousands of it:
192.168.0.123_251_18796_1433144473.csv
192.168.0.123_251_18796_1433144772.csv
192.168.0.123_251_18796_1433145073.csv
192.168.0.123_251_18796_1433145372.csvContent of each... (5 Replies)
Discussion started by: rk4k
5 Replies
7. UNIX for Dummies Questions & Answers
Hi all,
I have two separate csv files(comma delimited) file 1 and file 2.
File 1 contains
PAN,NAME,Salary
AAAAA5467D,Raj,50000
AAFAC5467D,Ram,60000
BDCFA5677D,Kumar,90000
File 2 contains
PAN,NAME,Dept,Salary
ASDFG6756T,Karthik,ABC,450000
QWERT8765Y,JAX,CDR,780000... (5 Replies)
Discussion started by: Nivas
5 Replies
8. Shell Programming and Scripting
Hello everybody
Looking for help in comparing two files in Linux(files are big 800MB each).
Example:-
File1 has below data
$ cat file1
5,6,3
2.1.4
1,1,1
8,9,1
File2 has below data
$ cat file2
5,6,3
8,9,8
1,2,1
2,1,4 (1 Reply)
Discussion started by: shanul karim
1 Replies
9. UNIX for Beginners Questions & Answers
Hello everybody
Looking for help in comparing two files in Linux(files are big 800MB each).
Example:-
File1 has below data
$ cat file1
5,6,3
2.1.4
1,1,1
8,9,1
File2 has below data
$ cat file2
5,6,3
8,9,8
1,2,1
2,1,4 (8 Replies)
Discussion started by: shanul karim
8 Replies
10. UNIX for Beginners Questions & Answers
I have three files with similar pattern i need to merge all the coloumns side by side from all three files according to the first coloumn example as shown below
I mentioned 5 coloumns only in example but i have around 15 coloumns in each file.
file1:
Name,Samples,Error,95RT,90RT... (4 Replies)
Discussion started by: Raghuram717
4 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)