Đã hoàn thành

simple script with awk

Im trying to compare 2 csv files for patterns and remove one line that exist in both files recursively within Linux. Im trying to only compare certain columns and there may be more than one instance of the same amount Im trying to pair. This is where Im having the most trouble, as I only want to whack out one of the lines if a match occurs and not all of that same string. Example:

File 1> 01/02/2013,"BANKCARDMTOT DISC CO REF- 524771001329272",27082,(19.95),,

File 2 > "01/01/2013",,"Php webhosting","Telephone Expense",,"19.95",,, 05/02/2013,"BANKCARDMTOT DISC CO REF- 524771001329272",27034,(19.95),,

I want to take column 4 and remove the () then whack out one instance of that amount in file 2 looking in column 4 and removing the "". As you can see in my example there are 2 instances of 19.95, but I want to remove only one. Then if 19.95 comes up again it removes the next instance and so on.

Further, I dont know if its possible to use a date range as well for finding which file to whack as the dates should be within 45 days.

Kĩ năng: Linux

Xem nhiều hơn: recursively, pair of lines, pair line, finding match, awk csv, whack, telephone script, awk, php string remove, php csv compare, php remove string, string compare, csv compare files, php script compare csv, simple script files, simple script php, php script csv files, php compare csv, webhosting script, script match file

Về Bên Thuê:
( 45 nhận xét ) Odessa, United States

ID dự án: #6773014

Được trao cho:

giampaolofolena

I am a Linux administrator. I can do this in 1 day. If you have any question don't hesitate to contact me.

$35 USD trong 3 ngày
(3 Đánh Giá)
2.6

2 freelancer chào giá trung bình$33 cho công việc này

linuxfreak1985

A proposal has not yet been provided

$30 USD trong 1 ngày
(394 Nhận xét)
7.6