11-18-2009
File Transpose
Hi ALL
I have one input file say FILE1 which looks as below.
a=1
b=2
c=3
a=4
b=5
c=6
.
.
.
Here a,b,c...etc are variable names.
The output file(FILE2) should look like
1,2,3
4,5,6
.....
.....
If in any case any of the variable does not come in the input file then in the output file same variable should be populated as NULL.
e.g:
Input file(FILE1)
----------
a=1
b=2
c=3
a=4
c=6
.
.
.
Then output file (FILE2) should look like:
1,2,3
4,,6
.....
.....
Please help me in wrinting the above script.
Thanks in advance.
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi all,
I have a file in the below format....
<A>
B
C
<A>
E
F
<A>
G
H
I need the result file to be:
<A>BC
<A>EF
<A>GH (3 Replies)
Discussion started by: new_ds_man
3 Replies
2. Shell Programming and Scripting
Hello all,
I want to transpose the rows of a file to the columns (every characters include spaces), i.e.:
input:
abcdefg
123 456
output:
a1
b2
c3
d
e4
f5
g6
I wrote a script:
#!/bin/csh -f (15 Replies)
Discussion started by: heavenfish
15 Replies
3. Shell Programming and Scripting
Hi I have an input file and I want to transpose it but I need to take care that if any field is missing for a record it should be popoulated with space for that field - using a shell script
INFILE
----------
emp=1
sal=2
loc=abc
emp=2
sal=21
sal=22
loc=xyz
emp=5
loc=abc
OUTFILE... (10 Replies)
Discussion started by: 46019
10 Replies
4. Shell Programming and Scripting
input
IndID ID1 ID2 ID3
a1 a/a b/b c/c
a2 a/a b/b c/c
a3 a/b b/b c/d
a6 a/b b/b c/e
a8 a/a b/c c/e
a9 b/b b/d c/e
output
IDName IndID IDtype C_No
ID1 a1 a/a 1
ID1 a2 a/a 1
ID1 a8 ... (1 Reply)
Discussion started by: stateperl
1 Replies
5. Shell Programming and Scripting
Hello,
I have a text file which is like a matrix m rows and n columns. Now I want to convert it into n rows and m columns.
Thanks for hint. (1 Reply)
Discussion started by: zhshqzyc
1 Replies
6. Shell Programming and Scripting
Hi,
I have a file like this
a b c
d e f
g h i
j k l
Case1:
I want to transpose the whole file
Output1
a d g j
b e h k
c f i l
Case2
Transpose a specific column - Say 3rd (6 Replies)
Discussion started by: jacobs.smith
6 Replies
7. Shell Programming and Scripting
Hi Friends,
I have a file with a structure like this:
<file1.csv>
field1,field2,field3,field4,field5,field6,field7,field8,field9,field10,field11,field12
Few Salient points on the file's structure
(1)The fields from field1 to field6 is fixed and they would always be present in the file... (2 Replies)
Discussion started by: mehimadri12
2 Replies
8. UNIX for Dummies Questions & Answers
Have various files like this:
InSlot=0x00000001
InPort=0x00000000
Inref=0x0000002f
InSID=0x00000001
OutSlot=0x00000001
OutPort=0x00000002
Outref=0x00000000
OutSID=0x0000000b
OutUName_2=14
InSlot=0x00000001
InPort=0x00000000
Inref=0x000001a8
InSID=0x00000001
OutSlot=0x00000001... (5 Replies)
Discussion started by: K@rlos
5 Replies
9. Shell Programming and Scripting
Hello,
I have a text file with 148 rows and 2532691 columns. I need to transpose the data. The command that I am using is
awk '
{
for (i=1; i<=NF; i++) {
a = $i
}
}
NF>p { p = NF }
END {
for(j=1; j<=p; j++) {
str=a
for(i=2; i<=NR; i++){
... (6 Replies)
Discussion started by: nans
6 Replies
10. UNIX for Dummies Questions & Answers
Hello,
I have a file which looks like this
Input:
Sample Genotype Assay Well plate
Sample1 T xx A01 1
Sample2 T xx A01 2
Sample3 T xx A01 3
Sample4 T xx A02 4
Sample5 T xx A02 5
Sample6 T xx A02 ... (4 Replies)
Discussion started by: nans
4 Replies
MELD(1) General Commands Manual MELD(1)
NAME
meld - Visual diff and merge tool for the GNOME Desktop
SYNOPSIS
meld [options]
meld [options] FILE1
meld [options] DIR1
meld [options] FILE1 FILE2 [FILE3]
meld [options] DIR1 DIR2 [DIR3]
DESCRIPTION
Meld is a graphical diff viewer and merge application for the Gnome desktop. It supports 2 and 3-file diffs, recursive directory diffs,
diffing of directories under version control (Arch, Bazaar, Codeville, CVS, Darcs, Git, Mercurial, Monotone, RCS), as well as the ability
to manually and automatically merge file differences.
OPTIONS
--auto-compare, -a
Automatically compare all differing files on startup.
--diff FILE1|DIR1 FILE2|DIR2 [FILE3|DIR3]
Create a diff tab for the given files or directories. Note that "meld --diff FILE1 FILE2" is functionally equivalent to "meld FILE1
FILE2". However, the --diff argument can be given multiple times for one invocation of meld which allows the user to automatically
initiate multiple diffs when meld starts. See examples below.
--help, -h
Print application help and usage.
--LABEL=<label>, -L <label>
Set application window title to <label>.
--version
Print application version and exit.
EXAMPLES
meld
Run meld without initiating a diff.
meld FILE1
Initiate a diff between FILE1 and the version-controlled copy of FILE1.
meld DIR1
Initiate a recursive diff between DIR1 and the version-controlled copy of DIR1.
meld FILE1 FILE2
Initiate a diff between FILE1 and FILE2.
meld FILE1 FILE2 FILE3
Initiate a 3-way diff between FILE1, FILE2, and FILE3.
meld DIR1 DIR2
Initiate a recursive diff between directory DIR1 and DIR2.
meld DIR1 DIR2 DIR3
Initiate a recursive 3-way diff between directory DIR1, DIR2, and DIR3.
meld --diff FILE1 FILE2 --diff FILE3 FILE4
Initiate a diff between FILE1 and FILE2, and a separate diff between FILE3 and FILE4.
BUGS
If you find a bug, please report it at https://bugzilla.gnome.org/buglist.cgi?product=meld or mail a description of the issue to meld-
list@gnome.org.
AUTHORS
See the AUTHORS text file in meld's source code (http://git.gnome.org/browse/meld/tree/AUTHORS).
26 Sept 2010 MELD(1)