General :: Transpose Multiple Rows Into A Single Column?
Apr 7, 2011
I need to transpose a file with over a 1000 rows of 5 columns of numbers into a file with a single column of numbers. The numbers are separated by a single space and range from one digit to 5 digits each. I tried using awk, but can only get it to grab one column of numbers.
Input:
1 2 3 4 50
600 7 8 9000 10
11 12000 13 14 15
Desired output:
1
2
3
4
[code]....
Tried using: awk '{split($0,a,""); print $NF}' <filename> and got:
50
10
15
It only grabbed the last number in each row.
View 13 Replies
ADVERTISEMENT
Jul 15, 2010
I have a multicolumn datas, like
a1 b1 ... f1
a2 b2 ... f2
. . ... .
[code]...
I would like to make a file with all these data in one column, like
a1
a2
.
.
[code]....
Can it be done with awk or some other command? Also, is it possible then do add another column in front of this one with numbers of the lines (for every previous column), like
1 a1
2 a2
. .
. .
[code].....
View 14 Replies
View Related
Jan 18, 2011
I have a lot of files with thousands of rows and usually two columns of data. Column 1 is a coordinate, column 2 is a score. I want to delete rows that have a value in column 2 over, in this case, 50.
For example, here's a clip from a file:
2999898 39
2999899 40.9
2999900 42.7
2999901 44.7
2999902 46.7
2999903 48.9
2999904 51.1
2999905 53.3
2999906 55.7
I want the output to be this:
2999904 51.1
2999905 53.3
2999906 55.7
I know how to use sed for very basic things like deleting rows or ranges of rows but I can't figure out this ostensibly easy command.
View 6 Replies
View Related
May 13, 2011
Have this script which is reading in a series of files, one at a time with while-do-done loop, each file goes through various greps/awk's where this info is then saved to various files for later use. i.e....
Script is being run on Linux Red Hat,
In one of the grep/awk's the output (currently) are 2 columns (min max), i.e....| awk '{print $1, $2}' | sort -u which outputs (e.g.)
The number of "min max" pairs varies from file to file. Want to output a single column of unique numbers from the min max pairs & get the number of them for input to a file...i.e...
Where <PROCESS> is some process/technique that will generate a single column of integers (increment of 1) to pipe into the next one (sort -u)
i.e. (example from above)
Have tried command seq - only works for single pair input i.e.
Is there any command like seq etc which will output a single column based on a input of min max numbers (increment 1) to pipe onwards to next command?
View 4 Replies
View Related
Feb 4, 2011
I installed gDevilspie and am using that to configure it, and I have Compiz running with a 2x2 viewport layout (2 horizontal and 2 vertical viewports).I have Devilspie working beautifully for any application that is assigned to either viewport 1 or 2. However, if I try to set them to viewports 3 or 4, the viewports on the bottom, Devilspie does not do anything.Devilspie does not give me any errors when I run it from the terminal. What I've noticed is that it only seems to work with horizontal viewports. I changed the viewport layout from 2x2 to 4x1 (so they were all on a single row), and then setting viewports 3 and 4 worked beautifully. However, with a 2x2 layout, I can only use viewports 1 and 2.
Furthermore, I noticed that if I had an application set to, say, viewport 1 (e.g., Firefox), then it would open in viewport 3 if I was currently viewing viewport 4. In other words, it's treating my viewports as if I have two sets of viewport 1 and viewport 2; one set on the top row, and the second on the bottom row.I'm not sure what's causing this, or if there's some sort of trickery that needs to be done to make the bottom row of viewports work, but any help would be appreciated.In case it's needed, I'm running Ubuntu 10.10, devilspie 0.22, gdevilspie 0.5, and compiz 0.8.6. Pasted below is one of the problem scripts (note that if I were to set it to viewport 1 or 2, it would work fine).
Code:
; generated_rule XChat
( if
[code]...
View 2 Replies
View Related
May 26, 2011
I've been hitting my head against a wall for awhile with this one:As the last part of some data analysis I performing I would to construct a matrix from a series of different files. These files have the format:
file 1 file 2 file 3
AAAAA .1 AAAAA .1 BBBBB .1
BBBBB .2 BBBBB .1 CCCCC .9
[code]...
View 6 Replies
View Related
Oct 13, 2010
I have question about the UNIX sockets. my goal is to connect multiple sockets from a single client to a single server and keep them open...I'm not sure if that is possible to create or not. Do you have any suggestion or an example of code?
View 1 Replies
View Related
Mar 6, 2011
Is there any limitation to the number of transactions through a single port if so then if we assign multiple port to that particular service then the performance is increased (what i suppose)
so: Is there any way to assign multiple Ports to a single service. like for a web server the main service is httpd or some thing like that to be running on the server and now if we assign multiple ports to that service then the performance increases.
View 2 Replies
View Related
Jul 19, 2010
How would i calculate following values.Initial file
10 3
20 4
How would i calculate 3rd column which should be addition of value in 1 and 2nd column.File after calculation
10 3 13
20 4 24
View 14 Replies
View Related
Apr 28, 2011
If i have two domins [URL] and [URL], can i point it to same IP Address in DNS?.I had already added namevirtualhost in my Apache.If possible, is there any risk,disadvantages.
View 11 Replies
View Related
Jul 1, 2010
I am new in client server programming and i have written code for single server to single client communicating one port(3490). but i have no idea how my single server will be communicate with different client on different port.how this will be happen ?
Any idea to understand the logic or send any good link or any piece of code in c , i searched on net but all help was mostly for java progamming.
View 1 Replies
View Related
Jun 3, 2010
I'm calling a function defined in "uart.c" from "main.c"
But on "make" using cygwin bash, it's giving an error:"Unreferenced function"...
Pls help me to overcome this problem.
If i'm putting the definition of that function in "main.c" itself, its working.
So pls tell me how to write the make file for it?
View 4 Replies
View Related
Mar 18, 2010
Possible Duplicates: Dual Booting Linux and Windows XP Booting Multiple Operating Systems I have a machine with Windows on it, and I would like to be able to reboot to Linux. I am certain this is possible. How can I achieve this?
View 2 Replies
View Related
Apr 24, 2010
I have an unencrypted DVD that is one big title, ie you cannot skip next / prev. What I want to do is reauthor the DVD with title at certain points, so that I can skip next / prev when watching it.
I'm using Ubuntu 8.10
View 1 Replies
View Related
Jul 5, 2011
i have 30 linux PCs running. i need to check the performance of all pcs( memory,ram and process usage) in single command or in GUI mode.In solaris we have perf script to check performance in GUI mode. i need same type in linux?
View 1 Replies
View Related
Sep 12, 2010
how to update a series of values from multiple grep commands outputs to be appended to a single row of a csv file? Work on a linux envir. The values from grep output will be numeric values.
Output sold look like:
1,3,4,5,7,0,5
Each of these values will be odtained from multiple grep commands piped with wc -l Is it possible to update a single row of a csv file if so pleas ehelp me with the command to be used to redirect the output into the csv file
View 5 Replies
View Related
Jun 18, 2010
I want to do something like svn add dir1 dir2; svn ci dir1 dir2 but have it be only 1 revision. Is there a way to do this? Is this the correct way to add new folders (with contents) to the repository? We are restructuring the trunk, so I cleared it out and plan on putting these directories with their contents in it.
View 1 Replies
View Related
Jul 11, 2011
I've written a script (that doesn't work) that looks something like this:
#!/bin/sh
screen -dmS "somename" somecommand
for i in {0..5}; do
screen -dmS "name$i" anothercommand $i
done
For some reason, if I copy and paste this into a terminal, it creates 7 detached screen sessions as I expect. If I run it from within a script, however, I get only the first session, "somename," when I run screen -ls.
Edit: If the same can be accomplished another way (e.g. with multiple screen windows instead of sessions), I would be open those solutions as well.
View 3 Replies
View Related
Aug 17, 2011
How can I configure a single computer to work for multiple simultaneous users? I would like to have multiple keyboards and monitors on a single PC ... Is it possible? This set up I'm planning for CyberCafe, For cyberCafe business ROI is very slow... so was planning to have something like this....
-single CPU (Which would act as a server)
-Multiple monitors, keyboards, Headphones etc....
If this works out then I would save a lot on my investments (OS cost, Hardware devices, electricity etc)
View 3 Replies
View Related
Nov 28, 2010
I am using Xfce as the desktop enviroment and Mozilla Firefox as the webrowser. Within the webrowser window, I do File>Save Page As. I save it, and the result is almost always foo.html and directory foo_files. But I think under KDE I could choose the format, one of them being something like "Single page" (only one file; the colecction of .png, etc is embedded into that file). And this is the format I want Xfce (or Firefox) to use when downloading to hdd.
View 1 Replies
View Related
Dec 1, 2008
I am writing a script to mine data from my game server logs which are going to mysql. My first question is syslog-ng is sticking $msg into one colum it self, $msg tends to be a long string here are a few examples:
cn name team frag death flags role host.
0 Maik CLA 2 0 0 normal *.70.233.118.
1 lizardncd RVSF -1 3 0 normal
[*.22.247.40] lizardncd fragged Maik.
And they are not always in the same format, How could I parse this data to do something useful, like creating a user stats page with frag counts and flag counts. Should I create a script that runs in a cronjob that parses this data to a new table maybe once a day. Even then the $msg string value is random and I am thinking in terms of awk.
Second. I would like to keep track of what ip's are using what nicknames. Kinda in the sense of and ip associated to a array of names that have been used on that ip address so I can keep track of users. How would this work logically with a mysql db, could a column allow multiple values, then loadable into an array, which then can add, remove, and store to mysql.
View 1 Replies
View Related
Feb 3, 2010
I need to create a single line of output from multiple and variable lines of input in a Linux bash shell script.
My input file looks like this:
Where there may be any number of umsecondaryphonenumber lines; if there is not a umsecondaryphonenumber line for a telephonenumber, I don't want to write any output.
So, the output file should look like:
The script I have so far is:
My question is - how do print each of the elements of an array in one record - i.e. what do I put in place of howdoiprintarray?
View 2 Replies
View Related
Mar 7, 2010
i use this script to get the time and date of back and fourth transactions for a particular execution id. I use a substr command on the 5th column to to cut the milli seconds off the time value. - otherwise the times would look like 08:30:04.235
grep <executionID> <auditfile> | awk '{ print $1, $2, $3, $4, substr($5,1,8}
FIX -> Mon 3/1/2010 08:30:04
FIX <- Mon 3/1/2010 08:32:36
FIX <- Mon 3/1/2010 08:35:08
[code].....
anyhow - i append two sed commands to further clarify the direction of the message.
awk '{ print $1, $2, $3, $4, substr($5,1,8} | sed -e 's/->/ ->IN/g' | sed -e 's/<-/<-OUT/g'
FIX -> IN Mon 3/1/2010 08:30:04
FIX <- OUT Mon 3/1/2010 08:32:36
[code]....
I tried using an awk gsub () command within the string instead of the two seds, but it did not work:
awk '{ print gsub(/<regex>/, <replace with>,$1), $2, $3, $4, substr($5,1,8}
the sed works ok, but it would be cooler to make the replacement within the awk command:
gsub(/->/,-> IN, $1)
Is there a way where i could replace the value of the $1 column in the awk print string?
View 1 Replies
View Related
Jul 26, 2010
I am running Linux from a DVD, not installed. I am not good with installing software, but since the DVD cannot be corrupted, I am content to operate this way. Lately, I have been having problems that previously did not occur. When I try to click on the checkbox to get rid of emails, it doesn't register in most cases, or when it does, I am clicking multiple times so it registers twice, meaning it is unchecked again. Even more frustrating is some issues that are affecting my ability to update my business. I am trying to modify spreadsheets (text not calculations).
Whenever I try to click & drag to select something to change, it keeps jumping around to select only some of what I want, something else or some combination of the 2. When I try to copy and paste several fields from 1 column to another, everything from the several fields in the source column ends up together in the last field in the target column. I am also trying to download some images from a website. There is a single column of links to the images. I have to click on the link to get to the image in order to copy it, then back out to continue looking for more links to do the same.
My computer keeps jumping back 2 steps, then forward 2 steps, and sometimes I lose my place in that list. I could deal with it if it were a small number of links, but this is a list of probably close to 20,000 links. Again, i am operating off of a live DVD so this should not be corruptible, but this has just started happening, and has been an issue the last several sessions.
View 14 Replies
View Related
Feb 10, 2010
If I have SMP kernel would it work with single processor or only work with multiple processors system?
View 6 Replies
View Related
Jan 23, 2011
I've been trying to set multiple IP my Fedora 14 but nothing seems to work. Upon browsing the net, I found there are two ways for it. One is eth0:0~eth0:n nd another is eth0-range0. All are configs under network-scripts. But neither of them worked for me. Even grabbing a working example from my live server doesn't do the trick (though the server is a CentOS 5.5).
Currently using eth0-range0
ONBOOT=yes
IPADDR_START=192.168.1.127
[code]...
View 2 Replies
View Related
Jun 29, 2010
I have an Ubuntu install on an 8Gb SDHC Card, customized for my Toshiba NB205. It took quite a bit to get sound and BT working, but now it's fine. Just out of curiousity, I used this same SDHC Card to boot my Dell D610 -- it booted, and sound and WiFi worked fine. I was surprised. There was a single error message after the desktop appeared, but I didn't record it.
I am now wondering: is it practical to use a single USB installation with multiple devices? I can imagine a number of complications, but was surprised that my attempt worked on two very different hardware platforms. There was discussion, when pendrives first appeared, of being able to use one to boot any PC to your own USB-based OS, bypassing any other OS installed on the PC.
View 4 Replies
View Related
Jan 20, 2011
We can add multiple IP address on a single NIC. Is there any limitation that is how many ip address I can add on a single NIC card??
View 1 Replies
View Related
Feb 27, 2011
have a look at the following thread story and please clear my doubt.
View 6 Replies
View Related
Mar 27, 2010
We have too many audio Paths, for each user have one. We would like to create a unique folder to Read in network.
For example:
The idea is Mapping all folders to the path /pub/Music in server, so all user can access all music online in the server.
Very Well. How we can do it?
And when pc1 and pc2 have the same subfolder, like Beatles, and in the subfolder have different folders ( PC1-Beatles/Revolver ) (PC2-Beatles/Habbey_Road) or The same folder (PC1-Beatles/The_Mistery_Magic_Tour) (PC3-Beatles/The_Mistery_Magic_Tour)...
Is there a way to contemplate this issue?
View 4 Replies
View Related