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 302898117 by jimmyf on Saturday 19th of April 2014 01:05:23 PM
Old 04-19-2014
Thank you kindly, Don. Left you a private message, when you get a moment, please respond? Thanks again!

---------- Post updated 04-19-14 at 01:05 PM ---------- Previous update was 04-18-14 at 06:42 PM ----------

This script it working only I would like to get the text vertically instead of horizontally.
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

So that the replaced text was like this:
Code:
this is a two-line replacement file

instead of this:
Code:
this is a two-line replacement file

Last edited by Don Cragun; 04-19-2014 at 03:23 PM.. Reason: Fix nested CODE tags.
 

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

rec2csv

REC2CSV(1)							   User Commands							REC2CSV(1)

NAME

       rec2csv - rec to csv converter

SYNOPSIS

       rec2csv [OPTIONS]... [REC_FILE]

DESCRIPTION

       Convert rec data into csv data.

       -t, --type=TYPE
	      record set to convert to csv; if this parameter is omitted then the default record set is used

       -S, --sort=FIELD
	      sort the output by the specified field.

       --help print a help message and exit.

       --version
	      show version and exit.

AUTHOR

       Written by Jose E. Marchesi.

REPORTING BUGS

       Report bugs to: bug-recutils@gnu.org
       GNU recutils home page: <http://www.gnu.org/software/recutils/>
       General help using GNU software: <http://www.gnu.org/gethelp/>

COPYRIGHT

       Copyright (C) 2010, 2011, 2012 Jose E. Marchesi.  License GPLv3+: GNU GPL version 3 or later <http://gnu.org/licenses/gpl.html>.
       This is free software: you are free to change and redistribute it.  There is NO WARRANTY, to the extent permitted by law.

SEE ALSO

       The  full  documentation  for  rec2csv  is maintained as a Texinfo manual.  If the info and rec2csv programs are properly installed at your
       site, the command

	      info rec2csv

       should give you access to the complete manual.

rec2csv 1.4.93							   January 2012 							REC2CSV(1)
All times are GMT -4. The time now is 09:45 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy