Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Joining multi-line output to a single line in a group
Top Forums Shell Programming and Scripting Joining multi-line output to a single line in a group Post 302605246 by balajesuri on Wednesday 7th of March 2012 04:16:12 AM
Old 03-07-2012
Code:
#! /usr/bin/perl -w
use strict;

my @ins   = qw ( a    a    b    b    b    );
my @trans = qw ( lkp1 lkp1 lkp1 lkp2 lkp2 );
my @value = qw ( x    y    a    x    y    );
my %x;
my $prev = "";

for (0..$#ins) {
    if ($prev eq "$ins[$_] $trans[$_]") {
        print "$value[$_]";
    }
    else {
        print "\n$ins[$_] $trans[$_] $value[$_]";
        $prev = "$ins[$_] $trans[$_]";
    }    
}

This User Gave Thanks to balajesuri For This Post:
gvk25
 

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Joining lines to single line in VI

Dear friends, In VI, I have these data shown below: Line1 Line2 Line3 Line4 How can I JOIN these line to the first line? When I finished I should have: Line1 Line2 Line3 Line4 is there a text length limit of how long a single line can be in VI? Thank you much! (10 Replies)
Discussion started by: bobo
10 Replies

2. Shell Programming and Scripting

Multi-line output to single line

Hello, How can I take the following output: outputa outputb outputc and turn it into single line ouput, with a single space between each field like below: outputa outputb outputc (7 Replies)
Discussion started by: LinuxRacr
7 Replies

3. Shell Programming and Scripting

awk help required to group output and print a part of group line and original line

Hi, Need awk help to group and print lines to format the output as shown below INPUT FORMAT set echo on set heading on set spool on /* SCHEMA1 */ CREATE TABLE T1; /* SCHEMA1 */ CREATE TABLE T2; /* SCHEMA1 */ CREATE TABLE T3; /* SCHEMA1 */ CREATE TABLE T4; /* SCHEMA1 */ CREATE TABLE T5;... (5 Replies)
Discussion started by: rajan_san
5 Replies

4. Shell Programming and Scripting

How to use Perl to merge multi-line into single line

Hi, Can anyone know how to use perl to merge the following multi-line information which beginning with "BAM" into one line. For each line need to delete the return and add a space. Please see the red color line. ******Org. Multi-line) BAM admin 101.203.57.22 ... (3 Replies)
Discussion started by: happyday
3 Replies

5. Shell Programming and Scripting

How to use Perl to join multi-line into single line

Hello, Did anyone know how to write a perl script to merge the multi-line into a single line where each line with start at timestamp Input--> timestamp=2009-11-10-04.55.20.829347; a; b; c; timestamp=2009-11-10-04.55.20.829347; aa; bb; cc; (5 Replies)
Discussion started by: happyday
5 Replies

6. Shell Programming and Scripting

Merge multi-line output into a single line

Hello I did do a search and the past threads doesn't really solve my issue. (using various awk commands) I need to combine the output from java -version into 1 line, but I am having difficulties. When you exec java -version, you get: java version "1.5.0_06" Java(TM) 2 Runtime... (5 Replies)
Discussion started by: flagman5
5 Replies

7. Shell Programming and Scripting

joining multi-line file into single lines

Hi, I have a file like mentioned below..For each specific id starting with > I want to join the sequence in multiple lines to a single line..Is there a simple way in awk or sed to do this >ENST00000558922 cdna:KNOWN TCCAGGATCCAGCCTCCCGATCACCGCGCTAGTCCTCGCCCTGCCTGGGCTTCCCCAGAG... (2 Replies)
Discussion started by: Diya123
2 Replies

8. UNIX for Dummies Questions & Answers

Remove multi line and single line comments

Hi, I am trying to remove multi line and single line comments like examples below I have tried this pattern. it works fine for single line comments and multi line comments in a single line only. but this fails when the comments are extended in multiple lines as shown in the comment 2 of... (3 Replies)
Discussion started by: ahmedwaseem2000
3 Replies

9. Shell Programming and Scripting

Help with reformat single-line multi-fasta into multi-line multi-fasta

Input File: >Seq1 ASDADAFASFASFADGSDGFSDFSDFSDFSDFSDFSDFSDFSDFSDFSDFSD >Seq2 SDASDAQEQWEQeqAdfaasd >Seq3 ASDSALGHIUDFJANCAGPATHLACJHPAUTYNJKG ...... Desired Output File >Seq1 ASDADAFASF ASFADGSDGF SDFSDFSDFS DFSDFSDFSD FSDFSDFSDF SD >Seq2 (4 Replies)
Discussion started by: patrick87
4 Replies

10. Shell Programming and Scripting

Multi line log files to single line format

I want to read the log file which was generate from other command . And the output was having multi line in log files for job name and server name. But i need to make all the logs on one line Source file 07/15/2018 17:02:00 TRANSLOG_1700 Server0005_SQL ... (2 Replies)
Discussion started by: ranjancom2000
2 Replies

LEARN ABOUT DEBIAN

dbix::searchbuilder::handle::oracle

DBIx::SearchBuilder::Handle::Oracle(3pm)		User Contributed Perl Documentation		  DBIx::SearchBuilder::Handle::Oracle(3pm)

NAME

	 DBIx::SearchBuilder::Handle::Oracle - An oracle specific Handle object

SYNOPSIS

DESCRIPTION

       This module provides a subclass of DBIx::SearchBuilder::Handle that compensates for some of the idiosyncrasies of Oracle.

METHODS

   Connect PARAMHASH: Driver, Database, Host, User, Password
       Takes a paramhash and connects to your DBI datasource.

   BuildDSN
       Customized version of "BuildDSN" in DBIx::SearchBuilder::Handle method.

       Takes additional argument SID. Database argument used unless SID provided.  Two forms of DSN are generated depending on whether Host
       defined or not:

	   dbi:Oracle:sid=<SID>;host=...[;port=...]
	   dbi:Oracle:<SID>

       Read details in documentation for DBD::Oracle module.

   Insert
       Takes a table name as the first argument and assumes that the rest of the arguments are an array of key-value pairs to be inserted.

   InsertFromSelect
       Customization of "InsertFromSelect" in DBIx::SearchBuilder::Handle.

       Unlike other DBs Oracle needs:

       o   id generated from sequences for every new record.

       o   query wrapping in parens.

       NOTE that on Oracle there is a limitation on the query. Every column in the result should have unique name or alias, for example the
       following query would generate "ORA-00918: column ambiguously defined" error:

	   SELECT g.id, u.id FROM ...

       Solve with aliases:

	   SELECT g.id AS group_id, u.id AS user_id FROM ...

   KnowsBLOBs
       Returns 1 if the current database supports inserts of BLOBs automatically.  Returns undef if the current database must be informed of BLOBs
       for inserts.

   BLOBParams FIELD_NAME FIELD_TYPE
       Returns a hash ref for the bind_param call to identify BLOB types used by the current database for a particular column type.  The current
       Oracle implementation only supports ORA_CLOB types(112).

   ApplyLimits STATEMENTREF ROWS_PER_PAGE FIRST_ROW
       takes an SQL SELECT statement and massages it to return ROWS_PER_PAGE starting with FIRST_ROW;

   DistinctQuery STATEMENTREF
       takes an incomplete SQL SELECT statement and massages it to return a DISTINCT result set.

   BinarySafeBLOBs
       Return undef, as Oracle doesn't support binary-safe CLOBS

   DatabaseVersion
       Returns value of ORA_OCI constant, see "Constants" in DBI.

   SimpleDateTimeFunctions
       Returns hash reference with specific date time functions of this database for "DateTimeFunction" in DBIx::SearchBuilder::Handle.

   ConvertTimezoneFunction
       Custom implementation of "ConvertTimezoneFunction" in DBIx::SearchBuilder::Handle.

       Use the following query to get list of timezones:

	   SELECT tzname FROM v$timezone_names;

       Read Oracle's docs about timezone files:

	   http://download.oracle.com/docs/cd/B14117_01/server.101/b10749/ch4datetime.htm#i1006667

AUTHOR

       Jesse Vincent, jesse@fsck.com

SEE ALSO

       perl(1), DBIx::SearchBuilder

perl v5.14.2							    2011-09-21				  DBIx::SearchBuilder::Handle::Oracle(3pm)
All times are GMT -4. The time now is 04:16 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy