How to extract this particular string using Unix/Awk/grep

Question

I have a log file which somewhat looks like this

Connected to feeder version 2.1 09:28:30 29/03/2014 Loading Account 01234567EUR
09:28:30 29/03/2014 Loading Account 0123456755JPY
09:28:30 29/03/2014 Loading Account 0123426567INR
09:28:30 29/03/2014 Loading Account 012345698887USD
09:28:30 29/03/2014 Loading Account 012343422567EUR
09:28:30 29/03/2014 Account 0234456783388KRY not set up
09:28:30 29/03/2014 Account 0234454467888CNH not set up
09:28:30 29/03/2014 Error : Closing Balance of Account 02344567888GBP Doesn't match

I want to extract the account numbers where there is a closing balance mismatch or if the account is not set-up and put those accounts into a new file for my further processing.The first step is i have used grep -il 'not set up' but after that how do I extract the account numbers, The pattern seems to be very random(not sure if I can use awk based on delimeter) Only pattern that is for sure is last 3 characters of an account Number is currency. So is it possible to use egrep and regex for this. Thanks

jaypal singh · Accepted Answer · 2014-03-29 04:18:30Z

2

Here is one way with awk:

$ awk '
/not set up/ {
    for(i=1;i<=NF;i++) 
        if($i~/Account/) print $(i+1)":Not Set Up" > "Review.txt"
}
/Error/ {
    for(i=1;i<=NF;i++)
        if($i~/Account/) print $(i+1)":Mismatch" > "Review.txt"
}' file

This creates the following file:

$ cat Review.txt
0234456783388KRY:Not Set Up
0234454467888CNH:Not Set Up
02344567888GBP:Mismatch

answered Mar 29, 2014 at 4:18

jaypal singh

77.6k24 gold badges108 silver badges147 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

user2647888 Over a year ago

Tanks a lot for your answer, works like a charm.I was about to make this more complicated by using egrep and ending up nowhere.

John Zwinck · Accepted Answer · 2014-03-29 04:18:47Z

2

I'd use sed, without grep:

sed -n "
    s/.* Closing Balance of Account \(.*\) Doesn't match/\1/p;
    s/.* Account \(.*\) not set up/\1/p
  "

Adjust to taste, e.g. if you want to print something next to either case to identify which accounts have which problem.

answered Mar 29, 2014 at 4:18

John Zwinck

252k44 gold badges347 silver badges459 bronze badges

1 Comment

user2647888 Over a year ago

Thanks a lot for your answer, works superb. Basically these are the sub-account numbers which I have to lookup in the database and get the main account numbers and then add a comment/Reason.

Amol · Accepted Answer · 2014-03-29 06:28:18Z

1

You can use the grep statements as follows to get the desired account numbers:

grep 'not set up' file.txt | grep -Po '\d+[A-Z]{3}'
grep 'Error' file.txt | grep -Po '\d+[A-Z]{3}'

answered Mar 29, 2014 at 6:28

Amol

552 silver badges3 bronze badges

Comments

Scrutinizer · Accepted Answer · 2014-03-29 12:15:25Z

1

Another way, shortish from the command line, just the account numbers:

awk -F'^.*Account|[ \t]*' '/Error|set/{print $3}' file

Or together with the reason:

awk -F'^.*Account[ \t]*' '!/Loading/{print $2}' file

edited Mar 29, 2014 at 12:15

answered Mar 29, 2014 at 12:01

Scrutinizer

9,9661 gold badge24 silver badges23 bronze badges

Collectives™ on Stack Overflow

How to extract this particular string using Unix/Awk/grep

4 Answers 4

1 Comment

1 Comment

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

1 Comment

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related