Compare two and write updated output in third file
Hi Linux Experts.
I have a requirement where i need to update the thousands of table definitions to extend the column length and character set therefore i am looking for some sort of linux script which i can use to update the length and chacterset.
I have two files
In first file i have 7 below columns.
where as in Second file i have ddls of all the tables.
Now first i want to compare the Databasename.TableName from first file with the DatabaseName.TableName in second file if there is a match in second file then update the column parameters i.e., 'ColumnName ColumnLength ColumnCharacterSet' with 'ColumnName Ext_ColumnLength Changed_ColumnCharacterSet'
Sample files and required outout is given below.
File2
Required OutPut
Thanks for your help.
Moderator's Comments:
Do not put you entire post in HTML tags, instead use CODE tags for code and data samples, but leave the rest of your text as is
Last edited by Scrutinizer; 08-07-2015 at 02:35 AM..
Reason: Removed HTML text, added specific CODE tags
hi,
I have a log file , which is appending with current data
i need the extarct which is updated from last 30 minutes
the format of the date is Jun 18, 2008 8:59:18 AM
how can i subtract 30 mins from the current date
thanks
Tarun. (5 Replies)
hi,
i am new to this site.
i want to write a script to compare the file size of the files in the current dir with the files in the previous directory.
the files name will be same, but the filename format will be as xyzddddyymm.txt. the files will arrive with the month end date(i want to... (5 Replies)
hi all,
when i try to start an applicationserver
for an example:
./kStart.sh > out.txt
so kStart.sh script will start the application server and write the details to out.txt
but in mycase... it is writing to out.txt and as well it is showing in the prompt also...
I want only the... (2 Replies)
Hi Friends,
I'm a great fan of this forum... it has helped me tone my skills in shell scripting. I have a challenge here, which I'm sure you guys would help me in achieving...
File A has a list of job ids and I need to compare this with the File B (*.log) and File C (extend *.log) and copy... (6 Replies)
Hi friends...I have 2 files, file1.txt and reference.txt
I could able to find difference using diff and following command
awk 'NR == FNR { A=1; next } !A' reference.txt file1.txt
above command listing data which is not in reference.txt
12.12 87
11.95 88
11.83 89
12.55 84... (12 Replies)
Hi,
I need to compare 2 text files with around 60000 rows and 1 column. I need to compare these and write the mismatch data to 3rd file.
File1 - file2 = file3
wc -l file1.txt
58112
wc -l file2.txt
55260
head -5 file1.txt
101214200123
101214700300
101250030067
101214100500... (10 Replies)
Hi Guys,
I wanted to compare a delimited file and positional file, for a particular key files and if it matches then append the positional file with some data.
Example:
Delimited File
--------------
Byer;Amy;NONE1;A5218257;E5218257
Byer;Amy;NONE1;A5218260;E5218260
Positional File... (3 Replies)
Shell script logic
Hi
I have 2 input files like with file 1 content as (file1)
"BRGTEST-242" a.txt "BRGTEST-240" a.txt "BRGTEST-219" e.txt
File 2 contents as fle(2)
"BRGTEST-244" a.txt "BRGTEST-244" b.txt "BRGTEST-231" c.txt "BRGTEST-231" d.txt "BRGTEST-221" e.txt
I want to get... (22 Replies)