How to insert alternative columns and sort text from first column to second?

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Insert Columns before the last Column based on the Count of Delimiters

Hi, I have a requirement where in I need to insert delimiters before the last column of the total delimiters is less than a specified number. Say if the delimiters is less than 139, I need to insert 2 columns ( with blanks) before the last field awk -F '�' '{ if (NF-1 < 139)} END { "Insert 2...

2. Shell Programming and Scripting

Seperated by columns, merge in a file, sort them on common column

Hi All, I have 4 files in below format. I took them as an example. File 1: Cut from position 1-4 then 6-7 then 8-14 then rest left and make them as columns in one new file. Inserting character H to the initial of all line like HCTOT. CTOT 456787897 Low fever CTOR 556712345 High fever...

3. Shell Programming and Scripting

How to sort a text file if certain columns are blank?

Dear all, I am trying to sort a text file based on column 3, 10, 11 and 12. But certain column are blank for some lines. Column 3 has to be in ascending order after sorting. Part of my input file is as follows: CN727990 1 A01 4703 5083 73.28 - A_scaffold000011 4365605 4365985 73.28 +...

4. Shell Programming and Scripting

Insert space in specific column among many columns

Hello, I have some problem in inserting the space for the pairs of columns. I have the input file : I used this code below in replacing it using space in specific column (replace space in each two columns) sed -e "s/,/ /2" -e "s/,/ /3" inputfile Output showed : However, I have many...

5. Shell Programming and Scripting

Insert text into specific column

I have the following data: Dec 24 11:31:10 0000008b 9911662486 Answered Price SGD 0.003 PERIOD: 0 m 6 s Dec 24 11:21:42 00000086 9911662486 Answered Price SGD 0.001 PERIOD: 0 m 2 s Dec 20 15:34:28 00000004 9911662486 Answered Price SGD 0.007 PERIOD: 0 m 12 s Dec 20 18:42:30 0000017b...

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

7. UNIX for Dummies Questions & Answers

Sort text file starting at column X

Hello everyone! As the heading reads, I would like to sort the lines of a text file, starting at a specific column (i.e. skip the first X characters of each line). What I’m actually trying to sort is the md5 sums file of a directory. Every time I copy a new file to that directory, I perform...

8. Shell Programming and Scripting

sort each column of text file alone

Hello , i have a text file like this 1 a1 ,AB ,AC ;AD ,EE 2 a2 ,WE ;TR ,YT ,WW 3 a3 ;AS ,UY ;RF ,YT i want to sort this text file based on each row , and excluding 2nd column from the sorting and not taking the comma or ; into consideration in the sorting, so it will become like this...

9. UNIX for Dummies Questions & Answers

Insert text in datafile with uneven columns

Dear Unix Gurus, I have a dataset consisting of a number of uneven columns. What I would like to do is fill up the missing rows with an arbitrary text of fixed value so that all columns now have an equal number of rows. for example, in the sample datafile below... 1.0 1.3 0.25 2.2 2.0...

10. Shell Programming and Scripting

insert text into column

Hello! I have a text file containing some text : : : bla other text : : : bla any text : : : bla containing 3 columns separated by the ':' sign. Now i want to insert 'this' in the 2nd line after the 2nd column-deliminiter (i.e. into 3rd column), like some text : : : bla other text :...

LEARN ABOUT DEBIAN

alzabo::runtime::inserthandle

Alzabo::Runtime::InsertHandle(3pm)			User Contributed Perl Documentation			Alzabo::Runtime::InsertHandle(3pm)

NAME

       Alzabo::Runtime::InsertHandle - A handle representing an insert

SYNOPSIS

	my $handle =
	    $table->insert_handle
		( columns => [ $table->columns( 'name', 'job' ) ] );

	my $faye_row =
	    $handle->insert( values =>
			     { name => 'Faye',
			       job => 'HK Pop Chanteuse' } );

	my $guesch_row =
	    $handle->insert( values =>
			     { name => 'Guesch',
			       job => 'French Chanteuse and Dancer' } );

DESCRIPTION

       This object is analogous to a DBI statement handle, and can be used to insert multiple rows into a table more efficiently than repeatedly
       calling "Alzabo::Runtime::Table->insert()".

METHODS

       Objects of this class provide one public method:

       insert

       This method is used to insert a new row into a table.

       It accepts the following parameters:

       * values
	   This should be a hash reference containing the values to be inserted into the table.

	   If no value is given for a primary key column and the column is "sequenced" then the primary key will be auto-generated.

	   If values are not provided for other columns which were given when "Alzabo::Runtime::Table->insert_handle" was called, this method
	   first checks to see if a value was provided for the column when "Alzabo::Runtime::Table->insert_handle" was called.	If none was pro-
	   vided, then the column's default value is used.

	   If column values were passed to "Alzabo::Runtime::Table->insert_handle", then these can be overridden by values passed to this method.

	   It is not possible to override column values that were given as SQL functions when "Alzabo::Runtime::Table->insert_handle" was called.

       This method returns a new "Alzabo::Runtime::Row" object.

       Throws: "Alzabo::Exception::Logic", "Alzabo::Exception::Params"

perl v5.8.8							    2007-12-23					Alzabo::Runtime::InsertHandle(3pm)

UNIX for Dummies Questions & Answers