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:
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
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.
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?
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).
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:
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?
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.
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.
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.
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?
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 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?
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
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.
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.
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)
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.
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.
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?
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
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.
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
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.
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)...
