comm with a variable


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting comm with a variable
# 1  
Old 07-12-2005
Computer comm with a variable

Hello all, I have two flat files that are colon delineated and I am trying to run a compare (Solaris v8 ksh) of $1 within a script to access a mysql database based on the results. Unix is telling me that it has to have physical file names. Is there a way to run a compare using variables? This is what I have tried. Thanks in advance for your responses.

$> comm -13 $( awk -F: '{ print $1 }' testfile.lst | sort | uniq ) $( awk -F: '{ print $1 }' testfile.lst.old | sort | uniq ) > results.lst
usage: comm [-123] file1 file2

then I tried:

$> file1=$( awk -F: '{ print $1 }' $testfile.lst | sort | uniq )
$> file2=$( awk -F: '{ print $1 }' $testfile.lst.old | sort | uniq )
$> comm -13 $file1 $file2 > results.lst
usage: comm [-123] file1 file2
# 2  
Old 07-12-2005
try echoing the value of $file1 and $file2, I bet each produces more than one filename.

You can only comm two files, not two lists of files.
# 3  
Old 07-13-2005
Well I echo the results of:
file1=$( awk -F: '{ print $1 }' $testfile.lst | sort | uniq )
and it's all on one line instead of in individual rows in a single column. I guess it would be possible to massage the results, but it will probably just be easier to output it to a physical file, instead. Crummy, I like to keep things clean, instead of having tmp files all over the place that need to be deleted etc. Oh well, as long as it works right?
As always thanks for the post, I appreciate everyone's interest in helping me solve problems.
# 4  
Old 07-13-2005
it works with GNU bash(version 2.05b) on gentoo.
try:
Code:
comm -13 <(cut -d: -f1 $testfile.lst | sort | uniq) <(cut -d: -f1 $testfile.lst.old | sort | uniq) >results.lst

Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Compare files (not using comm )

i have file1 and file2 file1 ABC XYZ file2 ABC so i used the below command comm -12 file1 file2 > matched comm -23 file1 file2 > unmatched I need some other command because this is not working in the current unix version (1 Reply)
Discussion started by: ATWC
1 Replies

2. Linux

comm command help

The manual does not cover this very well. What do the following compares will do ? 1) comm -13 file1 file2: will it display what is in file2 not in file1? 2) comm -23 file1 file2: will it display what in 1 but not in 2 ? Thanks (5 Replies)
Discussion started by: mrn6430
5 Replies

3. UNIX for Dummies Questions & Answers

Need help with comm command

Hello , I am trying to get contents which are only present in a.csv ,so using comm -23 cat a.csv | sort > a.csv cat b.csv | sort > b.csv comm -23 a.csv b.csv > c.csv. a.csv SKU COUNTRY CURRENCY PRICE_LIST_TYPE LIST_PRICE_EFFECTIVE_DATE TG430ZA ZA USD DF ... (4 Replies)
Discussion started by: RaviTej
4 Replies

4. UNIX for Dummies Questions & Answers

help on COMM command please

could some one please explain with examples how comm -12 & comm -3 works. I am confused with manual page, Thankyou. (2 Replies)
Discussion started by: Ariean
2 Replies

5. UNIX for Dummies Questions & Answers

help in comm command

Hi all, I need help in comm command , I am having 2 files . I have to display the common line in the two file only onnce and i have to also display the non common line as well. tmpcut1 -- First file cat tmpcut1 smstr_303000_O_432830_... f_c2_queue_sys30.sys30 RUNNING 10 1000... (1 Reply)
Discussion started by: arunkumar_mca
1 Replies

6. Shell Programming and Scripting

problem with using comm

hi, I have two unsorted files and want to delete the lines which are common to both. file 1: S1069656304010437 S1069656304010449 S1470204501005393 S1069656304010474 S0001209208001294 S0000000012345678 S0001457507000590 S0002641707000784 S1470204501005381 S0001457507000280... (4 Replies)
Discussion started by: jathin12
4 Replies

7. Shell Programming and Scripting

comm not working

Hi Sorry if this a repeat question, I have the following two files. Both are sorted. file1 ---- CSCeb69473 CSCsg70355 CSCsj78917 CSCsj85065 CSCsl48743 CSCsl72823 CSCsl77748 file2 ---- CSCsg39295 (7 Replies)
Discussion started by: amitrajvarma
7 Replies

8. Shell Programming and Scripting

comm command

Hi I have issue with "comm " command file-1 ---- l65059 l65407 l68607 l68810 l69143 l71310 l72918 l73146 l73273 l76411 file-2 ----- (8 Replies)
Discussion started by: amitrajvarma
8 Replies

9. UNIX for Dummies Questions & Answers

Comm, command help

See my other post on sdiff .... I don't think sdiff is able to do what I want. The 'comm' command does what I need and works fine as far as the logic and results. The problem I'm having is with the output format, it outputs 3 columns of data, but because of the way it starts each line... (2 Replies)
Discussion started by: cowpoke
2 Replies

10. Shell Programming and Scripting

comm ?!

Hi, I have two large files with uid's: - 581004 File1.txt - 292675 File2.txt I want to know which uid's are in File1.txt and not in File2.txt. I have used comm -23 File1.txt File2.txt. This should do the trick i thought. But in the output i keep having uid's in File1.txt that are also in... (8 Replies)
Discussion started by: tine
8 Replies
Login or Register to Ask a Question