Shell Programming and Scripting

I have searched and the answers I have found thus far have led me to this point, so I feel I am just about there.

I am trying to convert a column of hexadecimal to decimal values so that I can filter out via grep just the data I want. I was able to pull my original 3 character hex value and append 0x to the front but the printf statement seems not to work to convert it to decimal. I dumped my output to a file and have been trying to get it to convert so I can proceed on.

Here are the last lines snipped from my file, as it it large:

Code:

0x0C0,###0,33,6291
0x011,###1,59,0
0x009,###0,59,362147
0x011,###2,59,260
0x00E,###2,59,1051
0x008,###1,33,0
0x034,###2,59,0
0x001,###3,59,208
0x00E,###2,33,52
0x034,###2,33,0
0x00F,###1,59,0
0x009,###0,33,33022

From the shell prompt I tried:

Code:

printf  "%d\n" 0x03E

and get the proper output:

62

If I type:

Code:

cat <file>|nawk -F, '{printf "%d\n" , $1}'

I get nothing but zeroes as output:

Code:

0
0
0
0
0
0
0
0
0

I tested via:

Code:

cat <file>|nawk -F, '{$1,"     ""%d\n",$1}'

and my output has the correct output from $1, but "%d\n" won't output the decimal equivalent:

Code:

0x0C0     0
0x011     0
0x009     0
0x011     0
0x00E     0
0x008     0
0x034     0
0x001     0
0x00E     0
0x034     0
0x00F     0
0x009     0

So what am I missing? I have had it suggested that printf is different in awk than in the shell but that seemed wrong from what I read.

Please post what Operating System and version you are running and what Shell you have.
I may not be able to help with the solution, but this basic information will help other posters.

Re-reading the original post it is hard to work out what you are trying to achieve.
Please post sample input data, sample matching output data and a brief description of the process.

SunOS, looks like 5.10? Running on a Sparc Netra-240. Let me clean up my post to clarify input > process > output. Thank you.

Oh and I am in zsh for editing but I can't guarantee what a user will be in so I try to keep it good for basic sh.

awk/nawk don't have native support for hexadecimal.

Code:

function parsehex(V,OUT)
{
    if(V ~ /^0x/)  V=substr(V,3);

    for(N=1; N<=length(V); N++)
        OUT=(OUT*16) + H[substr(V, N, 1)]

    return(OUT)
}

BEGIN { for(N=0; N<16; N++)
        {  H[sprintf("%x",N)]=N; H[sprintf("%X",N)]=N } }

{ print parsehex($1) }

Thank you for the reply, I am glad it was awk/nawk and not me this time. Now to take your code and figure out how to make it work for me!

Lateral thought.
Have you considered converting the search number in question to matching format hexadecimal and then using grep rather than converting all the hexadecimal values in the large file to decimal?

Heh, that is actually what I have been pondering pretty heavily as an alternative actually.

My suggestion that end users learn hexadecimal before touching my script was denied, sadly.