Insert row into empty file...how?


 
Thread Tools Search this Thread
Top Forums UNIX for Dummies Questions & Answers Insert row into empty file...how?
# 1  
Old 12-12-2013
Insert row into empty file...how?

Greetings:

I generate an empty flat file just fine when there's no data returned from my process, as the customer wants one always (using the 1st line of the below script). However, they also want at least the column names in this flat file (row 1, the only row to be in the emply file). I'm attempting to use the sed "i" for inserting a new row with 3 column names in a single text string.

I'm not sure of the syntax for inserting a new row into an already empty file; it is even possible?

Thanks for any advice & guidance.

Code:
touch /TgtFiles/Test_File.csv;
sed ' i\ TransDate,Amount,AuthorizationNumber' /TgtFiles/Test_File.csv


Last edited by bartus11; 12-12-2013 at 02:43 PM.. Reason: Please use code tags
# 2  
Old 12-12-2013
You can simply "echo" the line you want to have there:
Code:
echo "TransDate,Amount,AuthorizationNumber" >> /TgtFiles/Test_File.csv

This User Gave Thanks to bartus11 For This Post:
# 3  
Old 12-12-2013
bartus11:

Yes, your solution worked fine...thank you so much. (I'll use tags around script in any future posts).
# 4  
Old 12-12-2013
Also I would suggest to check if the file is empty. If yes, then write to it:
Code:
#!/bin/ksh

[ ! -s /TgtFiles/Test_File.csv ] && print "TransDate,Amount,AuthorizationNumber" > /TgtFiles/Test_File.csv

# 5  
Old 12-12-2013
Ok Yoda, that is a good idea but then is your script above inplace of using the echo command?
# 6  
Old 12-12-2013
You can use echo instead.
This User Gave Thanks to Yoda For This Post:
# 7  
Old 12-12-2013
Yoda, good solution you provide. My universe is again in balance. Smilie

Last edited by Benrosa; 12-12-2013 at 06:00 PM.. Reason: Added more text.
 
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Insert a value between two empty delimiter in the file.

Would like to insert value between two empty delimiter and at the very last too if empty. $ cat customerleft.tbl 300|Customer#000000300|I0fJfo60DRqQ|7|17-165-193-5964|8084.92|\N|p fluffily among the slyly express grouches. furiously express instruct||||||||||||||||||||||||\N... (3 Replies)
Discussion started by: Mannu2525
3 Replies

2. Shell Programming and Scripting

Insert newline when grep result is empty

Given a csv file with 40 columns with name, address, hometown etc. I use a bash command in 1 line which: 1. gets the address column and pipes that to 2. grep the first digit and everything that follows Command: awk -F ";" '{print $19}' /Users/jb/Desktop/ReorderTempTotal.csv | grep -o "\d.*"... (7 Replies)
Discussion started by: JBVeenstra
7 Replies

3. Shell Programming and Scripting

Insert empty columns inside a pipe delimited file

Hi All , I have pipe delimiter file with 11 columns . I need to insert 4 empty columns after column 10 . and After 11 column I need to insert a column which is having the same value for all the rows . My file 1|2|3|4|5|6|7|8|9|10|11 New file ... (11 Replies)
Discussion started by: Hypesslearner
11 Replies

4. Shell Programming and Scripting

Insert empty columns in a flat file

Hi, I have a tab delimited flat file, for example shown below Name Desg Loc a b c d e fI want to insert an empty column inbetween the column Desc and Loc, the result should be like shown below: Name LName Desg Loc a b c d e ... (6 Replies)
Discussion started by: sampoorna
6 Replies

5. Shell Programming and Scripting

sed - insert text if column empty

Hi, I want to insert the text 'Unknown' in 2 specific columns in a csv file (actually | separated) if the column is blank. Its always the same columns. I have tried using sed: sed "s/||/|Unknown|/g" but there are occasion where other fields are blank and they need to be left blank. This... (4 Replies)
Discussion started by: ksexton
4 Replies

6. Shell Programming and Scripting

insert text into empty file

I have an awk script to extract data from several files and create output in the following format as a csv file: xxxx 01/04/12 0001 0 When data is present, I have a file. When no data is available in the input files, I would still like to create a file that looks like this: xxxx... (1 Reply)
Discussion started by: banjo25
1 Replies

7. Shell Programming and Scripting

split row into lines and insert file name

I have a directory with several hundred files. The file format is a space delimited row with an unknown number of columns: A B C D E F G ... I need to turn this format File1 A File1 B File2 A File3 A File3 B File3 C ... I can use grep to display the filename next to each row of... (2 Replies)
Discussion started by: newreverie
2 Replies

8. Shell Programming and Scripting

How To Erase a line is a row is empty?

Hi! i've been reading you guys for some time, now there is something I couldn't find here, I'm trying to purge some data for my thesis but my measurements have some gaps in the third columns. The solution is simple, -Erase those lines where the third column is empty ¿How? example... (1 Reply)
Discussion started by: AriasFco
1 Replies

9. Shell Programming and Scripting

Sed insert text at first line of empty file

I can't seem to get sed to allow me to insert text in the first line of an empty file. I have a file.txt that is a 0 byte file. I want sed to insert " fooBar" onto the first line. I've tried a few options and nothing seems to work. They work just fine if there's text in the file tho. Help? (4 Replies)
Discussion started by: DC Slick
4 Replies

10. Shell Programming and Scripting

How to insert data befor some field in a row of data depending up on values in row

Hi I need to do some thing like "find and insert before that " in a file which contains many records. This will be clear with the following example. The original data record should be some thing like this 60119827 RTMS_LOCATION_CDR INSTANT_POSITION_QUERY 1236574686123083rtmssrv7 ... (8 Replies)
Discussion started by: aemunathan
8 Replies
Login or Register to Ask a Question