Sponsored Content
Top Forums Shell Programming and Scripting csv file comparison with normal file Post 302598351 by kalpeer on Tuesday 14th of February 2012 07:07:37 AM
Old 02-14-2012
MySQL

Please try with below script

Code:
#! /bin/bash
while read line
do
in1=`echo $line | awk '{print $1}'`
in2=`echo $line | awk '{print $2}'`
ou1=`grep $in1 fileB | grep $in2`
if [ -z "$ou1" ];then
echo $line
fi
done < fileD

When i execute it, below is the output
Quote:
REL_001.630.008_LieferungZu_AO-Order004266 PROD
CASS-CR099-1-2T PPMOU
CASS-CR099-1-2T PROD
Thanks,
Kalai
This User Gave Thanks to kalpeer For This Post:
 

9 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

CSV file comparison

Hi all, i have two .csv files. i need to compare those two files and if there is any difference that should be moved into third .csv file. example, org.csv and dup.csv when we compare those two files org.csv and dup.csv. if there is any change in dup.csv. it should be capture in third... (7 Replies)
Discussion started by: baskivs
7 Replies

2. UNIX for Dummies Questions & Answers

[URGENT] Determines a file is a NORMAL text file

I assign the variable name=`find . -type f | awk -vR=$num '{if (NR == R) {print; exit}}` which returns the name of a file in "$num" ordered in the folder to the variable $name. I want to use IF and determine if the file is a NORMAL text file (does not contain an extension), the command will... (1 Reply)
Discussion started by: suyaku92
1 Replies

3. UNIX for Dummies Questions & Answers

Determines a file is a NORMAL text file

I assign the variable name=`find . -type f | awk -vR=$num '{if (NR == R) {print; exit}}` which returns the name of a file in "$num" ordered in the folder to the variable $name. I want to use IF and determine if the file is a NORMAL text file (does not contain an extension), the command will... (1 Reply)
Discussion started by: suyaku92
1 Replies

4. Shell Programming and Scripting

File Comparison: Print Lines not present in another file

Hi, I have fileA.txt like this. B01B02 D0011718 B01B03 D0012540 B01B04 D0006145 B01B05 D0004815 B01B06 D0012069 B01B07 D0004064 B01B08 D0011988 B01B09 D0012071 B01B10 D0005596 B01B11 D0011351 B01B12 D0004814 B01C01 D0011804 I want to compare this against another file (fileB.txt)... (3 Replies)
Discussion started by: genehunter
3 Replies

5. 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

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)
Discussion started by: asnandhakumar
6 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

Save output of updated csv file as csv file itself

Hi, all I want to sort a csv file based on timestamp from oldest to newest and save the output as csv file itself. Here is an example of my csv file. test.csv SourceFile,DateTimeOriginal /home/intannf/foto/IMG_0739.JPG,2015:02:17 11:32:21 /home/intannf/foto/IMG_0749.JPG,2015:02:17 11:37:28... (10 Replies)
Discussion started by: refrain
10 Replies

8. Shell Programming and Scripting

Save output of updated csv file as csv file itself, part 2

Hi, I have another problem. I want to sort another csv file by the first field. result.csv SourceFile,Airspeed,GPSLatitude,GPSLongitude,Temperature,Pressure,Altitude,Roll,Pitch,Yaw /home/intannf/foto5/2015_0313_090651_219.JPG,0.,-7.77223,110.37310,30.75,996.46,148.75,180.94,182.00,63.92 ... (2 Replies)
Discussion started by: refrain
2 Replies

9. UNIX for Beginners Questions & Answers

Compare every column from one csv file to another csv file

1.csv contains following column- Empid code loc port 101 A xy 01 102 B zx 78 103 A cg 12 104 G xy 78 2.csv contains follwing data- Empid code loc port 101 A gf 01 102 B zx 78 103 C cg 32 104 ... (1 Reply)
Discussion started by: rishabh
1 Replies
MIXER(1)						  The Canonical Csound Reference						  MIXER(1)

NAME
mixer - Mixes together a number of soundfiles. . DESCRIPTION
Mixes together a number of soundfiles, starting at different times and with individual channel selection from the input files. SYNTAX
mixer [OPTIONS ... ] infile [[OPTIONS... ] infile] ... INITIALIZATION
Flags: o -A = Generate an AIFF output file. o -W = Generate an WAV output file. o -h = Generate an output file with no header. o -c = Generate 8-bit signed_char sound samples. o -a = Generate alaw sound samples. o -u = Generate ulaw sound samples. o -s = Generate short integer sound samples. o -l = Generate long (32 bit) integer sound samples. o -f = Generate floating point samples. o -F arg = Specifies the gain to be applied to the following input file. If arg is a floating point number that gain is applied uniformly to the input. Alternatively it could be a file name which specifies a breakpoint file for varying the gain for different periods. o -S integer = Indicate at which sample to start to mix in the next input file. o -T fpnum = Indicate at which time (in seconds) to start to mix in the next input file. o -1 = Mix in channel 1 from next sound file. o -2 = Mix in channel 2 from next sound file. o -3 = Mix in channel 3 from next sound file. o -4 = Mix in channel 4 from next sound file. o -^ intx inty = Mix in channel x from next sound file as channel y in the output. o -v = Verbose mode. o -R = Continually rewrite the header while writing soundfile (WAV/AIFF). o -H integer = Show a "heart-beat" to indicate progress, in style 1, 2 or 3. o -N = Alert call (usually ringing the bell) when finished. o -o fname = output file name (default: test.wav) EXAMPLES
The default values are mixer -s -otest -F 1.0 -S 0 For example mixer -F 0.96 in1.wav -S 300 -2 in2.aiff -S 300 -^4 1 in3.wav -o out.wav This creates a new sound file with a constant gain of 0.96 from in1.wav with the second channel of in2.aiff mixed in after 300 samples and channel 4 of in3.wav outpout as channel 1 after 300 samples. CREDITS
Author: John ffitch 1994 AUTHORS
Barry Vercoe MIT Media Lab Author. Dan Ellis MIT Media Lab, Cambridge Massachussetts Author. COPYRIGHT
5.10 08/01/2011 MIXER(1)
All times are GMT -4. The time now is 04:19 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy