Search results for query: *

I have : 5 columns in file 1 11 columns in file 2 file 1 has more lines than file 2 cols 1, 2, 4, match info between the two files based on the critieria of matching cols i want to extract cols 3,5 from file 1 and add them with file 2 I think this code is close to what im looking to do awk...

I have : 5 columns in file 1 11 columns in file 2 file 1 has more lines than file 2 cols 1, 2, 4, match info between the two files based on the critieria of matching cols i want to extract cols 3,5 from file 1 and add them with file 2 I think this code is close to what im looking to do awk...

I have 2 columns from sql extract and for each row either column has values in each row. I need to be able to combine the columns so there are no blank values. example column1 column2 column3 column 4column 5 blank abcdef 123 john lola ghijkl blank 456 don sue mnop blank 789 cliff jane blank...

I'm trying to use 1 script for muliple boxes with same username to backup crontabs Her is what I have and the problem is the hostname variable wont output to the name of the file #!/bin/ksh CHOST=$HOSTNAME CDATE=`date "+%Y%m%d"` /usr/bin/crontab -l >...

How can I combine query 1 and query 2 into one big query? query 1: SELECT name, crdate from sysobjects where type='U' and name like '%19303%' ORDER BY crdate desc result 1: name crdate 11608#M0DAA2D58_TMP 2010-01-06 18:15:23.606 11608#M27042D58_TMP 2010-01-06 18:15:23.606...

i have 2 files and i want to compare i currently cat the files and awk print $1, $2 and doing if file1=file2 then fail, else exit 0 what i want to do is compare values, with column 1 being a reference i want to compare line by line and then do: the values not matching is a success the values...

how do i modify the synatx for max date minus 1 select MAX (date_col) from table_a

Hi Im stuck in the following issue: I have a directory where correct file names are: *_0.txt *_1.txt Then through a publisher some incorrect file names are produced: *_12.txt *_0123.txt *_04321.txt all files that are incorrect above need to be replaced with ending in *_1.txt therefore...

2 java jobs being called in ksh script and error trapping wont work when one or both fails Couple additonal points: - this use to work on HP but doesnt after we migrated to solaris - this type of error trapping works in solaris for other scripts calling one job - we cannot make the jobs run...

Im trying to execute a shell script in crontab, however the script needs an option to be specified to work. I dont know how to get this to work. - I have called the shell script with option as entry in the crontab - I have nested the shell script with option in another shell sciprt and called...

I'm trying to make sure trailer row of a file matches the count of delimited character in the file. The command "cut -f 2 -d, TEMPFILE | grep CHARACTER1 | wc -l" output is 38147 The command "cut -f 2 -d, TEMPFILE | grep CHARACTER2 | wc -l" output is 64966 Here is the output for tailing the...