Trying To Write File Contents To Specfic .csv Cell

04-18-2014

Registered User

114, 2

Join Date: Oct 2012

Last Activity: 26 April 2020, 9:12 PM EDT

Posts: 114

Thanks Given: 57

Thanked 2 Times in 1 Post

Trying To Write File Contents To Specfic .csv Cell

Hi,
I'm attempting to write the entire contents of a file to a specific .csv cell. So far have only a nawk one liner that will write a value into a specific .csv cell. Trying to use man page but can't seem to get any farther. Any help would be appreciated.

Code:

nawk -v r=2 -v c=3 -v val=5 -F, 'BEGIN{OFS=","}; NR != r; NR == r {$c = val; print}'

val=5 works but want to write the entire contents of a file to a cell. Hope this question makes sense. Thanks.

jimmyf

View Public Profile for jimmyf

Find all posts by jimmyf

04-18-2014

Registered User

12,315, 4,560

Join Date: Jul 2012

Last Activity: 22 November 2019, 4:29 PM EST

Location: San Jose, CA, USA

Posts: 12,315

Thanks Given: 952

Thanked 4,560 Times in 3,818 Posts

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?

Don Cragun

View Public Profile for Don Cragun

Find all posts by Don Cragun

04-18-2014

Registered User

1,709, 666

Join Date: Jan 2013

Last Activity: 20 May 2020, 1:43 PM EDT

Location: Loughborough

Posts: 1,709

Thanks Given: 838

Thanked 666 Times in 467 Posts

Assuming CSV means Character Separated Variable , NOT, Comma Separated Variable...

Quote:

I'm attempting to write the entire contents of a file to a specific .csv cell.

Some questions.
1) What is the character limit of a cell, assuming there is one?
2) Is the file greater than this limit?
3) Does the file contain any binary?
4) Does the file contain characters the same as the cell field separators?
Or are we to assume a flat alpha-numeric text file only?

wisecracker

View Public Profile for wisecracker

Find all posts by wisecracker

04-18-2014

Registered User

114, 2

Join Date: Oct 2012

Last Activity: 26 April 2020, 9:12 PM EDT

Posts: 114

Thanks Given: 57

Thanked 2 Times in 1 Post

Don, the script is returning an error.

Code:

awk: syntax error near line 1
awk: bailing out near line 1

---------- Post updated at 04:55 PM ---------- Previous update was at 04:52 PM ----------

hey wisecracker, not aware of character limit, file is normal text, no character the same as field separators. Thank you.

jimmyf

View Public Profile for jimmyf

Find all posts by jimmyf

04-18-2014

Registered User

12,315, 4,560

Join Date: Jul 2012

Last Activity: 22 November 2019, 4:29 PM EST

Location: San Jose, CA, USA

Posts: 12,315

Thanks Given: 952

Thanked 4,560 Times in 3,818 Posts

Quote:

Originally Posted by jimmyf

Don, the script is returning an error.

Code:

awk: syntax error near line 1
awk: bailing out near line 1

Sorry. Since you're using a Solaris system change awk in my script to /usr/xpg4/bin/awk, /usr/xpg6/bin/awk, or nawk.

This User Gave Thanks to Don Cragun For This Post:

Don Cragun

View Public Profile for Don Cragun

Find all posts by Don Cragun

04-19-2014

Registered User

114, 2

Join Date: Oct 2012

Last Activity: 26 April 2020, 9:12 PM EDT

Posts: 114

Thanks Given: 57

Thanked 2 Times in 1 Post

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.

jimmyf

View Public Profile for jimmyf

Find all posts by jimmyf

04-20-2014

Registered User

12,315, 4,560

Join Date: Jul 2012

Last Activity: 22 November 2019, 4:29 PM EST

Location: San Jose, CA, USA

Posts: 12,315

Thanks Given: 952

Thanked 4,560 Times in 3,818 Posts

Quote:

Originally Posted by jimmyf

Thank you kindly, Don. Left you a private message, when you get a moment, please respond? Thanks again!

Please don't use private messages to ask for help. Use the public forums. If you search for awk book or sed book you will find that your question has been asked and answered many times before.

Quote:

Originally Posted by jimmyf

---------- 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

If you collapsed the awk script I supplied to a single line (without adding some semicolons), I'm very surprised that it still worked at all.

Quote:

Originally Posted by jimmyf

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

I don't see any difference in the above two output segments. If you mean that you want the <newline> characters separating lines in the replacement text file to be included in the output, you won't have a valid CSV file unless you quote the <newline>s. With the input files I used before, and the following code:

Code:

/usr/xpg4/bin/awk -v r=2 -v c=3 '
BEGIN {	FS = OFS = ","
}
FNR == NR {
	val = sprintf("%s%s%s", val, NR > 1 ? "\n" : "", $0)
	next
}
FNR == r {
	$c = "\"" val "\""
}
1' rep csv

the output produced is:

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 wanted?

In the future, please supply sample input and sample output so we can see what you're trying to do.

These 2 Users Gave Thanks to Don Cragun For This Post:

Don Cragun

View Public Profile for Don Cragun

Find all posts by Don Cragun

UNIX for Dummies Questions & Answers

Trying To Write File Contents To Specfic .csv Cell

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

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

Discussion started by: Litu19

2. UNIX for Dummies Questions & Answers

Write terminal contents into a one file in UNIX

Discussion started by: kiran425

3. Shell Programming and Scripting

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

Discussion started by: dhruuv369

4. Shell Programming and Scripting

Write array contents to file

Discussion started by: Filter500

5. Shell Programming and Scripting

Extract last cell of csv file

Discussion started by: locoroco

6. Shell Programming and Scripting

Store table contents in csv file

Discussion started by: ladyAnne

7. UNIX for Advanced & Expert Users

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

Discussion started by: Prashant Jain

8. Shell Programming and Scripting

How to edit particular cell of csv file using shell script

Discussion started by: deepak_p86

9. Shell Programming and Scripting

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

Discussion started by: chinnahyd

10. Programming

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

Discussion started by: namrata5