I think we've had a problem communicating because the example input doesn't match the sample results you said that you want to see. When you said the input was truncated, I think most of us thought you were giving us complete lines (but just giving us a few lines; not that you were also shortening fields in the few lines you gave us). And then showing a <space> between semicolons in sample output when you didn't want the space there caused more confusion.
I think you'll get what you want if you take the code supplied by binlib modified to use the field start and end points specified in your first message, and modified to use ";" instead of "," as the output field separator:
If you're having trouble following the initial set up in the BEGIN clause or the for loop in the main body of the script, another way to do it would be:
This User Gave Thanks to Don Cragun For This Post:
Greetings,
I would like to extract records from a fixed width text file that have unique field elements.
Data is structured like this:
John A Smith NY
Mary C Jones WA
Adam J Clark PA
Mary Jones WA
Fieldname / start-end position
Firstname 1-10... (8 Replies)
Hi, I have two files.
File1:
File1 contains two fixed width columns ID of 15 characters length and Name is of 100 characters length.
ID Name
1-43<<11 spaces>>Swapna<<94 spaces>>
1-234<<10 spaces>>Mani<<96 spaces>>
1-3456<<9 spaces>>Kapil<<95 spaces>>
File2:
... (4 Replies)
Hi,
I have a fixed width file with some records as given below:
" 1000Nalsdjflj243324jljlj"
"-0300Njfowjljl309933fsf"
" 0010Njsfsjklj342344fsl"
I want to sum-up first field values(i.e from 2nd character to 6th character)of each record.
so for the above file i want to add (1000 - 300+... (2 Replies)
I am trying to remove a line feed (\n) within a fixed width record. I tried the tr -d ‘\n' command, but it also removes the record delimiter. Is there a way to remove the line feed without removing the record delimiter? (10 Replies)
Hi everyone,
I have been working on a pretty laborious shellscript (with bash) the last couple weeks that parses my firewall policies (from a Juniper) for me and creates a nifty little columned output. It does so using awk on a line by line basis to pull out the appropriate pieces of each... (4 Replies)
Hi,
I have a file with fixed number of columns (total 58 columns) delimeted by pipe (|). Due to a bug in the application the export file does not come with fixed number of columns. The missing data columns are being replaced by blank in the output file. In one line I can have 25 columns (33... (1 Reply)
Hi All ,
I have a requirement where I need to remove duplicates from a fixed width file which has multiple key columns .Also , need to capture the duplicate records into another file .
File has 8 columns.
Key columns are col1 and col2.
Col1 has the length of 8 col 2 has the length of 3.
... (5 Replies)
Thank u so much .Its working fine as expected.
---------- Post updated at 03:41 PM ---------- Previous update was at 01:46 PM ----------
I need one more help.
I have another file(fixed length) that will get negative value (ex:-00000000003000) in postion (98 - 112) then i have to... (6 Replies)
Hello All,
I have a requirement in which i will be given a sql query as input in a file with dynamic number of columns. For example some times i will get 5 columns, some times 8 columns etc up to 20 columns.
So my requirement is to generate a output query which will have 20 columns all the... (7 Replies)
Discussion started by: vikas_trl
7 Replies
LEARN ABOUT SUNOS
pnmcut
pnmcut(1) General Commands Manual pnmcut(1)NAME
pnmcut - cut a rectangle out of a portable anymap
SYNOPSIS
pnmcut [-left leftcol] [-right rightcol] [-top toprow] [-bottom bottomrow] [-width width] [-height height] [-pad] [-verbose] [ left top
width height ] [pnmfile]
All options may be abbreviated to the shortest unique prefix.
DESCRIPTION
Reads a PBM, PGM, or PPM image as input. Extracts the specified rectangle, and produces the same kind of image as output.
There are two ways to specify the rectangle to cut: arguments and options. Options are easier to remember and read, more expressive, and
allow you to use defaults. Arguments were the only way available before July 2000.
If you use both options and arguments, the two specifications get mixed in an unspecified way.
To use options, just code any mixture of the -left, -right, -top, -bottom, -width, and -height options. What you don't specify defaults.
It is an error to overspecify, i.e. to specify all three of -left, -right, and -width or -top, -bottom, and -height.
To use arguments, specify all four of the left, top, width, and height arguments. left and top have the same effect as specifying them as
the argument of a -left or -top option, respectively. width and height have the same effect as specifying them as the argument of a -width
or -height option, respectively, where they are positive. Where they are not positive, they have the same effect as specifying one less
than the value as the argument to a -right or -bottom option, respectively. (E.g. width = 0 makes the cut go all the way to the right
edge). Before July 2000, negative numbers were not allowed for width and height.
Input is from Standard Input if you don't specify the input file pnmfile.
Output is to Standard Output.
OPTIONS -left The column number of the leftmost column to be in the output. If a nonnegative number, it refers to columns numbered from 0 at the
left, increasing to the right. If negative, it refers to columns numbered -1 at the right, decreasing to the left.
-right The column number of the rightmost column to be in the output, numbered the same as for -left.
-top The row number of the topmost row to be in the output. If a nonnegative number it refers to rows numbered from 0 at the top,
increasing downward. If negative, it refers to columns numbered -1 at the bottom, decreasing upward.
-bottom
The row number of the bottom-most row to be in the output, numbered the same as for -top.
-width The number of columns to be in the output. Must be positive.
-height
The number of rows to be in the output. Must be positive.
-pad If the rectangle you specify is not entirely within the input image, pnmcut fails unless you also specify -pad. In that case, it
pads the output with black up to the edges you specify. You can use this option if you need to have an image of certain dimensions
and have an image of arbitrary dimensions.
pnmpad can also fill an image out to a specified dimension, and gives you more explicit control over the padding.
-verbose
Print information about the processing to Standard Error.
SEE ALSO pnmcrop(1), pnmpad(1), pnmcat(1), pgmslice(1), pnm(5)AUTHOR
Copyright (C) 1989 by Jef Poskanzer.
29 June 2000 pnmcut(1)