Aligning text files by max field length Post: 302546529

Sponsored Content

Top Forums Shell Programming and Scripting Aligning text files by max field length Post 302546529 by aigles on Thursday 11th of August 2011 11:16:13 AM

08-11-2011

Registered User

Try and adapt this awk script :

Code:

awk -v FS='|' -v OFS='|' '
    {
        if (MaxFields < NF) MaxFields = NF;
        for (i=1; i<=NF; i++) {
            Field[NR, i] = $i;
            l = length($i);
            if (Length[i] < l) Length[i] = l;
        };
    }
    END {
        for (i=1; i<=MaxFields; i++) Format[i] = "%-" Length[i]+0 "s";
        for (n=1; n<=NR; n++) {
            out = "";
            for (i=1; i<=MaxFields; i++) {
                out = out OFS sprintf(Format[i], Field[n, i]);
            }
            print substr(out,2);
        }
    }

' inputfile

Inputfile :

Code:

YEAR|NAME|PRODUCT_ID|ORDER_ID|CUSTOMER_ID
2001|Unix book|12354|01587|5487651484
2002|Programming|65487|6564548|654365146
2003|Airsoft Guns|6544888|548|65498
2004|Video Games|101100018|44|648
2010|Wayside Stories from wayside school|5487454|4|64645646

Output :

Code:

YEAR|NAME                               |PRODUCT_ID|ORDER_ID|CUSTOMER_ID
2001|Unix book                          |12354     |01587   |5487651484
2002|Programming                        |65487     |6564548 |654365146
2003|Airsoft Guns                       |6544888   |548     |65498
2004|Video Games                        |101100018 |44      |648
2010|Wayside Stories from wayside school|5487454   |4       |64645646

Jean-Pierre.

This User Gave Thanks to aigles For This Post:

aigles

View Public Profile for aigles

Find all posts by aigles

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Length of a Unix filepath max length

Hi Guys, Could anyone shed some light on the length of a Unix filepath max length pls ? thanks ! Wilson

2. Shell Programming and Scripting

what is the max length of args i can pass in shell?

i have a shell script which takes several args. what is the maximum length of string i can give as argument?

3. UNIX for Dummies Questions & Answers

Read file and remove max length

Hi all, I tried to write a shell to read huge file and eliminate max length record which is wrong generated record. But I get an error remove_sp.sh: line 27: syntax error near unexpected token `else' remove_sp.sh: line 27: ` else $LINE >> REJFILE' My shell is here: #!/bin/sh...

4. Shell Programming and Scripting

Counting the max length of string

Hi all, I have a flat file of 1000 rows. I want to check the length of the 5th column. The one having the longest length , I want to set it as DEFINED PARAMETER. So later I can check others with that particular number only. Any ideas ??

5. UNIX for Advanced & Expert Users

How to increase max username length?

Hi, This is my first post to this site. So kindly forgive if I am writing in a wrong section. My query is that... I want to modify the max username length size. I guess it is 32/64 on CentOS. Now I want to change it to 128. Is there any way to do that? Thanks in advance!! :)

6. UNIX for Dummies Questions & Answers

Modify the max username length

Hey Any one... Do u know any way I can modify the max username length in unix? I guess it is 32/64 characters by default. Suppose I want to increase it to 128. i hav tried /etc/skel but no use... How can I do that?

7. Shell Programming and Scripting

Flat file-make field length equal to header length

Hello Everyone, I am stuck with one issue while working on abstract flat file which i have to use as input and load data to table. Input Data- ------ ------------------------ ---- ----------------- WFI001 Xxxxxx Control Work Item A Number of Records ------ ------------------------...

8. Shell Programming and Scripting

Aligning columns in a text file using Perl

Hi All, I am new to perl and was trying to write a simple program which will generate a text file as output.. now the output which i am getting is something like this.. ================================================================================================== Col1 ...

9. Shell Programming and Scripting

Read text between regexps and write into files based on a field in the text

Hi, I have a huge file that has data something like shown below: huge_file.txt start regexp Name=Name1 Title=Analyst Address=Address1 Department=Finance end regexp some text some text start regexp Name=Name2 Title=Controller Address=Address2 Department=Finance end regexp

10. Shell Programming and Scripting

Find max length of the field and then replace zero

hai guys, pick the 1st field and calculate max length. if suppose max length is 2, then compare the all records if <2 then add zero's prefix of the record. for ex: s.no,sname 1,djud 37,jtuhe in this max length of the 1st field is 2 right the output wil be s.no,sname 01,djud...

LEARN ABOUT NETBSD

dynamic_field_info

FORMS(3)						   BSD Library Functions Manual 						  FORMS(3)

NAME

     dynamic_field_info, field_info -- form library

LIBRARY

     Curses Form Library (libform, -lform)

SYNOPSIS

     #include <form.h>

     int
     dynamic_field_info(FIELD *field, int *drows, int *dcols, int *max);

     int
     field_info(FIELD *field, int *rows, int *cols, int *frow, int *fcol, int *nrow, int *nbuf);

DESCRIPTION

     The function dynamic_field_info() returns the sizing information for the field given.  The function will return the number of rows, columns
     and the maximum growth of the field in the storage pointed to by the drows, dcols and max parameters respectively.  Dynamic field information
     cannot be requested for the default field.  If the field given is not dynamic then dynamic_field_info() will simply return the size of the
     actual field.  The field_info() will return the number or rows, columns, field starting row, field starting column, number of off screen rows
     and number of buffers in rows, cols, frow, fcol, nrow and nbuf respectively.

RETURN VALUES

     The functions will return one of the following error values:

     E_OK		The function was successful.
     E_BAD_ARGUMENT	A bad argument was passed to the function.

SEE ALSO

     curses(3), forms(3)

NOTES

     The header <form.h> automatically includes both <curses.h> and <eti.h>.

BSD
								  January 1, 2001							       BSD

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Length of a Unix filepath max length

Discussion started by: wilsontan

2. Shell Programming and Scripting

what is the max length of args i can pass in shell?

Discussion started by: senthilk615

3. UNIX for Dummies Questions & Answers

Read file and remove max length

Discussion started by: mr_bold

4. Shell Programming and Scripting

Counting the max length of string

Discussion started by: ganesh123

5. UNIX for Advanced & Expert Users

How to increase max username length?

Discussion started by: ajay303

6. UNIX for Dummies Questions & Answers

Modify the max username length

Discussion started by: MayureshRisbud

7. Shell Programming and Scripting

Flat file-make field length equal to header length

Discussion started by: sonali.s.more

8. Shell Programming and Scripting

Aligning columns in a text file using Perl

Discussion started by: smarty86

9. Shell Programming and Scripting

Read text between regexps and write into files based on a field in the text

Discussion started by: r3d3

10. Shell Programming and Scripting

Find max length of the field and then replace zero

Discussion started by: Suneelbabu.etl

LEARN ABOUT NETBSD

dynamic_field_info