06-29-2015
This is not really what I would call a simple transposing function (flipping columns to rows and vice-versa) but you are looking to tabulate the input.
You could use arrays if you can be certain of the rows & columns you want to look for. You can then read the input and set a flag in the appropriate row/column of the array depending on what you read. Finally, you display the table based on the array values, just looping round them.
What have you tried so far?
What are you comfortable using/supporting? For example ksh only, perl, awk, sed, C?
For "plate" do you mean the column marked "Assay"?
Can you logically define the process you want to follow? If you can then with refinement we can work out the code you need.
Sorry for the questions, but I would prefer to get a good solution that you can maintain in future rather than just going "Ta-da!" and you have no idea how it works and I have no idea if it meets your needs when you have data that is larger than the sample.
Robin
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 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
.....
..... (5 Replies)
Discussion started by: 46019
5 Replies
4. 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
5. 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
6. 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
7. 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
8. 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
9. 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
10. 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
COLUMN(1) BSD General Commands Manual COLUMN(1)
NAME
column -- columnate lists
SYNOPSIS
column [-tx] [-c columns] [-s sep] [file ...]
DESCRIPTION
The column utility formats its input into multiple columns. Rows are filled before columns. Input is taken from file operands, or, by
default, from the standard input. Empty lines are ignored.
The options are as follows:
-c Output is formatted for a display columns wide.
-s Specify a set of characters to be used to delimit columns for the -t option.
-t Determine the number of columns the input contains and create a table. Columns are delimited with whitespace, by default, or with
the characters supplied using the -s option. Useful for pretty-printing displays.
-x Fill columns before filling rows.
ENVIRONMENT
The COLUMNS, LANG, LC_ALL and LC_CTYPE environment variables affect the execution of column as described in environ(7).
EXIT STATUS
The column utility exits 0 on success, and >0 if an error occurs.
EXAMPLES
(printf "PERM LINKS OWNER GROUP SIZE MONTH DAY " ;
printf "HH:MM/YEAR NAME
" ;
ls -l | sed 1d) | column -t
SEE ALSO
colrm(1), ls(1), paste(1), sort(1)
HISTORY
The column command appeared in 4.3BSD-Reno.
BUGS
Input lines are limited to LINE_MAX (2048) bytes in length.
BSD
July 29, 2004 BSD