07-30-2010
Count all columns in a given file
Hi,
I have a file where i have dump of a DB. it has all the columns and rows inside that. I wanted to extract the columns and number of columns from that dump.
Any suggestions will be helpful.
Thanks
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hello,
I have a file
=================
12 SRV1 GRP1
19 SRV1 GRP1
19 SRV1 GRP2
3 SRV1 GRP1
3 SRV1 GRP2
30 SRV1 GRP2
7 SRV1 GRP1
8 SRV1 GRP3
===========
I want output like
===============
41 SRV1 GRP1
52 SRV1 GRP2
8 SRV1 GRP3 (1 Reply)
Discussion started by: kaustubh137
1 Replies
2. Shell Programming and Scripting
Hi All,
Consider the file with following lines:
1,2,3,4
1,2,3,
5,6,7,7,8,9
1
I need to get the count of minimum columns per line. i.e. in above case, it should come out to be 1 since the last line only has 1 column.
I tried following code:
minCount = 0
wordCountPerLine = 0... (12 Replies)
Discussion started by: sh_kk
12 Replies
3. Shell Programming and Scripting
Hi there, I just wanted to know whether there was an easy way of checking the number of white space separated columns or words in a provided string (scalar) without turning it into an array
for example if I have a string like this
$string="a b c d 6";
obviously if i was using an array i... (2 Replies)
Discussion started by: hcclnoodles
2 Replies
4. Shell Programming and Scripting
I'm writting a script that will get the logical volumes from a volume group and check for mirroring. I'm using a while read line command. I need to be able to count the columns for the output and if it is <= 3 save the logical volume to a file and if it is > 3 continue. How do I capture the... (1 Reply)
Discussion started by: daveisme
1 Replies
5. Shell Programming and Scripting
hi I am very new to shell scripting. i wanted to achieve this..
Col1 Col2 Col3 Col4
aa 23 bb 32
aa 34 bb 12
aa 45 bb 345
kk 20 ss 50
kk 30 ss 50
tt 10 vv 50
Desired output is
Col1 Col2 Col3 Col4 Difference Count
aa 23 bb ... (1 Reply)
Discussion started by: empyrean
1 Replies
6. Shell Programming and Scripting
Hi All,
My Input.txt should have always 4 columns in some cases i may not get all the 4columns data.
My requirement is if columns as not equal to 4 then append new column delimiter.
Input.txt
A,1,2
B,1,2,3
C,1
Desired output should be in below format
Output.txt
A,1,2,... (3 Replies)
Discussion started by: kmsekhar
3 Replies
7. UNIX for Dummies Questions & Answers
Hi. I am not sure the title gives an optimal description of what I want to do.
I have several text files that contain data in many columns. All the files are organized the same way, but the data in the columns might differ. I want to count the number of times data occur in specific columns,... (0 Replies)
Discussion started by: JamesT
0 Replies
8. UNIX for Beginners Questions & Answers
Hello, I have two tab files with headers
File1: with 4 columns
header1 header2 header3 header4
44 a bb 1
57 c ab 4
64 d d 5
File2: with 26 columns
header1.. header5 header6 header7 ... header 22...header26
id1 44 a bb
id2 57 ... (6 Replies)
Discussion started by: nans
6 Replies
9. UNIX for Beginners Questions & Answers
I have a file abc.csv, from which I need column 24(PurchaseOrder_TotalCost) to get the sum_of_amounts with date and row count into another file say output.csv
abc.csv-
UTF-8,,,,,,,,,,,,,,,,,,,,,,,,,
... (6 Replies)
Discussion started by: Tahir_M
6 Replies
10. Programming
The file is similar to the attached.
Thousands of columns, delimiter is tab, with many columns containing free text and space separated.
I want to get the count of columns with non-empty entries.
eg.Col1=10, Col6=5, Col8=1
awk preferred (7 Replies)
Discussion started by: genehunter
7 Replies
pfscut(1) General Commands Manual pfscut(1)
NAME
pfscut - Extract a rectangle out of a frame in PFS stream
SYNOPSIS
pfscut [--left <columns>] [--right <columns>] [--top <rows>] [--bottom <rows>] [--width <new_width>] [--height <new_height>] [--help] [x_ul
y_ul x_br y_br]
DESCRIPTION
Extract a rectangle out of each frame in PFS stream. You can either specify x and y coordinates of upper left and lower right corner (the
coordinates start with 0 and rise in the left-to-right and up-to-botton directions) or give a combination of the options listed below.
OPTIONS
--left <columns>, -l <columns>
Number of columns to be cut out from the left edge of an image.
--right <columns>, -r <columns>
Number of columns to be cut out from the right edge of an image.
--top <rows>, -t <rows>
Number of rows to be cut out from the top edge of an image.
--bottom <rows>, -b <rows>
Number of rows to be cut out from the bottom edge of an image.
--width <new_width>, -W <new_width>
Width of an output image. Note that --width can be mixed with either --left or --right option.
--height <new_height>, -H <new_height>
Height of an output image. Note that --height can be mixed with either --top or --bottom option.
--help, -h
Print a list of commandline options.
EXAMPLES
pfsin image.hdr | pfscut --left 20 --top 5 | pfsout out.hdr
Cut out 20 columns from the left and 5 rows from the top edge of image.hdr and save frame as out.hdr.
pfsin image.hdr | pfscut --left 20 --width 400 | pfsout out.hdr
Cut out 20 columns from the left edge of image.hdr, and create output image 400 pixels in width.
pfsin image.hdr | pfscut 0 0 511 511 | pfsout out.hdr
Cut left-upper part of the image of the size 512x512 (note that coordinates start with 0 and 512 is the last row/column that is
included in the resulting image).
SEE ALSO
pfsin(1) pfsout(1)
BUGS
Please report bugs and comments to Dorota Zdrojewska <dzdrojewska@wi.ps.pl>.
pfscut(1)