Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Trying To Write File Contents To Specfic .csv Cell
Top Forums UNIX for Dummies Questions & Answers Trying To Write File Contents To Specfic .csv Cell Post 302898099 by Don Cragun on Friday 18th of April 2014 03:54:26 PM
Old 04-18-2014
Your description is a little bit ambiguous. Maybe this will help.

If the file rep contains:
Code:
this is a two-line
replacement file

and the file csv contains:
Code:
1.1,1.2,1.3,1.4,1.5
2.1,2.2,2.3,2.4,2.5
3.1,3.2,3.3,3.4,3.5

then the script:
Code:
awk -v r=2 -v c=3 '
BEGIN {	FS=OFS=","
}
FNR == NR {
	val = sprintf("%s%s%s", val, NR > 1 ? " " : "", $0)
	next
}
FNR == r {
	$c = val
}
1' rep csv

produces the output:
Code:
1.1,1.2,1.3,1.4,1.5
2.1,2.2,this is a two-line replacement file,2.4,2.5
3.1,3.2,3.3,3.4,3.5

Is this what you're trying to do?
 

10 More Discussions You Might Find Interesting

1. Programming

How to read and write directory or file contents in c++ ?

Dear Friends, I m beginner unix programmer. I want to know, how to read and write directory or file contents in c++ ? (3 Replies)
Discussion started by: namrata5
3 Replies

2. Shell Programming and Scripting

Need to compare two csv files values and write into another csv file

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

3. Shell Programming and Scripting

How to edit particular cell of csv file using shell script

I have one csv file and in that I want update particular cell. I know the row and coloumn number for that respective. Please help me... (6 Replies)
Discussion started by: deepak_p86
6 Replies

4. UNIX for Advanced & Expert Users

How to add two values in the same cell of CSV file

I need help to create a csv file with Unix command. In csv file, i need to put two values in the same cell. Rite now, whts happening is, if i put 2 values in the same cell, its comming as " asd, zxc" but i want it in different line but in same cell. asd zxc Please reply me ASAP. (1 Reply)
Discussion started by: Prashant Jain
1 Replies

5. Shell Programming and Scripting

Store table contents in csv file

I need to write a script to store the contents of a table in a csv file I'm using Toad, it's a Oracle database. (5 Replies)
Discussion started by: ladyAnne
5 Replies

6. Shell Programming and Scripting

Extract last cell of csv file

How do I extract the last cell in a column of a csv file using linux shell scripting? Or alternatively, how do I get the number of cells of a csv file? (2 Replies)
Discussion started by: locoroco
2 Replies

7. Shell Programming and Scripting

Write array contents to file

Hi, I have a bash script that currently holds some data. I am trying to write all the contents to a file called temp.txt. I am using echo ${array} > temp.txt The problem that I am experiencing is that the elements are being written horizontally in the file. I want them written... (5 Replies)
Discussion started by: Filter500
5 Replies

8. Shell Programming and Scripting

How to delete a column/columns of a CSV file which has cell values with a string enclosed in " , "?

How can I delete a column from a CSV file which has comma separated value with a string enclosed in double quotes and a comma in between? I have a file 44.csv with 4 lines including the header like the below format: column1, column2, column3, column 4, column5, column6 12,455,"string with... (6 Replies)
Discussion started by: dhruuv369
6 Replies

9. UNIX for Dummies Questions & Answers

Write terminal contents into a one file in UNIX

Hi guys, How to write terminal contents into a file in Unix operating system Actually I created GUI by using Gtk2-perl. I want to display data on GUI whatever the contents writing on terminal. So which command I have to use and where that command to be run I mean in shell script or Perl... (2 Replies)
Discussion started by: kiran425
2 Replies

10. Shell Programming and Scripting

How to delete a columns of a CSV file which has cell values with a string enclosed in " , "?

Hi How can I delete a columns from a CSV file which has comma separated value with a string enclosed in double quotes or square bracket and a comma in between? I have a csv file with below format. Template,Target Server,Target Component,Rule Group,Rule,Rule Reference Number,Rule... (7 Replies)
Discussion started by: Litu19
7 Replies

LEARN ABOUT DEBIAN

nifti_stats

NIFTI_STATS(1)							   User Commands						    NIFTI_STATS(1)

NAME

       nifti_stats - compute NIfTI statistical functions

SYNOPSIS

       nifti_stats [-q|-d|-1|-z] value CODE [p1 p2 p3]

DESCRIPTION

       nifti_stats  supports several distributions (normal, uniform, logistic, chi, etc.) and calculates density or cummulative distribution func-
       tion (and many more). Values are printed to stdout and can be piped to other tools.

       value can be a single number or in the form bot:top:step.
	      default ==> output p = Prob(statistic < val).

       -q     ==> output is 1-p.

       -d     ==> output is density.

       -1     ==> output is x such that Prob(statistic < x) = val.

       -z     ==> output is z such that Normal cdf(z) = p(val).

       -h     ==> output is z such that 1/2-Normal cdf(z) = p(val).

       Allowable CODEs:

       CORREL, TTEST, FTEST, ZSCORE, CHISQ, BETA, BINOM, GAMMA, POISSON, NORMAL, FTEST_NONC, CHISQ_NONC, LOGISTIC, LAPLACE,  UNIFORM,  TTEST_NONC,
       WEIBULL, CHI, INVGAUSS, EXTVAL, PVAL, LOGPVAL and LOG10PVAL

	      Following CODE are distributional parameters, as needed.

       Results are written to stdout, 1 number per output line.

EXAMPLE

       Piping output into AFNI program 1dplot:

	      nifti_stats -d 0:4:.001 INVGAUSS 1 3 | 1dplot -dx 0.001 -stdin

SEE ALSO

       libnifti(1), nifti_tool(1), nifti1_test(1).

       Homepage: http://niftilib.sourceforge.net

AUTHOR

       RW Cox - SSCC/NIMH/NIH/DHHS/USA/EARTH - March 2004

       This manual page was written by Michael Hanke <michael.hanke@gmail.com>, for the Debian project (but may be used by others).

nifti_stats							  September 2007						    NIFTI_STATS(1)
All times are GMT -4. The time now is 11:38 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy