01-24-2008
Script that extract some lines from a file lookin into another
I want a ksh script that parse two files (text files, actually my original files are .xls) - input data:
- one file file1 containig lines separated by spaces (or other delimiter)
- 2nd one file2 contain only one numerical value in a line (for simplicity but it might of the same form as the 1st)
- I know the 2nd value in file1 is also numerical and some of them can be found in file2
Output data:
The result should be a file that contains from the file1 only those lines whose 2nd field cannot be found in any line of file1.
I know this is easy, but I am too tired after a full hard working day so an expert can fix it in a minute.
I think it can be done in one line (complex?) command either....
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
hello, hope you can help me:
ive got a file called archivos
The content or structure of this file is
./chu0/filechu
./chu1/filechu
I extract each line from this file manually and redirect to a file, and it Works fine, so the command line is:
awk ‘/chu0/ {print $0}' < archivos >... (8 Replies)
Discussion started by: alexcol
8 Replies
2. Shell Programming and Scripting
hi
i have a file which is very large . it contains lines in the format below:
seed url, html url
....
...
seed url, html url
i have sort it already.
2010ÄÏ·ÇÊÀ½ç±*_¾º¼¼·ç±©_ÐÂÀËÍø ÕżªÁúרÀ¸£ºÊÀ½ç±*24ÄêµÄ»ØÒä ÆÚÅÎÑÇÖÞδÀ´ÍŽá_2010ÄÏ·ÇÊÀ½ç±*_¾º¼¼·ç±©_ÐÂÀËÍø
2010ÄÏ·ÇÊÀ½ç±*_¾º¼¼·ç±©_ÐÂÀËÍø ¹úÃ×Óë±´ÄáÌØ˹´ï³ÉÐ*Òé... (6 Replies)
Discussion started by: rainboisterous
6 Replies
3. Shell Programming and Scripting
Hi
I have a text file with the following information:
# List 1 (first header)
test 1
test 2
test 3
...
# Trials (second header)
round 1
run 5
...
and so on
I want to create a script, which based on some criterias with return only the list of lines between the header. I... (9 Replies)
Discussion started by: nimo
9 Replies
4. Shell Programming and Scripting
hi,
i have two files.
file1.sh
echo "unix"
echo "linux"
file2.sh
echo "unix linux forums"
now the output i need is
$./file2.sh
unix linux forums (3 Replies)
Discussion started by: snreddy_gopu
3 Replies
5. Shell Programming and Scripting
Hi all,
I have a file with many records with information as given below
ID A16L2_HUMAN Reviewed; 619 AA.
AC Q8NAA4; A5PL30; B2RPK5; Q658V4; Q6PID3; Q8NBG0;
DT 20-MAY-2008, integrated into UniProtKB/Swiss-Prot.
DT 20-MAY-2008, sequence version 2.
DT ... (1 Reply)
Discussion started by: kaav06
1 Replies
6. Shell Programming and Scripting
Hi guys
I have a several thousands line file in the following format:
n817
--------------------------------------------------
n842
--------------------------------------------------
n877
--------------------------------------------------
n513
/bb/data/rmt2db.lrl:JBSKDB 31915 75... (4 Replies)
Discussion started by: aoussenko
4 Replies
7. Shell Programming and Scripting
Hello,
I need a utility script or command that will extract the following lines from a file based on a 'word' contain in a line. For example my file contains lot of lines.
So if i pass 1800182 to the script/command it should return everything between 1st RequestNetRates tag before it and 1st... (4 Replies)
Discussion started by: jakSun8
4 Replies
8. Shell Programming and Scripting
Hi
I need some lines of text from input file using keywords.
Inputfile
IP IS 10.238.52.65
pun-ras-bng-mhs-01#context bsnl.in
Card Status : 1:0, 2:1, 3:1, 4:1, 5:0, 6:0, 7:0,
8:0, 9:1, 10:0, 11:0, 12:0, 13:0, 14:1,
Max Circuits: 1: 0, 2: 32768, ... (5 Replies)
Discussion started by: surender reddy
5 Replies
9. Shell Programming and Scripting
Hi all;
Here is my file which contains a list of files (recent versions of files are in red). This file is dynamic, files versions can change at any time (versions can increment)
filename
-------------------------------------------------------
... (8 Replies)
Discussion started by: chercheur111
8 Replies
10. UNIX for Beginners Questions & Answers
Dears experts
i have UNIX file that contain 4 million lines , i need to extract all lines that have entiries saved in VI file , i have below comand but it takes tooooo long time :
for i in `cat file1.csv`; do cat dump | grep -i $i >> file2.csv; done
where :
file1.csv = VI file that... (12 Replies)
Discussion started by: is2_egypt
12 Replies
DIFF3(1) General Commands Manual DIFF3(1)
NAME
diff3 - 3-way differential file comparison
SYNOPSIS
diff3 [ -exEX3 ] file1 file2 file3
DESCRIPTION
Diff3 compares three versions of a file, and publishes disagreeing ranges of text flagged with these codes:
==== all three files differ
====1 file1 is different
====2 file2 is different
====3 file3 is different
The type of change suffered in converting a given range of a given file to some other is indicated in one of these ways:
f : n1 a Text is to be appended after line number n1 in file f, where f = 1, 2, or 3.
f : n1 , n2 c Text is to be changed in the range line n1 to line n2. If n1 = n2, the range may be abbreviated to n1.
The original contents of the range follows immediately after a c indication. When the contents of two files are identical, the contents of
the lower-numbered file is suppressed.
Under the -e option, diff3 publishes a script for the editor ed that will incorporate into file1 all changes between file2 and file3, i.e.
the changes that normally would be flagged ==== and ====3. Option -x (-3) produces a script to incorporate only changes flagged ====
(====3). The following command will apply the resulting script to `file1'.
(cat script; echo '1,$p') | ed - file1
The -E and -X are similar to -e and -x, respectively, but treat overlapping changes (i.e., changes that would be flagged with ==== in the
normal listing) differently. The overlapping lines from both files will be inserted by the edit script, bracketed by "<<<<<<" and ">>>>>>"
lines.
For example, suppose lines 7-8 are changed in both file1 and file2. Applying the edit script generated by the command
"diff3 -E file1 file2 file3"
to file1 results in the file:
lines 1-6
of file1
<<<<<<< file1
lines 7-8
of file1
=======
lines 7-8
of file3
>>>>>>> file3
rest of file1
The -E option is used by RCS merge(1) to insure that overlapping changes in the merged files are preserved and brought to someone's atten-
tion.
FILES
/tmp/d3?????
/usr/libexec/diff3
SEE ALSO
diff(1)
BUGS
Text lines that consist of a single `.' will defeat -e.
7th Edition October 21, 1996 DIFF3(1)