Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: [Perl] Split lines into array - variable line items - variable no of lines.
Top Forums Shell Programming and Scripting [Perl] Split lines into array - variable line items - variable no of lines. Post 302559519 by ejdv on Tuesday 27th of September 2011 09:42:45 AM
Old 09-27-2011
[Perl] Split lines into array - variable line items - variable no of lines.
Hi,

I have the following lines that I would like to see in an array for easy comparisons and printing:

Example 1:

Code:
field1,field2,field3,field4,field5
value1,value2,value3,value4,value5

Example 2:

Code:
field1,field3,field4,field2,field5,field6,field7
value1,value3,value4,value2,value5,value6,field7
value1,value3,value4,value2,value5,value6,field7
value1,value3,value4,value2,value5,value6,field7

So, the number of lines, the number of fields and the field order can differ.

As output I would like to see:

Code:
field2,field3,field5
value2,value3,value5

Code:
field2,field3,field5
value2,value3,value5
value2,value3,value5
value2,value3,value5

Those to be printed fields and values are always present, independent from the number of fields and the field order.
And field1 and value1 are always on the first place.
The background is that has to run on different systems and those different systems will deliver different field numbers and field order.

I started with something like this, but got stuck somehow due to a lack of Perl knowledge.
Would it have been a more static input then I it would be a bit more easier.

Code:
my @LineItems;
my $LineItems;
my $FieldValue;
my $i;
my $NumItems;
my $LineCount;

open GETLINES, "cat /tmp/lines.txt |");
$LineCount = 0;
while ( $Line = <GETLINES> ) {
  if ( $Line =~ /^Field1,/ ) {
    $LineCount++;
    @LineItems = split (/,/, $Line);
    $NumItems = @LineItems;
    for ( $i = 1; $i < $NumItems; $i++ ) {
       $FieldValue{$i} = $LineItems[$i];
    }
  }
  if ( $Line =~ /^Value1,/ ) {
    $LineCount++;
    @LineItems = split (/,/, $Line);
    $NumItems = @LineItems;
    for ( $i = 1; $i < $NumItems; $i++ ) {
      $FieldValue{$i} = $LineItems[$i];
    }
  }
}

I would appreciate any kind of assistance.

ejdv
Last edited by Scott; 09-27-2011 at 10:54 AM.. Reason: Please use code tags for code
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

split variable values into array

i have these values inside variable $blah BUNGA TERATAI 3 5055 ITH 1 0 0 0 1 1 JADE TRADER 143W ITH 4 0 0 0 4 4 MOL SPLENDOR 0307A ITH 3 0 0 0 3 3 so how do I split them into array with the... (4 Replies)
Discussion started by: finalight
4 Replies

2. Shell Programming and Scripting

Join in a single line variable number of lines

Hi all, I have a file with little blocks beginning with a number 761XXXXXX, and 0, 1, 2 or 3 lines below of it beginning with STUS as follow: 761625820 STUS ACTIVE 16778294 STUS NOT ACTIVE 761157389 STUS ACTIVE 16778294 761554921 STUS ACTIVE 16778294 STUS NOT ACTIVE STUS ACTIVE OP... (4 Replies)
Discussion started by: cgkmal
4 Replies

3. Shell Programming and Scripting

split single line into two line or three lines

Dear All, I want to split single line into two line or three lines wherever “|” separated values comes using Input line test,DEMTEMPUT20100404010012,,,,,,,,|0070086|0070087, output shoule be test,DEMTEMPUT20100404010012,,,,,,,,0070086, test,DEMTEMPUT20100404010012,,,,,,,,0070087, (14 Replies)
Discussion started by: arvindng
14 Replies

4. Shell Programming and Scripting

Split line in to 3 lines

Hi, I have a file which contains 1000's of lines. Each line is a log which is pretty long. So i want to split the each line based on 3 category. 1> Date 2><REQUEST> 3><RESPONSE> So below is the example of a line. 2010-11-16 00:45:12,314<REQUEST><VALIDATION-ERROR><soapenv:Envelope... (16 Replies)
Discussion started by: raghunsi
16 Replies

5. Shell Programming and Scripting

Delete lines in an array Using perl

im having an array @check which contains text ..i want to open the array and i have to delete lines starting from a word called "check1" till "check2" for eg:- check1 Use descriptive titles when posting. For example, do not post questions with subjects like "Help Me!", "Urgent!!" or "Doubt".... (0 Replies)
Discussion started by: rajkrishna89
0 Replies

6. Shell Programming and Scripting

Need to remove first 6 lines and last line in a array ---- perl scripting

Hi I have stored a command output in an array like below @a = `xyz`; actually xyz comnad will give the output like this tracker date xxxxxxx xxxxxxx --------------------- 1 a 2 b ---------------------- i have stored the "xyz" output to an... (3 Replies)
Discussion started by: siva kumar
3 Replies

7. Shell Programming and Scripting

How to get lines having a variable in perl?

Hi, This might be simple question. But i couldn't find the answer. #$ra is having a value which i have got from some other file I want the first occurrence of the line having the value that is in variable "$ra" This is what i have tried. while ( $iop = <TST>) { if($iop =~ /$ra/) { ... (6 Replies)
Discussion started by: twistedpair
6 Replies

8. Shell Programming and Scripting

How do I split a single-line input into five lines?

Example input: John:Shepherd:770-767-4040:U.S.A:New York Mo Jo:Jo Jo: 666-666-6666:U.S.A:Townsville Expected Output: First Name: John Last Name: Shepherd Phone Number: 770-767-4040 Country: U.S.A State: New York First Name: Mo Jo Last Name: Jo Jo Phone Number: 666-666-6666... (10 Replies)
Discussion started by: Camrikron
10 Replies

9. Shell Programming and Scripting

Split a line into multiple lines based on delimeters

Hi, I need help to split any lines that contain ; or , input.txtAc020 Not a good chemical process AC030 many has failed, 3 still maintained AC040 Putative; epithelial cells AC050 Predicted binding activity AC060 rodC Putative; upregulated in 48;h biofilm vs planktonic The output... (8 Replies)
Discussion started by: redse171
8 Replies

10. Shell Programming and Scripting

Search for a pattern in a file and split the line into two lines

Hi All, Greetings everyone !!! I have a file which has many lines, out of which one line is as below. I need to search for pattern "varchar(30) Select" and if exists, then split the line as below. I am trying to achieve this in ksh. Can anyone help me on this. (8 Replies)
Discussion started by: Pradhikshan
8 Replies

LEARN ABOUT OPENSOLARIS

fmt

fmt(1)								   User Commands							    fmt(1)

NAME

       fmt - simple text formatters

SYNOPSIS

       fmt [-cs] [-w width | -width] [inputfile]...

DESCRIPTION

       fmt  is a simple text formatter that fills and joins lines  to produce output lines of (up to) the number of characters specified in the -w
       width option. The default  width is 72. fmt concatenates the inputfiles listed as arguments. If none are given, fmt formats text  from  the
       standard input.

       Blank lines are preserved in the output, as is the spacing between words. fmt does not fill nor split lines beginning with a `.' (dot), for
       compatibility with nroff(1). Nor does it fill or split a set of contiguous non-blank lines which is determined to be  a	mail  header,  the
       first line of which must begin with "From".

       Indentation is preserved in the output, and input lines with differing indentation are not joined (unless -c is used).

       fmt can also be used as an in-line text filter for vi(1). The  vi command:

       !}fmt

       reformats the text between the cursor location and the end of the paragraph.

OPTIONS

       -c		    Crown  margin  mode.  Preserve the indentation of the first two lines within a paragraph, and align the left margin of
			    each subsequent line with that of the second line. This is useful for tagged paragraphs.

       -s		    Split lines only. Do not join short lines to form longer ones. This prevents sample lines of code, and other such for-
			    matted text, from being unduly combined.

       -w width | -width    Fill output lines to up to	width columns.

OPERANDS

       inputfile    Input file.

ENVIRONMENT VARIABLES

       See environ(5) for a description of the LC_CTYPE environment variable that affects the execution of fmt.

ATTRIBUTES

       See attributes(5) for descriptions of the following attributes:

       +-----------------------------+-----------------------------+
       |      ATTRIBUTE TYPE	     |	    ATTRIBUTE VALUE	   |
       +-----------------------------+-----------------------------+
       |Availability		     |SUNWcsu			   |
       +-----------------------------+-----------------------------+

SEE ALSO

       nroff(1), vi(1), attributes(5), environ(5)

NOTES

       The -width option is acceptable for BSD compatibility, but it may go away in future releases.

SunOS 5.11							    9 May 1997								    fmt(1)
All times are GMT -4. The time now is 12:38 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy