topic Re: remove zero from values in Operating System - HP-UX

remove zero from values

N Gopal — Fri, 14 Mar 2008 08:50:32 GMT

Hi,

I have one file(myfile.txt) that contains values like:

"575129","0.2x0.4","0001","2"
"575129","0.2x0.4","0002","2"
"575129","0.4x0.3","0003","2"
"575129","0.4x0.3","0004","2"
"575129","0.3x0.4","0005","2"

i am trying to group values from Field 3 e.g "0002" ....

CODE i am using is :

a=`grep "575129" myfile.txt | cut -f6 -d'"'`
surface=`echo $a | awk '{out=$1;for (k=2;k<=NF;k++){out=sprintf("%s,%s",out,$k);}print out}'`

value of surface will be: 00001,00002 ...

i do not want to take 0's means only 1,2,3 ...

Can some one please help me in this regard.

Thanks

Re: remove zero from values

AwadheshPandey — Fri, 14 Mar 2008 09:15:35 GMT

add following line in your code.
echo $surface|sed 's/0//g'

Regards, Awadhesh

Re: remove zero from values

VK2COT — Fri, 14 Mar 2008 09:20:12 GMT

Hello,

If I understand you correctly, you
want a simple result like 1,2,3,4,5,

Many ways to achieve this. One of them
is by using two standard Shell tools:

sed -e 's/"//g' myfile.txt | awk -F"," '/575129/ {printf("%d,", $3)}'

Cheers,

VK2COT

Re: remove zero from values

Steven Schweda — Fri, 14 Mar 2008 09:35:05 GMT

> echo $surface|sed 's/0//g'

Brilliant. Shows thoughtful testing.

dyi # surface='00100'
dyi # echo $surface | sed 's/0//g'
1

I'm sure that that's what he wants.

Perhaps you meant something more like this?

echo $surface | sed 's/^0*//'

Re: remove zero from values

N Gopal — Fri, 14 Mar 2008 10:28:29 GMT

Thanks Awadesh,

Your reply solved my problem.

Thanks to all.

Re: remove zero from values

AwadheshPandey — Fri, 14 Mar 2008 10:29:00 GMT

Sorry. I did a mistake.

but you u follow above expert advise of my friend after looking all aspects you will again a looser.
echo $surface
0001,0002,0003,0004,00050
echo $surface | sed 's/^0*//'
1,0002,0003,0004,00050

the more generic code will be
echo $surface|sed 's/^0*//g'|sed 's/,0*/,/g'

cheers,

Awadhesh

Re: remove zero from values

N Gopal — Fri, 14 Mar 2008 10:29:52 GMT

I have got solution to my problem.

Thanks a lot.

Re: remove zero from values

AwadheshPandey — Fri, 14 Mar 2008 10:33:20 GMT

Thanks Gopal. I can assume that the person written code below(you)

a=`grep "575129" myfile.txt | cut -f6 -d'"'`
surface=`echo $a | awk '{out=$1;for (k=2;k<=NF;k++){out=sprintf("%s,%s",out,$k);}print out}'`

can do some testing also and can remove bugs also if it is there in any forum members reply.

:)

Regards,
Awadhesh

Re: remove zero from values

N Gopal — Fri, 14 Mar 2008 11:24:15 GMT

Many Thanka