I need to search a sftplog using the field 1, but want to maintain the relationship between field 1 and 2. I am passing field 1 as a parameter in a bash loop.
I am searching a sftplog for the ID for the user, but this is only giving me the field after "user".
I want the output in /tmp/dar3.out to be
where tom was 11977, charlie was 3295, and steve was 1721.
complete code:
Open to alternative methods if recommended. Any assistance is much appreciated.
Last edited by Scrutinizer; 02-12-2015 at 01:16 PM..
Reason: additional code tags for data samples
You was not clear about requirement, based on my assumptions which are (You have 2 files named b_file and c_file as follows.)
Then as per your expected output I can suggest following.
Output will be as follows.
If you are happy with above awk command then you can redirect it's output to a file named > /tmp/dar3.out.
Hope this helps, if my assumptions are not correct, please do let us know the expected output with os details.
NOTE: On Solaris/SunOS systems, you need to change awk to /usr/xpg4/bin/awk, /usr/xpg6/bin/awk
EDIT: Sorry Corona, seems we have posted on same time, please do remove this post if needed until OP comes back with answer.
Thanks,
R. Singh
Last edited by RavinderSingh13; 02-12-2015 at 12:18 PM..
Reason: Adding comment for Corona
Bash/shell is even enough:
But if the user is in file c, just join:
I think you can adjust the output of join with arguments and avoid the cut. See the man page. You can also join with any tool with associative arrays (hash maps), like ksh, bash, awk; putting the smaller set into an array and the looking up the larger one line by line.
I tried the following, but received a lot more of the content of the source file.
Here is a sample of what was received.
My original had this to isolate the the specific record on the file. Can I include this anywhere to get the record I need?
---------- Post updated 02-13-15 at 12:04 PM ---------- Previous update was 02-12-15 at 12:12 PM ----------
Hi R.Singh,
The file that contains the records to be evaluated in an another file is
The datafile that needs to be evaluated to extract the records needed is formatted like so. Please let me know if you want me to provide in an attachment.
Just to confirm, I would like to maintain the relationship between the two fields in b_file and print in a new file.
Last edited by Scrutinizer; 02-12-2015 at 01:14 PM..
Reason: Additional code tags for data sample
Hi,
I need to pass the multiple values of src1 to another variable. I managed to print it but not sure how to assign it to a variable in a loop.
src1=01,02,03
echo $src1|awk 'BEGIN {FS=","} {for(i=1;i<=NF;i++) print $i}'
I need to pass the value as
src2=01
src2=02
src2=03
Thanks... (4 Replies)
Hi Forum.
I have the following test.txt file and need to extract certain rows based on "starting position", "length of string" and "string to search for":
1a2b3d
2a3c4d
.....
My script accepts 3 parameters: (starting col pos, length to search for, string to search for) and would like to... (4 Replies)
Currently have this:
set current=192.168.0.5
set servicehost = `echo $current | awk -F. '{print $4}'`
echo $numberoffields
5
..but would like to reduce # of variables and eliminate echo to have something like this:
set servicehost = `awk -v s="$current" -F. 'BEGIN{print $2}'`But... (3 Replies)
Hello, I am new to the whole "scripting" thing. Below is the script that I have so far and where i need the Variables to go (VAR#)
#!/bin/bash
#Sample Script
VAR1=
echo "Choose an option: 1) Create a file. 2) Delete a file. 3) Move a file."
read VAR1
case $VAR1 in
1)
echo "Pick... (4 Replies)
Hi - The following nawk is not working and trying to understand why!
nawk -v t="internal_order" '/SAP_RM_ADMIN_SCHEMA/ && ("" toupper(t)) || /SAP_RM_ADMIN_SCHEMA/ && ("" tolower(t))' PBFD100.ksh
My intention is to retrieve the line containing SAP_RM_ADMIN_SCHEMA.internal_order but its just not... (6 Replies)
Hi all ,
I have a file with below data ,
bash#cat file.txt
user1 amount1 status1
user2 amount2 status2
user3 amount3 status3
user4 amount4 status4
.
.
.
Now i have a command to be executed with above values like below ,
./errorcheck -u user1 -a amount1 -s status1
... (3 Replies)
I'm an experienced awk user, but this one has me stumped. I have an awk script which is called from a UNIX command line as you'd expect:
myscript.awk -v foo=$1 -v bar=$2 filename
My question is this: is there a mechanism for determining the names of the -v variables within a script?
... (3 Replies)
i'm new to shell scripting and have a problem please help me
in the script i have a nawk block which has a variable count
nawk{
.
.
.
count=count+1
print count
}
now i want to access the value of the count variable outside the awk block,like..
s=`expr count / m`
(m is... (5 Replies)
Hi guy's
Im trying to pass variables into nawk and then match them on a value within a record but it don't seem to be working. If i put in the dates i want to see then it works fine..
#!/usr/bin/ksh -x
YEST=$(/usr/local/bin/perl -e... (8 Replies)