03-23-2015
I am confused.
The sample input data you provided was a single line with 112 fields; not the 16 field lines you were talking about. (I tried guessing at the intended format, but I have no idea whether I guessed correctly.)
Your sample awk code specifies that the input and output field separators are commas, but your sample input data contains no commas.
You say you want to add headings to the new fields you create, but you don't specify what the headings should be and there aren't any headings on the other fields (to use as examples).
And, the sample output you showed us can't possibly have been produced from the sample input you showed us.
Please clearly specify what format your input takes, and show us a sample of the output you're trying to produce. (And PLEASE use CODE tags (not ICODE tags) for sample input and output as well as for code samples.)
This User Gave Thanks to Don Cragun For This Post:
10 More Discussions You Might Find Interesting
1. Filesystems, Disks and Memory
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)
Discussion started by: oscarmon
6 Replies
2. Shell Programming and Scripting
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)
Discussion started by: Tushar Bendale
17 Replies
3. Shell Programming and Scripting
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)
Discussion started by: villebonnais
3 Replies
4. Shell Programming and Scripting
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)
Discussion started by: villebonnais
3 Replies
5. 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
6. Shell Programming and Scripting
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)
Discussion started by: awk-admirer
2 Replies
7. Shell Programming and Scripting
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)
Discussion started by: giankan
6 Replies
8. Linux
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)
Discussion started by: dhruuv369
3 Replies
9. 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
10. Shell Programming and Scripting
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 DEBIAN
gr_plot_char
GR_PLOT_CHAR(1) User Commands GR_PLOT_CHAR(1)
NAME
gr_plot_char - plot samples versus time for byte/char data
SYNOPSIS
gr_plot_char: [options] input_filenames
DESCRIPTION
Takes a GNU Radio byte/char binary file and displays the samples versus time. You can set the block size to specify how many points to
read in at a time and the start position in the file. By default, the system assumes a sample rate of 1, so in time, each sample is plotted
versus the sample number. To set a true time axis, set the sample rate (-R or --sample-rate) to the sample rate used when capturing the
samples.
OPTIONS
-h, --help
show this help message and exit
-B BLOCK, --block=BLOCK
Specify the block size [default=1000]
-s START, --start=START
Specify where to start in the file [default=0]
-R SAMPLE_RATE, --sample-rate=SAMPLE_RATE
Set the sampler rate of the data [default=1.0]
SEE ALSO
gr_plot_char(1) gr_plot_const(1) gr_plot_fft_c(1) gr_plot_fft_f(1) gr_plot_float(1) gr_plot_int(1) gr_plot_iq(1) gr_plot_psd_c(1)
gr_plot_psd_f(1) gr_plot_qt(1) gr_plot_short(1)
gr_plot_char 3.5 December 2011 GR_PLOT_CHAR(1)