Use awk to replace numbers in a file with a column from another file Post: 303019782

Sponsored Content

Top Forums Shell Programming and Scripting Use awk to replace numbers in a file with a column from another file Post 303019782 by RudiC on Friday 6th of July 2018 08:03:56 AM

07-06-2018

Registered User

Wouldn't it make sense to group the result numbers in ranges and single numbers, where applicable? Like 889:890, 890, 891 would be one range 889:891 only, and if there was a gap, it should read like 889:891,893:894? If so, try (stealing from scrutinizer's approach):

Code:

awk '
NR==FNR         {A[$2] = $5
                 next
                }

                {CNT = 0
                 TMP = ""
                 gsub (/[)(     ]/, _, $2)
                 n = split ($2, VAL, ",")
                 for (i=1; i<=n; i++)   {if (1 == split (VAL[i], LMT, ":")) LMT[2] = LMT[1]
                                         for (j=LMT[1]; j<=LMT[2]; j++) RES[++CNT] = A[j]
                                        }
                 $2 = "c(" RES[1]
                 for (i=2; i<=CNT; i++) {DLT = RES[i] - RES[i-1]
                                         if (DLT > 1)   {$2  = $2 TMP "," RES[i]
                                                         TMP = ""
                                                        }
                                           else if (DLT == 1) TMP = ":" RES[i]
                                        }
                 $2 = $2 TMP ")"
                 print
                }
' file2 FS=c file1

This User Gave Thanks to RudiC For This Post:

RudiC

View Public Profile for RudiC

Find all posts by RudiC

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

to replace one character by numbers in a file

suppose u have a file aas P-H 123 gdg O-U 223 hdy I-Y 12 fgd K-O 333 ssa L-P 32 output shud be like that aas P123H gdg O223U hdy I12Y fgd K333O ssa L32P thanks

2. AIX

How to replace many numbers with one number in a file

How to replace many numbers with one number in a file. Many numbers like 444565,454678,443298,etc. i want to replace these with one number (300).Please halp me out.

3. Shell Programming and Scripting

Need an awk for a global find/replace in a file, specific column

I am new to unix and awk/sed etc... using C-Shell. Basically, I have a fixed length file that has 4 different record types on it, H, D, V, W all in column 1. I need to change all the W's in column 1 to D's. in the entire file. The W's can be anywhere in the file and must remain in the same...

4. Shell Programming and Scripting

Match column 3 in file1 to column 1 in file 2 and replace with column 2 from file2

Match column 3 in file1 to column 1 in file 2 and replace with column 2 from file2 file 1 sample SNDK 80004C101 AT XLNX 983919101 BB NETL 64118B100 BS AMD 007903107 CC KLAC 482480100 DC TER 880770102 KATS ATHR 04743P108 KATS...

5. Shell Programming and Scripting

Replace 2nd column of CSV file with numbers on line

I have a csv file with occasional multiple entries in the second column. 111111,104,07-24-2011,3.15,N, 222222,020 140,07-24-2011,10.00,N,I want the result 111111,104,07-24-2011,3.15,N, 222222,020,07-24-2011,10.00,N, 222222,140,07-24-2011,10.00,N, I know I can get the output of the second...

6. Shell Programming and Scripting

Find in first column and replace the line with Awk, and output new file

Find in first column and replace the line with Awk, and output new file File1.txt"2011-11-02","Georgia","Atlanta","x","","" "2011-11-03","California","Los Angeles","x","","" "2011-11-04","Georgia","Atlanta","x","x","x" "2011-11-05","Georgia","Atlanta","x","x","" ...

7. Shell Programming and Scripting

Replace column that matches specific pattern, with column data from another file

Can anyone please help with this? I have 2 files as given below. If 2nd column of file1 has pattern foo1@a, find the matching 1st column in file2 & replace 2nd column of file1 with file2's value. file1 abc_1 foo1@a .... abc_1 soo2@a ... def_2 soo2@a .... def_2 foo1@a ........

8. Shell Programming and Scripting

Awk: Need help replacing a specific column in a file by part of a column in another file

Hi, I have two input files as File1 : ABC:client1:project1 XYZ:client2-aa:project2 DEF:client4:proj File2 : client1:W-170:xx client2-aa:WT-04:yy client4:L-005A:zz Also, array of valid values can be hardcoded like Output : ABC:W:project1 XYZ:WT:project2

9. Shell Programming and Scripting

awk compare column n replace with in one file

hi Friends need to compare columns in one file where the data looks like below laptop,IBM phone,samsung car,rental user1,laptop user2,laptop user3,phone want to get output as laptop,IBM phone,samsung car,rental user1,IBM user2,IBM user3,samsung need to seach $2 in array of $1 and...

10. Shell Programming and Scripting

Match column 8 in file 1 with column 2 in file 2 and replace..

I am looking at the NR==FNR posts and trying to use them to achieve the following but I am not getting it. I have 2 files. I want to match column 8 in file 1 with column 2 in file 2. When they match I want to replace column 9 in file 1 with column 1 in file 2. This is and extract from file 1 ...

LEARN ABOUT OSF1

uumonitor

uumonitor(8)						      System Manager's Manual						      uumonitor(8)

NAME

       uumonitor - Monitors the UUCP system

SYNOPSIS

       /usr/lib/uucp/uumonitor

DESCRIPTION

       The uumonitor command displays a synopsis in tabular format of the current UUCP status. The format of each line in the table is as follows:
       system_name #C #X most_recent_status CNT:# time

       Table entries are defined as follows: The remote system for which the entry applies.  The number of C.files queued for the  remote  system.
       The number of requests for remote execution from the remote system.  The result of the most recent attempt to connect to the remote system.
       The number of times that a failure to log in to the remote system has occurred.	This does not include the  number  failed  dial  attempts.
       The time of the last status entry was made for this system.

       The uumonitor command is helpful for detecting systems that have backlogs, that have gone away for awhile, that have changed phone numbers,
       and so forth. The CNT: field is useful for detecting a system whose login/passwd has changed. If the CNT: field gets larger than the  maxi-
       mum  allowable failures (currently 20), no further attempts to connect to this system are made. If the number of C.files queued starts get-
       ting unusually large (depending on the system anywhere from 100-1000), action should be taken to determine the cause of the backlog.

SEE ALSO

       Commands: uucp(1)

																      uumonitor(8)

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

to replace one character by numbers in a file

Discussion started by: cdfd123

2. AIX

How to replace many numbers with one number in a file

Discussion started by: vpandey

3. Shell Programming and Scripting

Need an awk for a global find/replace in a file, specific column

Discussion started by: jclanc8

4. Shell Programming and Scripting

Match column 3 in file1 to column 1 in file 2 and replace with column 2 from file2

Discussion started by: rydz00