#!/usr/bin/ksh
mPrev2='First'
while read mInpLine
do
mFld2=$(echo ${mInpLine} | cut -d'|' -f2)
mFld5=$(echo ${mInpLine} | cut -d'|' -f5)
if [[ "${mFld2}" != "${mPrev2}" ]]; then
if [[ "${mPrev2}" != "First" ]]; then
echo ${mOutLine}
fi
mPrev2=${mFld2}
mOutLine=${mFld2}
fi
mOutLine=${mOutLine}'|'${mFld5}
done < input_file
if [[ "${mPrev2}" != "First" ]]; then
echo ${mOutLine}
fi
First we are creating array 'a' which will have index as your second field. And each time we process a row we will append the content for fifth field with corresponfing content of the array
Code:
a[$2]=a[$2]FS$5
the FS will have the field seperator '|'
and once all rows are processed we are using a for loop to print each array index and its value
Hi,
I am trying to pass awk field to a command line executed within awk (need to convert a timestamp into formatted date).
All my attempts failed this far.
Here's an example.
It works fine with timestamp hard-codded into the command
echo "1381653229 something" |awk 'BEGIN{cmd="date -d... (4 Replies)
below is the output xml string from some other command and i will be parsing it using awk
cat /tmp/alerts.xml
<Alert id="10102" name="APP-DS-ds_ha-140018-componentFailure-S" alertDefinitionId="13982" resourceId="11427" ctime="1359453507621" fixed="false" reason="If Event/Log Level(ANY) and... (2 Replies)
Hi,
I have a situation to compare one file, say file1.txt with a set of files in directory.The directory contains more than 100 files.
To be more precise, the requirement is to compare the first field of file1.txt with the first field in all the files in the directory.The files in the... (10 Replies)
Hello all,
Here is what my bash script does: sums number columns, saves the tot in new column, outputs if tot >= threshold val:
> cat getnon0file.sh
#!/bin/bash
this="getnon0file.sh"
USAGE=$this"
InFile="xyz.38"
Min="0.05"
#
awk '{sum=0; for(n=2; n<=NF; n++){sum+=$n};... (4 Replies)
I have a script problem that I am not able to solve due my very limited understanding of unix/awk.
This is the contents of test.sh
awk '{print $1}'
From the prompt if I enter:
./test.sh Hello World
I would expect to see "Hello" but all I get is a blank line. Only then if I enter "Hello... (2 Replies)
Sorry for the duplicate thread this one is similar to the one in
https://www.unix.com/shell-programming-scripting/88132-awk-sed-script-read-values-parameter-files.html#post302255121
Since there were no responses on the parent thread since it got resolved partially i thought to open the new... (4 Replies)
Hi ,
I have a piece of code ...wherein I need to assign the following ...
1) A command line argument to a variable
e.g origCount=ARGV
2) A unix command to a variable
e.g result=`wc -l testFile.txt`
in my awk shell script
When I do this :
print "origCount" origCount --> I get the... (0 Replies)
05-13-2011
)