[SOLVED] How to remove leading zeros in a function

santosh0782 · 03-05-2014, 12:47 AM

Hi,

I have a File1 with data as:
cat File1:

Code:

<row>
 <OWNER>SAN</OWNER>
 <AREA>GLOBAL BUSINESS SOLUTIONS</AREA>
 <GROUP>TRANSACTION CLEARING SYSTEM</GROUP>
 <SERVICE>TRANSACTION CLEARING SYSTEM</SERVICE>
 <KPI>STST401</KPI>
 <STATE>0.0</STATE>
 <LASTUPDATED>1393971372739</LASTUPDATED>
 <DESCRIPTION>GOOD RUN , 0000991776 , 000092743794 Tue 04/03/14 22:16</DESCRIPTION>
 <SOURCE>COC</SOURCE>
 <CITYPE>KPI</CITYPE>
</row>

i have written a function to pull the details as:

Code:

Good_Job_With_Count_Info()
{
  # get specific info from rtView
  jobTarget=( $( grep -A3 "STST401" "File1" | tail -1 | tr '[><]' ' ' ) )


        jb_rtv_date1=${jobTarget[8]}  #Date DD/MM/YY
        jb_rtv_time1=${jobTarget[9]} #Time HH:MM
        jb_rtv_status=${jobTarget[1]} can we take "GOOD RUN"  for this field from the File1 
        jb_rtv_day=${jobTarget[7]}
        jb_rtv_hour=${jobTarget[9]%:*}
        jb_rtv_min=${jobTarget[9]#*:}
        jb_rtv_count=${jobTarget[4]} For this field, how could we remove the leading zeros
        jb_rtv_amount=${jobTarget[6]} For this field, how could we remove the leading zeros 

        #echo "jb_rtv_date1=${jb_rtv_date1}"
        #echo "jb_rtv_time1=${jb_rtv_time1}"
        #echo "jb_rtv_status=${jb_rtv_status}"
        #echo "jb_rtv_day=${jb_rtv_day}"
        #echo "jb_rtv_hour=${jb_rtv_hour}"
        #echo "jb_rtv_min=${jb_rtv_min}"
        #echo "jb_rtv_count=${jb_rtv_count}"
        #echo "jb_rtv_amount=${jb_rtv_amount}"
}

pan64 · 03-05-2014, 12:58 AM

Code:

A=000234
echo ${A##*0}

instead of jobTarget=( $( grep -A3 "STST401" "File1" | tail -1 | tr '[><]' ' ' ) ) I would rather use a single awk.

santosh0782 · 03-05-2014, 01:19 AM

Quote:

Originally Posted by pan64

Code:

A=000234
echo ${A##*0}

instead of jobTarget=( $( grep -A3 "STST401" "File1" | tail -1 | tr '[><]' ' ' ) ) I would rather use a single awk.

how could we use single awk for the above?

santosh0782 · 03-05-2014, 01:26 AM

As suggested you in post#2
have written code like this:

Code:

{
  # get specific info from rtView
  jobTarget=( $( grep -A3 "STST401" "File1" | tail -1 | tr '[><]' ' ' ) )


        jb_rtv_date1=${jobTarget[8]}  #Date DD/MM/YY
        jb_rtv_time1=${jobTarget[9]} #Time HH:MM
        jb_rtv_status=${jobTarget[1]}
        jb_rtv_day=${jobTarget[7]}
        jb_rtv_hour=${jobTarget[9]%:*}
        jb_rtv_min=${jobTarget[9]#*:}
        jb_rtv_count=${jobTarget[4]##*0} This is not working properly 
         jb_rtv_amount=${jobTarget[6]##*0}This is not working properly 

        #echo "jb_rtv_date1=${jb_rtv_date1}"
        #echo "jb_rtv_time1=${jb_rtv_time1}"
        #echo "jb_rtv_status=${jb_rtv_status}"
        #echo "jb_rtv_day=${jb_rtv_day}"
        #echo "jb_rtv_hour=${jb_rtv_hour}"
        #echo "jb_rtv_min=${jb_rtv_min}"
        echo "jb_rtv_count=${jb_rtv_count}"
        echo "jb_rtv_amount=${jb_rtv_amount}"
}

pan64 · 03-05-2014, 01:48 AM

Code:

awk ' BEGIN { FS="[<> ,:]*" }   # I do not really know what kind of separator do you need
      /STST401/ { l=NR+3 };
      NR == l { print $8" "$9" "$2" "$6+0" "$7}' file1 # here $6+0 will remove leading 0

you should adjust the print line to fit your needs

santosh0782 · 03-05-2014, 03:53 AM

Quote:

Originally Posted by pan64

Code:

awk ' BEGIN { FS="[<> ,:]*" }   # I do not really know what kind of separator do you need
      /STST401/ { l=NR+3 };
      NR == l { print $8" "$9" "$2" "$6+0" "$7}' file1 # here $6+0 will remove leading 0

you should adjust the print line to fit your needs

ok..Thanks a lot :-)

but in this code can we remove leading zeros:

Code:

{
  # get specific info from rtView
  jobTarget=( $( grep -A3 "STST401" "File1" | tail -1 | tr '[><]' ' ' ) )


        jb_rtv_date1=${jobTarget[8]}  #Date DD/MM/YY
        jb_rtv_time1=${jobTarget[9]} #Time HH:MM
        jb_rtv_status=${jobTarget[1]}
        jb_rtv_day=${jobTarget[7]}
        jb_rtv_hour=${jobTarget[9]%:*}
        jb_rtv_min=${jobTarget[9]#*:}
        jb_rtv_count=${jobTarget[4]##*0} Here,This is not working can we remove leading zeros for this 4th field  
         jb_rtv_amount=${jobTarget[6]##*0}Here,This is not working can we remove leading zeros for this 6th field 

        #echo "jb_rtv_date1=${jb_rtv_date1}"
        #echo "jb_rtv_time1=${jb_rtv_time1}"
        #echo "jb_rtv_status=${jb_rtv_status}"
        #echo "jb_rtv_day=${jb_rtv_day}"
        #echo "jb_rtv_hour=${jb_rtv_hour}"
        #echo "jb_rtv_min=${jb_rtv_min}"
        echo "jb_rtv_count=${jb_rtv_count}"
        echo "jb_rtv_amount=${jb_rtv_amount}"
}