There are no commas in the file - why do you use -F, as input field separator?
There is missing a tab in your input example in front of "acvf..." which makes $8 to $7 in the 1st line. Anyway:
Hello,
I am trying to parse a file that resembles the last three groupings into something looking like the first two lines. I've fiddled with sed and awk a bit, but can't get anything to work properly. I need them separated by some delimiter. The file is some 23,000 lines of the stuff....
... (9 Replies)
Hi,
I have a small requirement where i need to sum up a column in a text file.
Input file
66ab 000000 534385 -00000106350.00
66cd 000000 534485 -00013364511.00
66ad 000000 534485 -00000426548.00
672a 000000 534485 000000650339.82... (5 Replies)
witam
potrzebuje polecenia porownujacego koumny na podstawie n-ostatnich znakow danej linnijki tj
mam 2 koumny AiB zawierajace ciag dowolnych znakow (dlugosci w kazdej linijce mga byc rozne wiec uzycie substra odpada)
A B
ewewewabc nbgujnnabc... (3 Replies)
Dear all,
I have a file in this format (like a matrix)
- A B C .. X
A 1 4 2 .. 2
B 2 6 4 .. 8
C 3 5 5 .. 4
. . . ... .
X . . ... .
and want to convert it into a file with this format:
A A = 1
A B = 4
A C = 2
...
A X = 2
B A = 2
B B = 6
etc (2 Replies)
hello all,
i have an input file like that
A A X0
A B X1
A C X2
...
A Z Xx
B A X1
B B X3
....
Z A Xx
Z B X4
and i want to have an output like that
A B C D
A X0 X1 X2 Xy
B X1 X3 X4 (4 Replies)
Dear users,
I have this problem, this is the example:
123 (tab) A (tab) B (tab) C (tab) 456
where the (tab) is actually the \t delimiter. I need to replace the A B and C for D E and F, this is:
123 (tab) D (tab) E (tab) F (tab) 456
The thing is that my file is quite long and this... (2 Replies)
Hello all,
I have a file which is tab separated like that:
PHE_205_A TIP_127_W ARG_150_B
MET_1150_A TIP_12_W VAL_11_B
GLU_60_A TIP_130_W ARG_143_B
LEU_1033_A TIP_203_W ARG_14_B
SER_1092_A TIP_203_W
THR_1090_A TIP_203_W
SER_1092_A TIP_25_W ... (6 Replies)
Hi,
I have created a tab separated file from the following input file.
ADDRESS1 CITY STATE POSTAL COUNTRY LON LAT
32 PRINZREGENTENSTRASSE ROSENHEIM BAYERN 83022 DEU 1212182 4785699
263 VIA DANTE ALIGHIERI BARI PUGLIA 70122 ITA 1686233 4112154
30 VIA MILANO ... (1 Reply)
Hi all,
I'm trying to read a tab separated file and apply some functions on each column. I have an issue with empty column.
Exemple:
$ #cat with the sed to allow you to see my tab
$ cat foo.txt| sed 's/\t/;/g'
a;1;x
b;;yI wanted to something like that:
while read col1 col2 col3
do
... (4 Replies)
In the gawk below, I am trying to output the file tab-deliminated but don't think that is the correct syntax. Thank you :).
gawk OFS='/t' '{sub(/-+/,"",$2); ar=$0}
END{n = asort(ar)
for (i = 1; i <= n; i++)
print ar}' file (2 Replies)
Discussion started by: cmccabe
2 Replies
LEARN ABOUT ULTRIX
paste
paste(1) General Commands Manual paste(1)Name
paste - merge file data
Syntax
paste file1 file2...
paste -dlist file1 file2...
paste -s [-dlist] file1 file2...
Description
In the first two forms, concatenates corresponding lines of the given input files file1, file2, etc. It treats each file as a column or
columns of a table and pastes them together horizontally (parallel merging).
In the last form, the command combines subsequent lines of the input file (serial merging).
In all cases, lines are glued together with the tab character, or with characters from an optionally specified list. Output is to the
standard output, so it can be used as the start of a pipe, or as a filter, if - is used in place of a file name.
Options
- Used in place of any file name, to read a line from the standard input. (There is no prompting).
-dlist Replaces characters of all but last file with nontabs characters (default tab). One or more characters immediately following -d
replace the default tab as the line concatenation character. The list is used circularly, i. e. when exhausted, it is reused. In
parallel merging (i. e. no -s option), the lines from the last file are always terminated with a new-line character, not from the
list. The list may contain the special escape sequences:
(new-line), (tab), \ (backslash), and (empty string, not a null
character). Quoting may be necessary, if characters have special meaning to the shell (for example, to get one backslash, use
-d"\\" ).
Without this option, the new-line characters of each but the last file (or last line in case of the -s option) are replaced by a
tab character. This option allows replacing the tab character by one or more alternate characters (see below).
-s Merges subsequent lines rather than one from each input file. Use tab for concatenation, unless a list is specified with -d
option. Regardless of the list, the very last character of the file is forced to be a new-line.
Examples
ls | paste -d" " -
list directory in one column
ls | paste - - - -
list directory in four columns
paste -s -d"
" file
combine pairs of lines into lines
Diagnostics
line too long
Output lines are restricted to 511 characters.
too many files
Except for -s option, no more than 12 input files may be specified.
See Alsocut(1), grep(1), pr(1)paste(1)