04-17-2015
Cutting specific columns from lines
I am trying to remove columns 81-97 from a line that can be as long as 114 characters. Because a number of lines might not have under 80 characters, using the cut command following by paste could be a problem. While sed might work, is there some other utility that could do this more easily?
Thanks in advance.
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
Hi,
My file looks like
abc$%sdfhs$%sdf$%sdfaf$%
here as seen delimiter is $%...now how cas i take out second field as cut command expect delimiter as single charecter only.....is there is any other way
thanks and regards
mahabunta (9 Replies)
Discussion started by: mahabunta
9 Replies
2. Shell Programming and Scripting
Guys,
Can any one tell me how can we cut the columns and move each column in to a separate file using awk?
I have a tab delimited file as shown below,
1213 wattt werree
2345 skhasdjh aasas
I want to output this in to three files named a.txt,b.txt and c.txt
say a.txt... (3 Replies)
Discussion started by: Serious Sam
3 Replies
3. Shell Programming and Scripting
Hi Guys,
Can you help me with a sed or a csh script that will have an output from the input below. Cutting the columns starting from the end of the line and not from the start of the line?
Sample1 - The underscore character "_" is actually a space...i need to put it as underscore here coz... (2 Replies)
Discussion started by: elmer1503
2 Replies
4. Shell Programming and Scripting
Hi,
I have a file named Mani.txt. The contents are like this
cat Mani.txt
--------------------------------------------------------
Hi there how r u
My Name is Mani
Bye
------------------------------------------------------------
I want to cut the first and last lines from the file... (15 Replies)
Discussion started by: pathanjalireddy
15 Replies
5. Shell Programming and Scripting
Hi All
I have recently had to start using Unix for work and I have hit brick wall with this prob....
I have a file that goes a little something like this....
EUR;EUR;EUR:USD:USD;USD;;;EUR/USD;XAU/AUD;XAU/EUR;XAU/AUD,GBP/BOB,UAD/XAU;;;1.11;2.22;3.33;4.44;5.55;6.66;;;
is it possible to... (7 Replies)
Discussion started by: luckycharm
7 Replies
6. Shell Programming and Scripting
Hello experts,
I am new to this group and to 'SED' and 'AWK'. I have data (text file) with 5 columns (C_1-5) and 100s of lines (only 10 lines are shown below as an example). I have to find or select only the id numbers (C-1) of specific lines with '90' in the same line (of C_3) AND with '20' in... (6 Replies)
Discussion started by: kamskamu
6 Replies
7. UNIX for Dummies Questions & Answers
Hi All,
I am having a file with the delimiter '|^'.
File name:test_dlim.csv
I want to cut the first field of this using awk command.
I tried with the help of the following link:... (2 Replies)
Discussion started by: boopathyvasagam
2 Replies
8. UNIX for Dummies Questions & Answers
Hello,
I have a file which lines' words are comma separated:
aa, bb, cc, uu b, ee, ff
bb, cc, zz, ee, ss, kk
oo, bb, hh, uu a, xx, ww
tt, aa, dd, yy aa, gg
I want to sort first by second column and in case of tie by fourth column with sort command.
So the output would be:
... (4 Replies)
Discussion started by: asanchez
4 Replies
9. Shell Programming and Scripting
Hi, i have a file containing nrows and 3cols. i want to cut it in specific length and save output to individual files.
1 2 3
4 5 6
5 8 9
10 11 12
13 14 15
16 17 18
i need to cut the file say every 2 rows and save it in individual file.
01.dat contains
1 2 3
4 5 6
02.dat
7 8 9... (10 Replies)
Discussion started by: ida1215
10 Replies
10. UNIX for Dummies Questions & Answers
Hi
I have a file which is tab-delimited. Now, I'd like to print the lines which have "chr6" string in both first and second columns. Could anybody help? (3 Replies)
Discussion started by: a_bahreini
3 Replies
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 Also
cut(1), grep(1), pr(1)
paste(1)