08-22-2008
perl script file manipulation
Please let me know.. How to manipulate the data from two files..?
I have two files, file1 has two columns one is variable and second is description. file2 has five columns first column is variable and last one is description..Appreciate the help
I need to overwrite the description from file1 to file2 as per the variables..
e.g. file1
var1 <correct description>
var2 <correct description>
abc1 <correct description>
bcd3 <correct description>
.....
file2
var1 cl1 cl2 cl3 <wrong description1>
var1 b1 b3 b4 <wrong description3>
abc1 1 2 3 4 <wrong description1>
abc2 1 2 3 4 <wrong description7>
unknon m n po e <wrong description7>
unknon sf dvd dvd <wrong description7>
bcd3 p q r t <wrong description7
bcd3 n mb c <wrong description1>
......
result would be in file2
var1 cl1 cl2 cl3
var1 b1 b3 b4 <correct description>
abc1 1 2 3 4
abc2 1 2 3 4 <correct description>
unknon m n po e
unknon sf dvd dvd <wrong description7>
bcd3 p q r t <wrong description7
bcd3 n mb c <wrong description1>
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hello guys..
I have the following question.
lets have that i have the following variable:
$field=werfiurd383nd93bc93 c93 d93 d9e3 ddd
or
array=werfiurd383nd93bc93 c93 d93 d9e3 ddd
what i would like to do is to store the first 4 characters of gthe aboce variable in variable... (1 Reply)
Discussion started by: chriss_58
1 Replies
2. Shell Programming and Scripting
Hi all,
Supposing the following string:
XXXXXXXXXXNEAXXXXXX
How can I check if this string has the substring NEA?
Best regards
Chris (3 Replies)
Discussion started by: chriss_58
3 Replies
3. Shell Programming and Scripting
Hi,
Please advise me how to perform checking in perl on the following input below.
The output criteria will be
1. field 1 will begin as 913354744 for each as example
2. field 4 must be unique.
3. field 7 is showing dd/mm/yyyy, but it require checking if unixtime should covert to... (5 Replies)
Discussion started by: rauphelhunter
5 Replies
4. Shell Programming and Scripting
hi all,
i am trying to append the output of a find command (for different paths)in an array as below...
my $res_array;
$i=0;
$dir="/orn/ops/regs";
foreach $block("am","xb"){
$bdir="$dir/$block";
$res_array=`find $bdir ! -user mainuser -printf \"\%u \%h\\n\"`;
$i++;
}
i... (6 Replies)
Discussion started by: saapa
6 Replies
5. Shell Programming and Scripting
Hello All,
I have been working on a great script to remotely gather server info and store it in a .txt that can be imported to .xls
I have been reading the hostnames that are in the /.shh/known_hosts file so I don't have to mess with passing a password - via ssh (not easy to do , by the... (1 Reply)
Discussion started by: dfezz1
1 Replies
6. Shell Programming and Scripting
I'm in need of help for a project that I'm working on. I believe Perl would be the best way of handling the string manipulation, however, I've barely used perl, and I'm used to BASH scripting. Another note is, this project is in a Windows environment, so I can use Perl, but I do not have shell... (1 Reply)
Discussion started by: drewrockshard
1 Replies
7. Shell Programming and Scripting
Hello,
I have mysql binary file which logs all the database queries and i to insert all queries log in to database. First i coverted binary file to text file. and start playing with it. Text file contains following queries, some samples are,
SET INSERT_ID=1;
INSERT INTO test... (0 Replies)
Discussion started by: mirfan
0 Replies
8. Shell Programming and Scripting
I don't know if this is a big issue or not, but I'm having difficulties. I apoligize for the upcoming essay :o.
I'm writing a script, similar to a paint program that edits images, but in the form of ANSI block characters. The program so far is working. I managed to save the image into a file,... (14 Replies)
Discussion started by: tinman47
14 Replies
9. UNIX for Dummies Questions & Answers
I am a UNIX newbee . I have been doing some reading lately but really need help with an an urgent requirement.After almost two days of googling I end up with 0 luck. Hopefully a guru on here will be able to help me out. Here is my requirement:
I have 20 files in a directory with detail records... (6 Replies)
Discussion started by: jeyd
6 Replies
10. Shell Programming and Scripting
Hi,
I have a file about 100 lines. Each line is about 2000 characters (each line is fixed length). In middle of each line is following constant value
0000040029892586
Now, I want to go through each line and increment by 1.
So, line 1 will have 586
line 2 will have 587, line 3 will have... (4 Replies)
Discussion started by: jakSun8
4 Replies
DIFF(1) General Commands Manual DIFF(1)
NAME
diff - differential file comparator
SYNOPSIS
diff [ -efbh ] file1 file2
DESCRIPTION
Diff tells what lines must be changed in two files to bring them into agreement. If file1 (file2) is `-', the standard input is used. If
file1 (file2) is a directory, then a file in that directory whose file-name is the same as the file-name of file2 (file1) is used. The
normal output contains lines of these forms:
n1 a n3,n4
n1,n2 d n3
n1,n2 c n3,n4
These lines resemble ed commands to convert file1 into file2. The numbers after the letters pertain to file2. In fact, by exchanging `a'
for `d' and reading backward one may ascertain equally how to convert file2 into file1. As in ed, identical pairs where n1 = n2 or n3 = n4
are abbreviated as a single number.
Following each of these lines come all the lines that are affected in the first file flagged by `<', then all the lines that are affected
in the second file flagged by `>'.
The -b option causes trailing blanks (spaces and tabs) to be ignored and other strings of blanks to compare equal.
The -e option produces a script of a, c and d commands for the editor ed, which will recreate file2 from file1. The -f option produces a
similar script, not useful with ed, in the opposite order. In connection with -e, the following shell program may help maintain multiple
versions of a file. Only an ancestral file ($1) and a chain of version-to-version ed scripts ($2,$3,...) made by diff need be on hand. A
`latest version' appears on the standard output.
(shift; cat $*; echo '1,$p') | ed - $1
Except in rare circumstances, diff finds a smallest sufficient set of file differences.
Option -h does a fast, half-hearted job. It works only when changed stretches are short and well separated, but does work on files of
unlimited length. Options -e and -f are unavailable with -h.
FILES
/tmp/d?????
/usr/lib/diffh for -h
SEE ALSO
cmp(1), comm(1), ed(1)
DIAGNOSTICS
Exit status is 0 for no differences, 1 for some, 2 for trouble.
BUGS
Editing scripts produced under the -e or -f option are naive about creating lines consisting of a single `.'.
DIFF(1)