Hi, I have a csv file with a key composed by 3 columns and some other numeric fields and I need to obtain the partial amounts by some part of the key. This may be some difficult to understand, so better see an example, where my input file is:
name,surname,department,y2004,y2005,y2006... (6 Replies)
Hi,
Can you please tell me how to add empty columns at the end csv file?
Currently there are 6 columns in the csv file. I want to add 35 empty columns at the end of this csv file.
Thanks,
Tushar (17 Replies)
Hi everybody,
I am new here and I need a reel help please
A have a csv file and I want to add new in the end of the file
Devisce Model,VMGuest Name,Host OS Name, Memory Size
Value1,Value2,Value3,Value4
Value5,Value6,Value7,Value8
Value9,Value10,Value11,Value12
And I want to add to new... (3 Replies)
Hi everybody,
I need some help please
I have a csv file named masterFile1.csv
header1,header2,header3
value1,value2,value3
value4,value5,value6
I am trying to add new columns in the end of the csv to have a new csv file named masterFile2.csv like this :... (3 Replies)
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)
Hello Members,
I have a csv file in the format below. Need help with awk statement to break nth column into 3 separate columns and export the changes to new file.
input file --> file.csv
cat file.csv|less
"product/fruit/mango","location/asia/india","type/alphonso"
need output in... (2 Replies)
Hi,
I would like extract some lines from file csv using awk , below the example:
I have the file test.csv with in content below.
FLUSSO;COD;DATA_LAV;ESITO
ULL;78;17/09/2013;OL
ULL;45;05/09/2013;Apertura
NP;45;13/09/2013;Riallineamento
ULLNP;78;17/09/2013;OL
NPG;14;12/09/2013;AperturaTK... (6 Replies)
I have a .CSV file (lets say named as file.csv) with numeric and string values. The string might contain commas hence they are enclosed in double quotes as in the below format.
column1,column2,column3,column4,column5,column6,column7
12,455,"string, with, quotes, and with, commas, in... (3 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 Guys,
Can you help to add static values at the end of the csv file with headers
input_file
id,name
1,neo
2,pull
Expected
id,name,status,entry,g_id
1,neo,done,2019-11-01T07:14:23,pass
2,pull,done,2019-11-01T07:14:23,pass
My try but not able replacing properly and unable... (1 Reply)
Discussion started by: Master_Mind
1 Replies
LEARN ABOUT ULTRIX
makedbm
makedbm(8yp)makedbm(8yp)Name
makedbm - make a yellow pages dbm file
Syntax
makedbm [ -i yp_input_file ] [ -o yp_output_name ] [ -d yp_domain_name ] [ -m yp_master_name ] infile outfile
makedbm [ -u dbmfilename ]
Description
The command takes the file specified by the argument infile and converts it to a pair of files in format, namely and Each line of the input
file is converted to a single record. All characters up to the first tab or space form the key, and the rest of the line is defined as the
key's associated data. If a line ends with a backslash (), the data for that record is continued onto the next line. It is left for the
clients of the yellow pages to interpret the number sign (#); does not treat it as a comment character. The infile parameter can be a
hyphen (-), in which case reads the standard input.
The command is meant to be used in generating files for the yellow pages service. The command generates a special entry with the key
yp_last_modified, which is the date of infile.
Options-i Create a special entry with the key yp_input_file.
-o Create a special entry with the key yp_output_name.
-d Create a special entry with the key yp_domain_name.
-m Create a special entry with the key yp_master_name. If no master host name is specified, yp_master_name will be set to the local
host name.
-u Undo a file. That is, print out a file one entry per line, with a single space separating keys from values.
Examples
The following example shows how a combination of commands can be used to make the yellow pages files and from the file. The percent sign
(%) signifies the system prompt.
% awk 'BEGIN { FS = ":"; OFS = ""; }
{ print $1, $0 }' /etc/passwd > ptmp
% makedbm ptmp passwd.byname
% rm ptmp
The command creates the file ptmp which is in a form usable by The command uses the ptmp file to create the yellow pages dbm files and The
command removes the ptmp file.
See Alsoyppasswd(1yp), dbm(3x), ypmake(8yp)makedbm(8yp)