Search Results

You are welcome Khushbu, I am glad I am able to help you :). We all are here to learn/help/guide/advise each other, enjoy learning :b:


Thanks,
R. Singh

Hello Khushbu,

If I understood your requirement correctly then following may help you.

TOT=`awk 'FNR==NR{split($0, A,":");current_time=A[1] * 3600 + A[2] * 60 + A[3];next} {split($0,...

Hello Khusbu,

Following may help you in same. Let's say we have 2 files named current_time and basic_time. Which are as follows.

cat current_time
04:23:16

cat basic_time
01:08:23
Then...

Hello Khushbu,

If time comes always in 5th field then you can try following.

awk '{print $5}' Input_file
If time's field is not set then you could try following.

awk --re-interval...

Hello Khsuhbu,

Following may help you in same.

awk -F"Action Triggered by Incident Modification of type: ARA" '{S[++o]="var1=" $1 ORS "var2="...

Unfortunately, you didn't tell us what the field separator is. Were it a <TAB> char, this might work:while IFS=$'\t' read var1 var2 var3 var4 var5 var6 var7 REST; do echo $var1, $var2, $var3, $var4,...

Hello Khushbu,

Could you please try following and let me know if that helps you.

awk -F"Action Triggered by Incident Modification of type: ARA" '{S[++o]="var1=" $1 ORS "var2="...

Hello Khushbu,

Following a minor change in code may help you in same.

awk '{print "select * from apsdi-apaction where request_id= "$0 ";"}' /home/remedy/demo.txt > /home/remedy/output.sql...

If it's the only 15-digit-only string:grep -Eo '[0-9]{15}' file
000000000038775

To answer your question:
grep 000000000038775 file
If you asking to extract just the "Remedy Incident Modification record", something like:
sed -ne 's/^.*Remedy Incident Modification record: \([^...

something along these lines - a bit verbose, but.....
awk -f kh.awk mySqlOutputFile where kh.awk is:

FNR > 1 {
if (!($2 in gA)) {
gA[$2]
gAl[++gC]=$2
}
aA[$1,$2]+=$3
aAa[$1]
}...