Seeking for your assistance on how to bash 2 files and then print if the condition met.
Ex. file1.txt: file2.txt:
Condition
If Field 4 of file1.txt = Field 3 of file2.txt, the value of Field 1(canada) and Field 2(jap) of file2.txt will be put on Field 2 and Field 3 of file1.txt
Expected Output in file1.txt:
I used the code below:
it will print the common string but i don't know how to put the output in file1.txt
Thanks,
Moderator's Comments:
Using CODE tags correctly doesn't mean putting everything but "Thanks," in CODE tags.
Please put CODE tags around sample input, sample output, and code segments.
Given that fields are separated by an arbitrary number of <space> characters and fields are not aligned, how do you determine that fields 2 and 3 in file1.txt are blank rather than fields 3 and 4 or 2 and 4?
First off, this is as much as I know about Unix: its an operating system. Now, I know it goes a tad deeper than that, so first off, what exactly is Unix? Next, im freakin sick of everything microsoft crashing on me, so Id like to make Unix my OS, but I dont want to lose anything but internet... (5 Replies)
Hi I am going to migrate our datawarehouse system from HP Tru 64 Unix to the Red Hat Linux.
Inside the box, it is running around 40 cron jobs; inside each cron job, it is calling other shell script files, and the shell script files may again call other shell script files or ctl files(for... (1 Reply)
Hi,
Could someone please assist on a quick way of How to extract data from indexed files (ISAM files) maintained in an UNIX(AIX) server.The file data needs to be extracted in flat text file or CSV or excel format .
Usually we have programs in microfocus COBOL to extract data, but would like... (2 Replies)
the sorting is based on name of file,
file size
modification time stamps o f file
it should dislay the output in the following format
"." and ".." enteries should be ignored
please give some idea how to do it (1 Reply)
I need a script file for backup (zip or tar or gz) of old log files in our unix server (causing the space problem). Could you please help me to create the zip or gz files for each log files in current directory and sub-directories also?
I found one command which is to create gz file for the... (4 Replies)
Hi All,
I;m a newbie here, Seeking for your assistance regarding on how to bash the 6th and 7th fields of file2 into 2th and 3rd fields of file1 then add fields in the last line of file2 if it's match, if not they will only display the records.
Ex.
File1
a,1,2,b,c,d,e,USA... (5 Replies)
Hi Everyone,
Good Day, I'm a newbie on scripting, I would like to seek you for assistance regarding on how to bash the 1st file into 2nd file and output the match record.
Sample:
File1.csv
JuanDelaCrus<tab>USA<tab>CANADA
TwoDelaCrus<tab>SG<tab>California
File2.csv... (2 Replies)
Hi Everyone,
Seeking for your assistance on how to bash the file 1 to file 2 records and output the same records with specific field to display to file3.
Example: Imagine we have many Files and records in File 1 and the File2 is only 1 file but many records.
File1... (3 Replies)
Hii,
Could someone help me to append string to the starting of all the filenames inside a directory but it should exclude .zip files and subdirectories.
Eg.
file1: test1.log
file2: test2.log
file3 test.zip
After running the script
file1: string_test1.log
file2: string_test2.log
file3:... (4 Replies)
i use the split command to split a one terabyte backup file into 10 chunks of 100 GB each. The files are split one after the other. While the files is being split, I will like to scp the files one after the other as soon as the previous one completes, from server A to Server B. Then on server B ,... (2 Replies)