String compare

sbasetty · #1 (**permalink**) 01-26-2007

Hi Friends,

Can anyone help me with comparing the records in twofiles,

I have two files (csv)

FILE1:

1023,SMITH JAMES , (203) 789-1249
1023,HARRY POTTER , (213) 789-1249
1023,JONES D, (903) 789-1249

FILE1:

1023,SMITH ,2037891249
1023,HARRY , 2137891249
1023,JONES, 7037891249

it should return only one row i.e 1023,JONES, 7037891249 as they are different,It has to supress the "(" chareacters and blank ones.

Thanks in advance for your help.

S

(203) 789-1249 and 2037891249,
I have to compare these

ghostdog74 · #2 (**permalink**) 01-26-2007

here's an idea to start with:

Code:

[root@localhost test]# echo "1023,SMITH , (203) 789-1249" |sed 's/[-() ]//g'
1023,SMITH,2037891249

All ( , ) , - and spaces are stripped. you can do this for both files and then compare them.

Code:

[root@localhost test]# sed -i 's/[-() ]//g' file
[root@localhost test]# sed -i 's/[-() ]//g' file2
[root@localhost test]# diff file file2
3c3
< 1023,JONES,9037891249
---
> 1023,JONES,7037891249

radoulov · #3 (**permalink**) 01-27-2007

If I understand correctly:

Code:

awk 'NR==FNR{gsub(/[ \(\)-]/,"");x[$0];next}
{gsub(/ /,"")}!($0 in x)' file1 file2

Use nawk on Solaris.

nervous · #4 (**permalink**) 01-27-2007

Quote:

Originally Posted by radoulov

If I understand correctly:

Code:

awk 'NR==FNR{gsub(/[ \(\)-]/,"");x[$0];next}
{gsub(/ /,"")}!($0 in x)' file1 file2

Use nawk on Solaris.

Can you please explain your code.

Thanks in advance.
An awk student.

radoulov · #5 (**permalink**) 01-27-2007

Quote:

Originally Posted by nervous

Can you please explain your code.
[...]
An awk student.

Code:

awk '
# If NR==FNR this is the first file, so get rid of 
#+ the "(",")","-"," " characters ("gsub" is global substitution),
#+ and populate the x array: x[$0].
NR==FNR{gsub(/[ \(\)-]/,"");x[$0];next}
# Otherwise, it's the second file, so 
#+ remove the spaces. Now we have
#+ the right formating. 
{gsub(/ /,"")}
# If the current record is not
#+ previously stored in the x array,
#+ print it (default action).
!($0 in x)' file1 file2

AnOTHER awk student

sbasetty · #6 (**permalink**) 01-29-2007

Thank you all,

Small clarification on this:
How can we use sed on a perticular column (third column in this example),
sed 's/[-() ]//g' is processing all the columns.
I have two files to compare.

[root@localhost test]# echo "1023,SMITH , (203) 789-1249" |sed 's/[-() ]//g'
1023,SMITH,2037891249

sbasetty · #7 (**permalink**) 01-29-2007

Hi Randuolov,

will this command displays only the changed data can you please explain.
when I run this command it is displaying same file with the data.
Thanks

Quote:

Originally Posted by radoulov

Code:

awk '
# If NR==FNR this is the first file, so get rid of 
#+ the "(",")","-"," " characters ("gsub" is global substitution),
#+ and populate the x array: x[$0].
NR==FNR{gsub(/[ \(\)-]/,"");x[$0];next}
# Otherwise, it's the second file, so 
#+ remove the spaces. Now we have
#+ the right formating. 
{gsub(/ /,"")}
# If the current record is not
#+ previously stored in the x array,
#+ print it (default action).
!($0 in x)' file1 file2

AnOTHER awk student

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
While finding compare the result with given string	mr_bold	UNIX for Dummies Questions & Answers	4	04-24-2008 09:31 PM
compare string in two files	MiLKTea	Shell Programming and Scripting	2	03-10-2008 05:35 AM
Compare string to a pattern	jerryte	Shell Programming and Scripting	2	01-25-2008 08:37 PM
Compare Char to String	Phobos	High Level Programming	3	04-09-2005 11:01 AM
string compare	gundu	Shell Programming and Scripting	3	03-23-2005 04:42 PM

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode	Rate This Thread:


	Powered by