I have about 20 CSV's that all look like this:
"","","","","","","","","","","","","","","",""What I've been told I need to produce is the exact same thing, but with each file now containing the start_code from every other file where the email matches.
It doesn't matter if any of the other... (1 Reply)
Hi,
I am regular reader of this forum. My advanced thanks to everyone.
Below given are the sample files
INDATA (Main data)
Fild1Çfld2Çfld3…..
Fild1Çfld2Çfld3…..
Fild1Çfld2Çfld3…..
Fild1Çfld2Çfld3…..
Fild1Çfld2Çfld3…..
.
.
N records (140000) eg
GRPDATA (Reference file) (2 Replies)
Hello;
I have a file consists of 4 columns separated by tab. The problem is the third fields. Some of the them are very long but can be split by the vertical bar "|". Also some of them do not contain the string "UniProt", but I could ignore it at this moment, and sort the file afterwards. Here is... (5 Replies)
Hi,
I've one requirement. I have to split one comma delimited file into multiple files based on one of the column values.
How can I achieve this Unix
Here is the sample data. In this case I have split the files based on date column(c4)
Input file
c1,c2,c3,c4,c5... (1 Reply)
Good day all
I need some helps,
say that I have data like below, each field separated by a tab
DATE NAME ADDRESS
15/7/2012 LX a.b.c
15/7/2012 LX1 a.b.c
16/7/2012 AB a.b.c
16/7/2012 AB2 a.b.c
15/7/2012 LX2 a.b.c... (2 Replies)
I have a .CSV file (file.csv) whose data are all enclosed in double quotes. Sample format of the file is as below:
column1,column2,column3,column4,column5,column6, column7, Column8, Column9, Column10
"12","B000QRIGJ4","4432","string with quotes, and with a comma, and colon: in... (3 Replies)
Hi guys,
I have a requirement where i need to split a .csv file into multiple files.
Say for example i have data.csv file and i have splitted that into multiple files based on some conditions i.e first file should have 100, last file 50 and other files 1000 each. Am passing the values in... (2 Replies)
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)
Hi,
In a csv file, I want to select records where first column has zero or multiple spaces.
Eg: abc.csv
,123,a
,22,b
,11,c
a,11,d
So output should be:
,123,a
,22,b
,11,c
Please advise (5 Replies)
Discussion started by: vegasluxor
5 Replies
LEARN ABOUT NETBSD
pac
PAC(8) BSD System Manager's Manual PAC(8)NAME
pac -- printer/plotter accounting information
SYNOPSIS
pac [-cmrs] [-P printer] [-p price] [name ...]
DESCRIPTION
pac reads the printer/plotter accounting files, accumulating the number of pages (the usual case) or feet (for raster devices) of paper con-
sumed by each user, and printing out how much each user consumed in pages or feet and dollars.
Options and operands available:
-Pprinter Accounting is done for the named printer. Normally, accounting is done for the default printer (site dependent) or the value of
the environment variable PRINTER is used.
-c flag causes the output to be sorted by cost; usually the output is sorted alphabetically by name.
-m flag causes the host name to be ignored in the accounting file. This allows for a user on multiple machines to have all of his
printing charges grouped together.
-pprice The value price is used for the cost in dollars instead of the default value of 0.02 or the price specified in /etc/printcap.
-r Reverse the sorting order.
-s Accounting information is summarized on the summary accounting file; this summarization is necessary since on a busy system, the
accounting file can grow by several lines per day.
names Statistics are only printed for user(s) name; usually, statistics are printed for every user who has used any paper.
OUTPUT FORMAT
pac formats the output into simple table, using four columns - number of feets or pages (column "pages/feet"), how many copies were made
(column "runs"), total price for this print (column "price") and user login with host name (column "login" or "host name and login"). If
argument name was not used and hence pac is printing information for all users, a summary line with print totals (runs, pages, price) is
appended.
Note that pac on other system might print the price as price per copy.
FILES
/var/account/?acct raw accounting files
/var/account/?_sum summary accounting files
/etc/printcap printer capability data base
SEE ALSO printcap(5)HISTORY
The pac command appeared in 4.0BSD.
BUGS
The relationship between the computed price and reality is as yet unknown.
BSD June 6, 1993 BSD