|
|
Sponsored Content
Top Forums
UNIX for Dummies Questions & Answers
Swapping the columns of a text file for a subset of rows
Post 302686839 by neutronscott on Wednesday 15th of August 2012 12:58:57 PM
|
|
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi,
I have a small requirement in chainging the rows to columns. The below example.txt contains info as shown
Name:Person1
Age:30
Name:Person2
Age:40
Name:Person3
Age:50
I want to make it displayed as hown below
Name:Person1 Age:30
Name:person2 Age:40
Name:Person3 Age:50
I... (4 Replies)
Discussion started by: oracle123
4 Replies
2. Shell Programming and Scripting
Hi All,
I need some help to effectively parse out a subset of results from a big results file.
Below is an example of the text file. Each block that I need to parse starts with "reading sequence file 10.codon" (next block starts with another number) and ends with **p-Value(s)**. I have given... (1 Reply)
Discussion started by: Lucky Ali
1 Replies
3. Shell Programming and Scripting
Hello,
I have a huge tab delimited file with around 40,000 columns and 900 rows I want to convert columns to a row.
INPUT file look like this.
the first line is a headed of a file.
ID marker1 marker2 marker3 marker4
b1 A G A C ... (5 Replies)
Discussion started by: ryan9011
5 Replies
4. Shell Programming and Scripting
Hi!
Im trying to swap 2 columns in a file.The file format is:
'ColumnA','ColumnB'
'A1','A2'
'B1','B2'
'C1','C2'
I tried to solve this using AWK, when I run this command:
awk 'BEGIN {FS=OFS=","} {temp=$1; $1=$2; $2=temp} {print}' InFile.csv >> Outfile.csv
What I get is this:
... (5 Replies)
Discussion started by: RedSpyder
5 Replies
5. UNIX for Dummies Questions & Answers
Hi,
I have a tab delimited text file with multiple columns. The second and third columns include numbers that have not been sorted. I want to extract rows where the second column includes a value between -0.01 and 0.01 (including both numbers) and the first third column includes a value between... (1 Reply)
Discussion started by: evelibertine
1 Replies
6. Shell Programming and Scripting
Hi Friends,
I have come across some files where some of the columns don not have data.
Key, Data1,Data2,Data3,Data4,Data5
A,5,6,,10,,
A,3,4,,3,,
B,1,,4,5,,
B,2,,3,4,,
If we see the above data on Data5 column do not have any row got filled. So remove only that column(Here Data5) and... (4 Replies)
Discussion started by: ks_reddy
4 Replies
7. Shell Programming and Scripting
Hello Unix experts,
I need a help to create a subset file. I know with cut comand, its very easy to select many different columns, or threshold. But here I have a bit problem as in my data file is big. And I don't want to identify the column numbers or names manually. I am trying to find any... (7 Replies)
Discussion started by: smitra
7 Replies
8. Shell Programming and Scripting
Hi all,
I hope all you guys have a great new year!
I am trying to swap 2 columns in a specific block of a file. The file format is:
Startpoint: in11 (input port)
Endpoint: out421 (output port)
Path Group: (none)
Path Type: max
Point ... (5 Replies)
Discussion started by: jypark22
5 Replies
9. Shell Programming and Scripting
I've spent the past hour trying different things and googling for this solution and cannot find the answer. Found variations of this, but not this exact thing.
I have the following text, which is the output from our mainframe. Each field is on a separate line, with a blank line between each... (7 Replies)
Discussion started by: lupin..the..3rd
7 Replies
10. Shell Programming and Scripting
As part of some report generation, I've written a script to fetch the values from DB. But, unluckily, for certain Time ranges(1-9.99,10-19.99 etc), I don't have data in DB.
In such cases, I would like to write zero (0) instead of empty. The desired output will be exported to csv file.
... (1 Reply)
Discussion started by: kumar_karpuram
1 Replies
LEARN ABOUT DEBIAN
fm
FM(1) General Commands Manual FM(1) NAME
fm - control frequency, volume, mute/unmute of FM radio card SYNOPSIS
fm [ -h ] [ -o ] [ -q ] [ -d device ] [ -t tuner ] [ -T none | forever | time ] on | off | + | - | freq [ volume ] DESCRIPTION
fm is a program to control the frequency, volume, and mute/unmute state of an FM radio card, using the video4linux interface introduced in 2.1.x series Linux kernels. OPTIONS -h Print a usage message to standard output, and exit. -o Ignore frequency range limits of card. Use if you suspect that the card supports a wider frequency range than its driver believes. -q Quiet mode. Keeps information on station and volume from being printed on standard output. -d device Sets device as the device to tune. The default is /dev/radio0. -t tuner Sets tuner as the tuner on the selected device to adjust. The default is tuner 0. Most radio devices have only a single tuner. -T none | forever | time After tuning, sleep for the time specified or forever. Time is specified in seconds by default. A suffix of m indicates minutes, h indicates hours, or d indicates days. The -T option is useful with radio card drivers that only maintain the tuner settings while the tuner's file descriptor remains open. Try using this option if running fm ordinarily produces only a single "pop" from your speakers. freq Frequency to tune the radio to, in MHz. For instance, 88.9 specifies a frequency of 88.9 MHz. AM tuner values are also specified in MHz; for instance, 530 kHz would be specified as .530. on Turn the radio on (unmute). off Turn the radio off (mute). volume Specify the desired volume, in percent. Not all radio devices support volume control. + Increase the current volume. - Decrease the current volume. CONFIGURATION
fm reads $HOME/.fmrc, if it exists, to obtain default settings. Each line may take one of the following forms: VOL percent Specifies default volume (default: 12.5%). INCR percent Volume increment used for + and - options (default: 10%). TIME Default sleep time (default: none). All other lines are ignored. SEE ALSO
Additional documentation: /usr/share/doc/fmtools/README The fmtools homepage: http://benpfaff.org/fmtools AUTHORS
Russell Kroll <rkroll@exploits.org>, now maintained by Ben Pfaff <blp@cs.stanford.edu>. Sleep time feature contributed by Dave Ulrick <d- ulrick@insightbb.com>. This manpage written by Ben Pfaff. fm 1.0.2 FM(1)