Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Match list of strings in File A and compare with File B, C and write to a output file in CSV format
Top Forums Shell Programming and Scripting Match list of strings in File A and compare with File B, C and write to a output file in CSV format Post 302713313 by asnandhakumar on Thursday 11th of October 2012 11:12:12 AM
Old 10-11-2012
File A is joblist.txt
File B is job.log
File C would be an extended log of job.log, which is quite huge for me to upload here.

I have tried the below script and only the list from joblist gets stored in the output file.
Code:
awk '
FILENAME=="joblist.txt" {
for(i=1;i<=NF;i++ ) {Keys[$i]++}
}
FILENAME=="job.log" {
found=0
for(i=1;i<=NF;i++)
{ if(Keys[$i]>0) {found++; }}
if (found != 2 ) {
print $0; found = 0; break;
}
}
' joblist.txt job.log >>diff.csv

---------- Post updated 10-11-12 at 11:12 AM ---------- Previous update was 10-10-12 at 01:05 PM ----------

hello Friends, Can you someone respond to this request.
Last edited by Franklin52; 10-11-2012 at 05:18 AM.. Reason: Please use code tags for data and code samples
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Need to compare two csv files values and write into another csv file

Hi all, Am new to scripting. So i just need your ideas to help me out. Here goes my requirement. I have two csv files 1.csv 2.csv abc,1.24 abc,1 def,2.13 def,1 I need to compare the first column of 1.csv with 2.csv and if matches then need to compare... (2 Replies)
Discussion started by: chinnahyd
2 Replies

2. Shell Programming and Scripting

format output in csv file

I am sending the output of a file to .csv file. The output should look like this: Total Customers Processed:,8 Total Customers Skipped:,0 Total Customers Added:,8 Total Customers Changed:,0 Total Policies Deleted:,0 Total Policies Failed:,0 total:,8 Now i want this output in... (1 Reply)
Discussion started by: Prashant Jain
1 Replies

3. Shell Programming and Scripting

extract strings from file and display in csv format

Hello All, I have a file whose data looks something like this I want to extract just the id, name and city fields in a csv format and sort them by id. Output should look like this. 1,psi,zzz 2,beta,pqr 3,theta,xyz 4,alpha,abc 5,gamma,jkl (12 Replies)
Discussion started by: grajp002
12 Replies

4. Shell Programming and Scripting

Csv format output file using scirpt

Hi All, I get the test result file daily after running the main test script. from the resultfile, need to fetch only server info and status and put them in tabular format in a file and as well in CSV format output file. I tried using awk command but am not able to put them in tabluar... (6 Replies)
Discussion started by: Optimus81
6 Replies

5. Shell Programming and Scripting

Compare 2 text file with 1 column in each file and write mismatch data to 3rd file

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)
Discussion started by: Divya Nochiyil
10 Replies

6. Shell Programming and Scripting

Compare 2 files of csv file and match column data and create a new csv file of them

Hi, I am newbie in shell script. I need your help to solve my problem. Firstly, I have 2 files of csv and i want to compare of the contents then the output will be written in a new csv file. File1: SourceFile,DateTimeOriginal /home/intannf/foto/IMG_0713.JPG,2015:02:17 11:14:07... (8 Replies)
Discussion started by: refrain
8 Replies

7. Shell Programming and Scripting

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... (1 Reply)
Discussion started by: Black-Linux
1 Replies

8. Shell Programming and Scripting

How to parse this file using awk and output in CSV format?

My source file looks like this: Cust-Number = "101" Cust-Name="Joe" Cust-Town="London" Cust-hobby="tennis" Cust-purchase="200" Cust-Number = "102" Cust-Name="Mary" Cust-Town="Newyork" Cust-hobby="reading" Cust-purchase="125" Now I want to parse this file (leaving out hobby) and... (10 Replies)
Discussion started by: Balav
10 Replies

9. UNIX for Beginners Questions & Answers

Use strings from nth field from one file to match strings in entire line in another file, awk

I cannot seem to get what should be a simple awk one-liner to work correctly and cannot figure out why. I would like to use patterns from a specific field in one file as regex to search for matching strings in the entire line ($0) of another file. I would like to output the lines of File2 which... (1 Reply)
Discussion started by: jvoot
1 Replies

10. Programming

Python or Shell script to Grep strings from input file and output in csv format

Hi Experts, I am writing a python script to grep string from file and display output in csv file as in attached screenshot https://drive.google.com/file/d/1gfUUdfmQma33tz65NskThYDhkZUGQO0H/view Input file(result_EPFT_config_device) Below is the python script i have prepared as of... (1 Reply)
Discussion started by: as7951
1 Replies

LEARN ABOUT DEBIAN

ns_job

ns_job(3aolserver)					    AOLserver Built-In Commands 					ns_job(3aolserver)

__________________________________________________________________________________________________________________________________________________

NAME

       ns_job - commands

SYNOPSIS

       ns_job option ?arg arg ...?

       ns_job create ?-desc description? queueId ?maxthreads?

       ns_job queue ?-detached? queueId  script

       ns_job wait ?-timeout seconds:microseconds? queueId  jobId

       ns_job waitany ?-timeout seconds:microseconds? queueId

       ns_job cancel queueId jobId

       ns_job delete queueId

       ns_job jobs queueId

       ns_job queues

       ns_job threadlist

       ns_job queuelist

       ns_job joblist

       ns_job genid

_________________________________________________________________

DESCRIPTION

       ns_job manages a thread pool and a set of named "queues". Queues have a max number of threads and when the current number of running thread
       reaches "max" then jobs are queued.

       New threads are created when there are less than  maxthread  number of idle threads.

OPTIONS

       create

	      create ?-desc description? queueId ?maxthreads?

	      Create a new job queue called queueId. If maxthreads is not specified, then the default of 4 is used.

       queue

	      queue ?-detached? queueId script

	      Add a new job to the queue. If there are less than maxthreads current running then the job will be started. If there are	maxthreads
	      currently running then this new job will be queued.

	      If detached is true, then the job will be cleaned up when it completes; no wait will be necessary.

	      The new job's ID is returned.

       wait

	      wait ?-timeout seconds:microseconds? queueId jobId

	      Wait for the specified queued or running job to finish. wait returns the results of the script.

	      An error is thrown if the specified timeout period is reached.

       waitany

	      waitany ?-timeout seconds:microseconds? queueId

	      Wait for any job on the queue complete.

	      An error is thrown if the specified timeout period is reached.

       cancel

	      cancel queueId jobId

	      Remove  the  specified job from the queue. If the job is currently running, then the job will be removed from the queue when it com-
	      pletes.

	      1 (true)	is returned if the job is currently running and can not be cancelled.

       delete

	      delete queueId

	      Request that the specified queue be deleted. The queue will only be deleted when all jobs are removed.

       jobs

	      jobs queueId

	      Return a list of the job IDs.

       queues

	      Returns a list of the queues IDs.

       threadlist

	      Returns a list of the thread pool's fields.

	      maxthreads
		     Max number of threads for all the queues in the thread pool.

	      numthreads
		     Number of allocated threads.

	      numidle
		     Number of currently idle threads.

	      req
		     stop
			    The thread pools is being stopped. This probably means that the server is shutting down.

       queuelist

	      Returns a list of the queues. A queue has the following fields:

	      name
		     Name of the queue.

	      desc
		     Description of the queue.

	      maxthreads
		     Max number of threads to run for this queue.

	      numrunning
		     Number of currently running jobs in this queue.

	      REQ
		     delete
			    Someone requested this queue be deleted. Queue will not be deleted until all the jobs on the queue are removed.

       joblist

	      Returns a list the jobs in the specified queue. A job has the following fields:

	      id
		     Job's ID

	      state
		     scheduled
			    The job is schedule to run.
		     running
			    The job is currently running.
		     done
			    The job is has completed.

	      results
		     If the job has completed, then this field will contain the results. If the job is running or scheduled to run, then this will
		     contain the script.

	      code
		     When the job is done, this will contain the return code.
			    Codes
				    TCL_OK
				    TCL_ERROR
				    TCL_RETURN
				    TCL_BREAK
				    TCL_CONTINUE

	      TYPE
		      nondetached
		      detached

	      REQ
		      none
		      wait
		      cancel

       genid

	      Generate a new unique ID. This new ID can be used as the queue ID without conflicting with any other queue ID.

BUGS

SEE ALSO

       nsd(1), info(n)

KEYWORDS

       ns_job

AOLserver								4.0							ns_job(3aolserver)
All times are GMT -4. The time now is 11:32 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy