Can you please explain more...because, from the data you shown above, how do you get the result you provided for identical cols 1 & 2.
Anyways, if you want unique col 1 & 2
I think maybe I did not describe well my problem. I don't want unique Cols1 and 2. I need to remove all unique Col 2. (regardless of what is in Col 1.), In the example I provided, you can see that the Col 2 that remains are duplicates while the Col 2 that were unique are discarded.
Hi folks - hope you are all well.
I am trying to perform some pre-processing on a data file, to make sure it is in a valid format before performing a data upload.
Each row of data in the file should consist of 10 comma delimited fields.
Can anyone advise me of a sed/awk command that might... (2 Replies)
Hi all! Im wondering if its possible to remove all lines between two lines. Im working with a document like this:
data1
data2
<Remove>
data3
data4
</Remove>
data5
data6
I need it to end up like this if that possible:
data1
data2
data5
data6
There are multiple instances of... (2 Replies)
Hi All,
I have a very huge file (4GB) which has duplicate lines. I want to delete duplicate lines leaving unique lines. Sort, uniq, awk '!x++' are not working as its running out of buffer space.
I dont know if this works : I want to read each line of the File in a For Loop, and want to... (16 Replies)
hello all,
I have an input file with four columns like this with a lot of lines
and for example, line 1 and line 5 match because the first 4 characters match and the fourth column matches too. I want to keep the line that has the lowest number in the third column. So I discard line 5.... (5 Replies)
I would like to print unique lines without sort or unique. Unfortunately the server I am working on does not have sort or unique. I have not been able to contact the administrator of the server to ask him to add it for several weeks. (7 Replies)
Hi Every one, my requirement is to remove the null columns in line, comma delimiter used
For example,
A,11,20,30,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
B1,,,,,, gem,plum,kite,,,,gud,bad,,,,,,,,,,,,,
B2,kiing,kong,height,,,,,,,,,,,,,,,,,,,,,,,,,rak,,,,,,,,,,,,,
B1,,,,,,... (9 Replies)
Hello,
I would like to ask for help with csh script.
An example of an input in .txt file is below, the number of lines varies from file to file and I have 2 or 3 columns with values. I would like to read all the values (probably one by one) and set them to independent unique variables that... (7 Replies)
Discussion started by: FMMOLA
7 Replies
LEARN ABOUT BSD
col
COL(1) General Commands Manual COL(1)NAME
col - filter reverse line feeds
SYNOPSIS
col [ -bfh ]
DESCRIPTION
Col reads the standard input and writes the standard output. It performs the line overlays implied by reverse line feeds (ESC-7 in ASCII)
and by forward and reverse half line feeds (ESC-9 and ESC-8). Col is particularly useful for filtering multicolumn output made with the
`.rt' command of nroff and output resulting from use of the tbl(1) preprocessor.
Although col accepts half line motions in its input, it normally does not emit them on output. Instead, text that would appear between
lines is moved to the next lower full line boundary. This treatment can be suppressed by the -f (fine) option; in this case the output
from col may contain forward half line feeds (ESC-9), but will still never contain either kind of reverse line motion.
If the -b option is given, col assumes that the output device in use is not capable of backspacing. In this case, if several characters
are to appear in the same place, only the last one read will be taken.
The control characters SO (ASCII code 017), and SI (016) are assumed to start and end text in an alternate character set. The character
set (primary or alternate) associated with each printing character read is remembered; on output, SO and SI characters are generated where
necessary to maintain the correct treatment of each character.
If the -h option is given, col converts white space to tabs to shorten printing time.
All control characters are removed from the input except space, backspace, tab, return, newline, ESC (033) followed by one of 7, 8, 9, SI,
SO, and VT (013). This last character is an alternate form of full reverse line feed, for compatibility with some other hardware conven-
tions. All other non-printing characters are ignored.
SEE ALSO troff(1), tbl(1)BUGS
Can't back up more than 128 lines.
No more than 800 characters, including backspaces, on a line.
7th Edition May 16, 1986 COL(1)