I need to transpose a file.
Input file:
1/1/1111
1
2
3
4
2/2/2222
5
6
7
8
Output:
1/1/1111 1 2 3 4
2/2/2222 5 6 7 8
-
1Try: unix.stackexchange.com/search?q=transposeuser62916– user629162015-08-12 04:47:20 +00:00Commented Aug 12, 2015 at 4:47
-
1possible duplicate of Transposing rows and columnsuser62916– user629162015-08-12 04:48:58 +00:00Commented Aug 12, 2015 at 4:48
-
is it always a header line followed by 4 data lines and a blank line as separator, or is the format (e.g. the number of data lines) varying in between?FelixJN– FelixJN2015-08-12 09:05:06 +00:00Commented Aug 12, 2015 at 9:05
Add a comment
|
5 Answers
what about xargs
xargs -n5 < input_file
or awk
awk '{a=(NR%6==0)?"":a$0" ";if(NR%6==5)print a}' inp
-
Both methods assume a fixed number of entries per "column" which the OP doesn't explicitly specify.Joseph R.– Joseph R.2015-08-12 06:16:43 +00:00Commented Aug 12, 2015 at 6:16
-
yes right. Still working on that.Shravan Yadav– Shravan Yadav2015-08-12 06:20:37 +00:00Commented Aug 12, 2015 at 6:20
In perl
perl -lp00e 's/\n/ /g' your_file
Explanation
l: Remove the input record separator from the current record being processed and add the current output record separator (a newline by default) after each printed line.-p: Operate on the file record by record and print the current record after processing.-00: Means the record separator is two or more consecutive newlines-e: execute the following string as code while setting the default variable ($_) to the record currently being read from the file.s/\n/ /g: Replace every newline encountered in the current record with a space (thegmodifier ensures the replacement is "global").
-
1
perl -lp00e 's/\n/ /g'is shorter and work with old perl.cuonglm– cuonglm2015-08-12 06:03:05 +00:00Commented Aug 12, 2015 at 6:03
With sed:
$ sed -e '
:1
$!N
/\n$/{
P
d
}
s/\n/ /
t1
' <file
With awk:
awk '{ORS=" ";}; !NF{ORS="\n"};1' file
The ORS variable specifies the output record separator. If the number of fields is zero (the line is empty) then the record separator should be a newline, else a space. The 1 at the end just means a positive condition, so awk prints the whole line.
are they all the same format, i.e. 6 lines for each block? if so, paste is simplest (that is 6 dashes):
paste - - - - - - < file
If you need spaces rather than tabs, add -d' '