shell script match data from another text file

Question

i have a shell script

#/bin/bash
var1=`cat log.json | grep "accountnumber" | awk -F ' ' '{print $1}'`
echo $var

output of shell script is :-

I want match the above number which is already store in another file (below is the file format ) and print its value .

23466=account-1
283483=account-2
324932=account-3
87374=account-4
127632=account-5
1324237=account-6
73642=account-7
324993284=account-8
.
.
4543454=account-200

exapected output

account-1
account-2
account-3
account-4

Why is your file named with a .json extension if its format isn't actually JSON? — Charles Duffy
– Charles Duffy, Commented Aug 14, 2018 at 16:16
Please avoid "Give me the codez" questions. Instead show the script you are working on and state where the problem is. Also see How much research effort is expected of Stack Overflow users? — jww
– jww, Commented Aug 15, 2018 at 1:37

Inder · Accepted Answer · 2018-08-14 16:40:38Z

1

a Compact one line solution can be:

join -t "="  <(sort bf) <(sort fa) | cut -d '=' -f 2

here fa is a file containing out-put of your bash script and bf is the file that has 23466=account-1 format

the output is:

account-1
account-2
account-3
account-4

answered Aug 14, 2018 at 16:40

Inder

3,8369 gold badges30 silver badges43 bronze badges

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

Comments

keithpjolley · Accepted Answer · 2018-08-14 16:31:37Z

0

#!/bin/bash

for var1 in $(awk -F ' ' '/accountnumber/{print $1}' log.json)
do
  awk -F= '$1=="'"$var1"'"{print $2}' anotherfile
done

For a moment there was another answer that almost worked that I think is much slicker than what I wrote. Probably faster / more efficient on large files too. Here it is fixed.

awk -F ' ' '/accountnumber/{print $1}' log.json \
| sort -n \
| join -t= - accountfile \
| cut -d= -f2

edited Aug 14, 2018 at 16:31

answered Aug 14, 2018 at 16:15

keithpjolley

2,2931 gold badge20 silver badges23 bronze badges

Collectives™ on Stack Overflow

shell script match data from another text file

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related