Print column details from fixed width file using awk command Post: 302929778

9 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Fixed Width file using AWK

I am using the following command at the Unix prompt to make my 'infile' into a fixed width file of 100 characters. awk '{printf "%-100s\n",$0}' infile > outfile However, there are some records with a special character "�" These records are using 3 characters in place of one and my record...

2. Shell Programming and Scripting

Comparing column of variable length anf fixed width file

Hi, I have two input files. File1: ID Name Place 1-234~name1~Newyork 1-34~name2~Boston 1-2345~name3~Hungary File1 is a variable length file where each column is seperated by delimitter "~". File2: ID Country 1-34<<11 SPACES>>USA<<7 spaces>> 1-234<<10 SPACES>>UK<<8...

3. Shell Programming and Scripting

edit entire column from a fixed-width file using awk or sed

Col1 Col2 Col3 Col4 12 Completed 08 0830 12 In Progress 09 0829 11 For F U 07 0828 Considering the file above, how could i replace the third column the most efficient way? The actual file size is almost 1G. I am...

4. Shell Programming and Scripting

Changing one column of delimited file column to fixed width column

Hi, Iam new to unix. I have one input file . Input file : ID1~Name1~Place1 ID2~Name2~Place2 ID3~Name3~Place3 I need output such that only first column should change to fixed width column of 15 characters of length. Output File: ID1<<12 spaces>>Name1~Place1 ID2<<12...

5. UNIX for Dummies Questions & Answers

Remove duplicates based on a column in fixed width file

Hi, How to output the duplicate record to another file. We say the record is duplicate based on a column whose position is from 2 and its length is 11 characters. The file is a fixed width file. ex of Record: DTYU12333567opert tjhi kkklTRG9012 The data in bold is the key on which...

6. Shell Programming and Scripting

How to split a fixed width text file into several ones based on a column value?

Hi, I have a fixed width text file without any header row. One of the columns contains a date in YYYYMMDD format. If the original file contains 3 dates, I want my shell script to split the file into 3 small files with data for each date. I am a newbie and need help doing this.

7. Shell Programming and Scripting

To replace the value of the column in a fixed width file

I have a fixed with file with header & trailer length having the same length of the detail record file. The details record length of this file is 24, for Header and Trailer the records will be padded with spaces to match the record length of the file Currently I am adding 3 spaces in header...

8. Shell Programming and Scripting

Replace using awk on fixed width file.

All, I used to use following command to replace specific location in a fixed width file. Recently looks like my command stopped working as intended. We are on AIX unix. awk 'function repl(s,f,t,v) { return substr(s,1,f-1) sprintf("%-*s", t-f+1, v) substr(s,t+1) } NR<=10 {...

9. Shell Programming and Scripting

UNIX command -Filter rows in fixed width file based on column values

Hi All, I am trying to select the rows in a fixed width file based on values in the columns. I want to select only the rows if column position 3-4 has the value AB I am using cut command to get the column values. Is it possible to check if cut -c3-4 = AB is true then select only that...

LEARN ABOUT DEBIAN

text2ps

TEXT2PS(L)																TEXT2PS(L)

NAME

       text2ps - convert text files to PostScript

SYNOPSIS

       text2ps [ options ] [ files ]

DESCRIPTION

       Text2ps	reads the input files (standard input if none are specified) and produces PostScript code which, when fed to a PostScript printer,
       will print the files.  With text2ps it is possible to select any font, point size and number of columns.  Options and files can	be  inter-
       mixed on the command line.  Options are effective for all following files until they are overridden.

       Options

       Here  follows  a list of options that text2ps recognizes.  Most numeric arguments are significant to one decimal place.	Options are evalu-
       ated from left to right.  Later options override earlier ones.

       -# n   Print n copies of each page.  (Default 1.)

       -c n   Print in n columns.  (Default 1.)

       -f font
	      Print using font font.  (Default Courier.)

       -p n   Print with point size n.	(Default 9.)

       -v n   Use a vertical spacing of n points.  If the vertical spacing is set to 0, the spacing will be 1.2 times the  point  size.   (Default
	      0.)

       -l n   Print n lines per column.  When the line count is 0, print as many lines as will fit.  (Default 0.)

       -r [p|l]
	      Set the orientation to either portrait mode (p) or landscape mode (l).  (Default p.)

       -b [+|-]
	      Set  page  break	mode.	An  argument + will force new files to be always printed on a new page (this is the default).  After - new
	      files will be put on the same page if there are still empty columns and the number of columns, the  orientation  or  the	number	of
	      copies didn't change.  New files always start new columns.  (Default -.)

       -mt n  The top margin is n points.  (Default 63.)

       -mb n  The bottom margin is n points.  (Default 63.)

       -ml n  The left margin is n points.  (Default 59.)

       -mr n  The right margin is n points.  (Default 59.)

       -mg n  The inter-column gap is n points.  (Default 25.)

       -t [+|-]
	      If  the  argument is + the name of the file being printed will be printed on each page.  If the argument is - the file name will not
	      be printed.  -t + implies -b +.

       -T text
	      Print text as title on each page.  This implies -t - and -b +.  This option can be  switched  off  by  specifying  -t  -	or  -t	+.
	      (Default no title.)

       -F font
	      Set the title font to font.  (Default Helvetica.)

       -P n   Set the title point size to n.  (Default 12.)

       -B n   Draw borders around each page.  The number n specifies how to draw borders.  N can have any of the following values or-ed in:

	      1      Draw a line along the left of the page.

	      2      Draw a line along the bottom of the page.

	      4      Draw a line along the right of the page.

	      8      Draw a line along the top of the page.

	      16     Draw a line between columns.  This line does not connect to the lines along the top or bottom.

	      32     Draw a connecting line between the line between columns and the line along the top.

	      64     Draw a connecting line between the line between columns and the line along the bottom.

	      When n is 0, no border lines are drawn.  (Default no bordering lines.)

       -w n   Tab stops are set every n spaces.  Set the width of the TAB character.  (Default 8.)

       -1     Sets  up	options  to print in one column in portrait mode with the Courier font, so that you get 66 lines on a page.  Equivalent to
	      specifying the options -c 1 -f Courier -p 9 -v 0 -r p -l 0 -mt 63 -mb 63 -ml 59 -mr 59.
	      This is the default.

       -2     Sets up options to print in two columns in landscape mode with the Courier font, so that you get two  66-line  columns  on  a  page.
	      Equivalent  to  specifying the options -c 2 -f Courier -p 6 -v 0 -r l -l 0 -mt 63 -mb 63 -ml 59 -mr 59 -mg 25.  Together with the -1
	      option, this is probably the most useful option.

       The name - means standard input.

BUGS

       Too many options.

       There is no way to specify where the title will be placed.

       If the font being used is not a constant width font and there are other characters than just tabs and spaces in front of a  tab,  the  next
       character may not align properly.

																	TEXT2PS(L)