07-29-2005
Wired, My file is a multi-column based tab delimited file with uneven rows. It needs to be transposed to row based txt file. This is code,
bash-2.03$ more file_transpose
###file transpose, colume to row
###from unix.com/ygor, 07/29/2005
awk '{
for (f = 1; f <= NF; f++)
a[NR, f] = $f
}
NF > nf { nf = NF }
END {
for (f = 1; f <= nf; f++)
for (r = 1; r <= NR; r++)
printf a[r, f] (r==NR ? RS : FS)
}' atcc_fidler_pvs_all_markers.txt > atcc_fidler_pvs_all_markers_out.txt
The error message is,
sorgerlab-x% bash
bash-2.03$ ./file_transpose
awk: syntax error near line 3
awk: illegal statement near line 3
awk: syntax error near line 9
awk: illegal statement near line 9
Thanks for the help
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi, I've written a shell function in bash that reads letters into an array, then outputs them in one column with:
for n in "${array}"; do
echo $n
done
I was wondering if anyone knew how i would transpose the letters that are output by the for loop. Right now my output is:
aabbcc... (4 Replies)
Discussion started by: myscsa2004
4 Replies
2. Shell Programming and Scripting
Hello
I need to sort a file with data such as so it breaks on column 1 and all the data in column 2 is sorted into rows with a unique column 1:
1 5
1 6
1 7
2 3
2 4
3 7
3 0
3 9
So it comes out as:
1 5 6 7
2 3 4
3 7 0 9
I've tried many iterations of nawk but can't get it... (14 Replies)
Discussion started by: stevesmith
14 Replies
3. UNIX Desktop Questions & Answers
Hi everyone,
I have a poblem like that:
I have a file which includes data looks like:
0.65214 0.3597 1.0
0.65244 0.3502 1.0
0.65273 0.3553 1.0
0.65305 0.3544 1.0
0.65327 0.3505 1.0
0.65359 0.3516 1.0
0.65578 0.6464 1.0
0.65605 0.6453 1.0
0.65633 0.6437 1.0
0.65660 0.6488 1.0... (3 Replies)
Discussion started by: bulash
3 Replies
4. Shell Programming and Scripting
i have a file as:
1
2
3
4
5
i want output as :
1 2 3 4 5
can anybody help on this?? (14 Replies)
Discussion started by: vikas_kesarwani
14 Replies
5. Shell Programming and Scripting
Hello!
I am very new to Linux and I do not know where to begin...
I have a column with >64,000 elements (that are not in numberical order) like this:
name
2
5
9
.
.
.
64,000
I would like to transpose this column into a row that will later become the header of a very large file... (2 Replies)
Discussion started by: doobedoo
2 Replies
6. Shell Programming and Scripting
Hi All,
I have a input file say FILEA.
FILEA
--------
empid1
sal1
location1
manager1
empid2
sal2
location2
manager2
empid3
sal3
location3
manager3
.
.
. (3 Replies)
Discussion started by: 46019
3 Replies
7. Shell Programming and Scripting
Hi
I do have a big file of the following format
a b c d e f g
2 3 5 6 6 6 7
3 4 5 6 7 9 0
4 5 7 8 9 9 0
1 2 4 5 6 7 8
3 5 6 7 2 3 4
5 6 7 4 3 2 4
5 4 5 6 3 5 5
r h i j k l m
2 3 4 5 6 7 8
4 5 7 8 9 9 0
3 5 6 7 2 3 4
2 3 5 6 6 6 7
5 5 7 8 9 2 3
1 2... (7 Replies)
Discussion started by: Lucky Ali
7 Replies
8. Shell Programming and Scripting
Hi Guys,
I have file containing this kind of format below:
======== MOBILITY EVENT (G): ATTACH REJECT =========
Time : <date_time>
Node : <node>
GMM Cause : <code>
Details : <details>
Attach : <attach type>
IMSI : <imsi>
PTMSI : <ptmsi>
RA New : <ra new>
RA... (9 Replies)
Discussion started by: rymnd_12345
9 Replies
9. Shell Programming and Scripting
Hi
I have a large csv file with lines like below
Date,Status,orig,dest,in,out,when,where
2012-01-01 00:30:37,I,48,56,23,98,83,34
2012-06-17 15:00:38,I,72,43,12,65,34,12I will really appreciate if someone can help with a sed script to transpose this to
2012-01-01 00:30:37,I,orig,48... (5 Replies)
Discussion started by: kaf3773
5 Replies
10. UNIX for Dummies Questions & Answers
Hi,
How do I transpose a huge space delimited file with more than 2 million columns and about 100 rows? Thanks! (10 Replies)
Discussion started by: evelibertine
10 Replies
LEARN ABOUT FREEBSD
atf-sh
ATF-SH(1) BSD General Commands Manual ATF-SH(1)
NAME
atf-sh [-s shell] -- interpreter for shell-based test programs
SYNOPSIS
atf-sh script
DESCRIPTION
atf-sh is an interpreter that runs the test program given in script after loading the atf-sh(3) library.
atf-sh is not a real interpreter though: it is just a wrapper around the system-wide shell defined by ATF_SHELL. atf-sh executes the inter-
preter, loads the atf-sh(3) library and then runs the script. You must consider atf-sh to be a POSIX shell by default and thus should not
use any non-standard extensions.
The following options are available:
-s shell Specifies the shell to use instead of the value provided by ATF_SHELL.
ENVIRONMENT
ATF_LIBEXECDIR Overrides the builtin directory where atf-sh is located. Should not be overridden other than for testing purposes.
ATF_PKGDATADIR Overrides the builtin directory where libatf-sh.subr is located. Should not be overridden other than for testing purposes.
ATF_SHELL Path to the system shell to be used in the generated scripts. Scripts must not rely on this variable being set to select a
specific interpreter.
EXAMPLES
Scripts using atf-sh(3) should start with:
#! /usr/bin/env atf-sh
Alternatively, if you want to explicitly choose a shell interpreter, you cannot rely on env(1) to find atf-sh. Instead, you have to hardcode
the path to atf-sh in the script and then use the -s option afterwards as a single parameter:
#! /path/to/bin/atf-sh -s/bin/bash
ENVIRONMENT
ATF_SHELL Path to the system shell to be used in the generated scripts.
SEE ALSO
atf-sh(3)
BSD
September 27, 2014 BSD