473,608 Members | 2,074 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Script for counting some columns in file

1 New Member
Hello!!
I have a query to count the last column of the file and print it as shown in the below format!!
I tried using ths but dint work

cut fileWithLotsOfC olumns.txt -d" " -f 1,2,3,4 >fileWithOnlyFi rst4Cols.txt

plz help me

output should be something like this!!!






AF1 AF2 AM1 AM2 EF1 EF2 EM1 EM2
FBgn0033056 119 301 205 141 317 153 506 319
FBgn0037888 20 41 41 22 30 17 57 34
FBgn0034742 3193 3642 2558 2005 1687 1746 3039 3610
FBgn0032640 1243 2804 1969 2130 1777 1536 3143 3259
FBgn0259204 469 1566 971 962 1214 783 1872 1602
FBgn0039821 56 58 36 34 35 46 49 87
Feb 28 '14 #1
1 1998
Luuk
1,047 Recognized Expert Top Contributor
But how does your input look like?

If you have i.e. this:
Expand|Select|Wrap|Line Numbers
  1. a 1 2
  2. b 3 4
than you can add a column with this:
Expand|Select|Wrap|Line Numbers
  1. awk '{ sum=sum+$3 }END{ print sum }
which should output '6'
Mar 1 '14 #2

Sign in to post your reply or Sign up for a free account.

Similar topics

8
6567
by: Radioactive Man | last post by:
I am fairly new to the latest verion of Python and using it on windows 95, 2000, and/or XP. What libraries, modules, functions, etc. would I need to set up a Python script to download a file, say "htttp://www.sound.com/files/bob.wav" to my own hard drive at "c:\sound\bob.wav"? I haven't found any good examples of such an operation in the documentation at the Python website. Any suggestions are appreciated. Thanks.
6
1724
by: John Reese | last post by:
def uselessHash(filename): fp= open(filename) hash= 0 for line in fp: hash ^= hash(line.strip()) fp.close() # do I need this or is fp closed by ref count? return hash Consider the function above. Do I need the fp.close(), or will the file be closed automatically when fp goes out of scope and its
1
5516
by: Avin Patel | last post by:
Hi, I am looking for script to allow multiple files can be uploaded/attached in webform ( mostly cgi/perl or php). But I don't like the multiple input boxes using "<input type="file" size="40" maxlength="40" name="filename">" html tag. As it will limit the no. of files can be uploaded(only as many of this boxes I write in form & doesn't look good in form also). I am looking for multiple file upload in web form using "select" or
10
3142
by: EnjoyNews | last post by:
I have a php site I have an include line called "include 'Cookie.php';" In this Cookie.php file I have these codes. <?php $conn = mysql_connect("$db", "$user", "$pass"); mysql_select_db("$db"); //-------------------------------------------------------------------------- -------------
4
6757
by: Regnab | last post by:
As any good code pirate would, I have duly copied the code suggested in this forum from 1998(VBA method to determine number of columns in a table??) but I keep getting an error "Object Required"... ColumnNum = db.TableDefs(QTable1).Fields.Count http://groups.google.ca/group/comp.databases.ms-access/browse_frm/thread/b24057bf6cf6e021/16d1aa8a5d4841b0?q=count+number+of+columns+in+a+table+vba&rnum=1&hl=en#16d1aa8a5d4841b0). While I am...
1
2115
by: JJ | last post by:
Is it possible to count the number of columns that match certain conditions and return a single value? For example in the database we have a record where: Column 1 = Male Column 2 = A Column 3 = B Column 4 = D Column 5 = M
0
1123
by: brozanic | last post by:
Does anyone have a script or bat file to uninstall Access97?
1
4748
by: Osoccer | last post by:
...to a different folder and in the relocated file concatenates all of the lines in one long string with a space between each line element. Here is a fuller statement of the problem: I need a Visual Basic Script file, call it "Move and Reformat Text File.VBS," that will run from a Windows Script Host command-prompt-based version as follows: C:\> Cscript.exe "Move and Reformat Text File.VBS" The objective of the VBScript file, "Move...
5
7591
by: simplyme7 | last post by:
I have a data file which has not fixed coulmns as follows: Column11 Column12 Column13 Column21 Column22 Column31 Column32 Column33 Column34 . . . I want to know what is the maximum number of columns in each raw and I want to fill all the other missing columns with "NONE" to make my file with fixed column numbers so I can use it in MATLAB.
5
1712
by: ramanagosu | last post by:
Hi, I am new to php please give me an idea how to manage video script in css file using php cheers Ramana.
0
8087
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
8025
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
8509
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
8493
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
0
8365
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
5499
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
3993
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
1
2493
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
0
1363
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.