Aligning columns in a text file using Perl Post: 302620357

Sponsored Content

Top Forums Shell Programming and Scripting Aligning columns in a text file using Perl Post 302620357 by pravin27 on Sunday 8th of April 2012 02:40:34 AM

04-08-2012

Registered User

How about this ?

Code:

 
#!/usr/bin/perl
$col1_limit=15;
$col2_limit=30;
$j=0;
while (<DATA>) {
        chomp;
        ($title,$desc)=split;
        if (length($title) <=15) { printf "%-${col1_limit}s | %-${col2_limit}s\n",$title,$desc;next}
        for($i=1;$i<=((length($title))/$col1_limit);$i++){
                printf "%-${col1_limit}s | %-${col2_limit}s\n",substr($title,$j,$col1_limit),$desc if ($i==1);
                printf "%-${col1_limit}s\n",substr($title,$j,$col1_limit);
                $j+=$col1_limit;
        }
        if (length($title) > $j) {printf "%-${col1_limit}s\n",substr($title,$j);}
        $j=0;

}
__DATA__
value1                                                            Updated this row
value1                                                            Updated this row also
value1                                                            Updated again
value1                                                            Changed table contents
value-value-value-value-value2                                  added few lines of code
value-value-value-value-value2---                                  added another few lines using perl
ABCDEFGH                                                updated code to add few lines
TESTING                                              added new testing procedure
TESTING AGAIN                                                  Updated General info
ABCDEFG TESTING, AGAIN AND AGAIN                                      Updated information
ABCDEFG TESTING, AGAIN AND AGAIN                                      Updated home address

This User Gave Thanks to pravin27 For This Post:

pravin27

View Public Profile for pravin27

Find all posts by pravin27

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

How to convert text to columns in tab delimited text file

Hello Gurus, I have a text file containing nearly 12,000 tab delimited characters with 4000 rows. If the file size is small, excel can convert the text into coloumns. However, the file that I have is very big. Can some body help me in solving this problem? The input file example, ...

2. Shell Programming and Scripting

Aligning text files by max field length

Hello, Is there anyway that I can align a pipe delimited text file by the maxium field length where the field is separated out by pipes for large text files with more than 100,000 rows? So, far I have searched other forums and google about aligning text files in unix and I have noticed that...

3. Shell Programming and Scripting

Aligning numbers in the second file based on first file

Hi All, I have two sets of files with names .dat and .txt. The number of files is really large more than 90000. The files have names like 1.dat, 2.dat,3.dat and so on where as txt files have names like 1.txt, 2.txt, 3.txt and so on The DAT and TXT files are equal in number. About 90000 each ...

4. UNIX for Dummies Questions & Answers

Removing columns from a text file that do not have any values in second and third columns

I have a text file that has three columns. But at the end of the text file, there are trailing lines that have missing second and third columns: 4 0.04972604 KLHL28 4 0.0497332 CSTB 4 0.04979822 AIF1 4 0.04983331 DECR2 4 0.04990344 KATNB1 4 4 4 4 How can I remove the trailing...

5. UNIX for Dummies Questions & Answers

Perl - adding columns to file

I have a file in which I need to add more columns to based on a key in the first file: File1 key1,abc,123, key2,def,456, key3,ghi,789, File2 key2,zyx,111,qqq, key3,yuu,222,www, key1,pui,333,eee, key4,xxx,999,rrr, I would like to create the following output: Output

6. UNIX for Dummies Questions & Answers

Help with Aligning the content of a txt file

Hello friends Please help me to display the content of a file in specific aligned manner. for ex. the content of the file may be >$TEST WELCOME HI HELLO UNIX SHELL SCRIPTING >$ I want to display the content like . TEST WELCOME HI HELLO ...

7. Shell Programming and Scripting

Replace text in column1 of a file matching columns of another file

Hi all, I have 2 files: species-names.txt Abaca-bunchy-top-virus ((((Abaca-bunchy-top-virus((Babuvirus((Unassigned((Nanoviridae((Unassigned)))) Abutilon-mosaic-virus ((((Abutilon-mosaic-virus((Begomovirus((Unassigned((Geminiviridae((Unassigned))))...

8. Shell Programming and Scripting

How to concatenate 2-columns by 2 -columns for a text file?

Hello, I want to concatenate 2-columns by 2-columns separated by colon. How can I do so? For example, I have a text file containing 6 columns separated by tab. I want to concatenate column 1 and 2; column 3 and 4; column 5 and 6, respectively, and put a colon in between. input file: 1 0 0 1...

9. Shell Programming and Scripting

Perl syntax for formatting columns and text

Dear all, Pzl let me know what is the syntax for converting the columns format to text as i have lots of values for but when i put these values in xls sheet the values are automatically converted to and one more question i have is how to call values from shell script into perl script eg. ...

10. Shell Programming and Scripting

Aligning a file

I have a large text file in following format cat input.txt abc qwert qwer afweferf wdfwefwe ==> kjhjkwdd mnmn ==> jkjkjwekj poiu ==> lklklke tytyutut ==> olkjmnsmn I need to align those lines with the characters " ==>" . I dont want to disturb the lines which dont have "==>". The...

LEARN ABOUT OSF1

dxmcreatescrolledcstext

DXmCreateScrolledCSText(3X)											       DXmCreateScrolledCSText(3X)

NAME

       DXmCreateScrolledCSText - Creates a compound string text widget with scroll bars.

SYNOPSIS

       Widget DXmCreateScrolledCSText(
	       Widget parent,
	       char *name,
	       Args *args,
	       Cardinal num_args );

PARAMETERS

       The  identifier	(widget ID) of the parent widget.  The name of the created widget.  The application override argument list.  The number of
       arguments in the application override argument list.

DESCRIPTION

       The DXmCreateScrolledCSText routine creates a compound string text widget with scroll bars.   The  routine  uses  the  same  arguments  and
       resources  as the DXmCreateCSText routine to create a compound string text widget but uses the following resources to create horizontal and
       vertical scroll bars for the widget as well:

       -------------------------------------------------------------------
       Resource 	     Description
       -------------------------------------------------------------------
       XmNscrollHorizontal   Controls whether a scroll	bar  that  allows
			     the user to scroll through text horizontally
			     is added to the compound string text window.
       XmNscrollTopSide      Controls whether the horizontal  scroll  bar
			     is  positioned  at  the  top of the compound
			     string text window.
       XmNscrollVertical     Controls whether a scroll	bar  that  allows
			     the  user	to scroll through text vertically
			     is added to the compound string text window.
       XmNscrollLeftSide     Controls whether the vertical scroll bar  is
			     placed  on  the  left  side  of the compound
			     string text window.
       -------------------------------------------------------------------

   Inherited Resources
       The DXmCreateScrolledCSText routine inherits behaviour and resources from the following superclasses:

       Core Resource Set XmPrimitive Resource Set DXmScrolledCSText Resource Set

RETURN VALUES

       The identifier (widget ID) of the created compound string text widget.

SEE ALSO

       DXmCreateCSText(3X)

														       DXmCreateScrolledCSText(3X)

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

How to convert text to columns in tab delimited text file

Discussion started by: Unilearn

2. Shell Programming and Scripting

Aligning text files by max field length

Discussion started by: physalis2099

3. Shell Programming and Scripting

Aligning numbers in the second file based on first file

Discussion started by: shoaibjameel123

4. UNIX for Dummies Questions & Answers

Removing columns from a text file that do not have any values in second and third columns

Discussion started by: evelibertine