Insert row into empty file...how?

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

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.*"...

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

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

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

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

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

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

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?

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

LEARN ABOUT PHP

db2_last_insert_id

DB2_LAST_INSERT_ID(3)							 1						     DB2_LAST_INSERT_ID(3)

db2_last_insert_id - Returns the auto generated ID of the last insert query that successfully executed on this connection

SYNOPSIS

       string db2_last_insert_id (resource  $resource)

DESCRIPTION

	Returns the auto generated ID of the last insert query that successfully executed on this connection.

	The result of this function is not affected by any of the following:

	      o A single row INSERT statement with a VALUES clause for a table without an identity column.

	      o A multiple row INSERT statement with a VALUES clause.

	      o An INSERT statement with a fullselect.

	      o A ROLLBACK TO SAVEPOINT statement.

PARAMETERS

	      o $resource
		-  A  valid connection resource as returned from db2_connect(3) or db2_pconnect(3). The value of this parameter cannot be a state-
		ment resource or result set resource.

RETURN VALUES

	Returns the auto generated ID of last insert query that successfully executed on this connection.

EXAMPLES

       Example #1

	      A db2_last_insert_id(3) example

	       The following example shows how to return the auto generated ID of last insert query that successfully executed on this connection.

	      <?php

	      $database = "SAMPLE";
	      $user = "db2inst1";
	      $password = "ibmdb2";

	      $conn = db2_connect($database, $user, $password);
	      if($conn) {
		  $createTable = "CREATE TABLE lastInsertID
		    (id integer GENERATED BY DEFAULT AS IDENTITY, name varchar(20))";
		  $insertTable = "INSERT INTO lastInsertID (name) VALUES ('Temp Name')";

		  $stmt = @db2_exec($conn, $createTable);

		  /* Checking for single row inserted. */
		  $stmt = db2_exec($conn, $insertTable);
		  $ret =  db2_last_insert_id($conn);
		  if($ret) {
		      echo "Last Insert ID is : " . $ret . "
";
		  } else {
		      echo "No Last insert ID.
";
		  }

		  db2_close($conn);
	      }
	      else {
		  echo "Connection failed.";
	      }
	      ?>

	      The above example will output:

	      Last Insert ID is : 1

PHP Documentation Group 												     DB2_LAST_INSERT_ID(3)

UNIX for Dummies Questions & Answers