hex function

[Courtney1306]

I have a file in excel with two columns of hex numbers. I need to change them all to decimals. The code works when I use a specific hex, but when I try to search the field it prints all 15's from first column when they should be 0. The second column is also wrong. Can someone help?!

open (E, "RETURNCAL3.csv") || die ("Could not open file!");

while ( $file = <E> ) {
@field = parse_csv($file);
chomp(@field);

$i_test = hex("field[1]");
$q_test = hex("field[2]");
$mag_test= sqrt(($i_test**2)+($q_test**2));
print "$i_test, q_test, $mag_test \n";
}

close E;

 

[travs69]

you have a missing $

print "$i_test, q_test, $mag_test \n";

should be

print "$i_test, $q_test, $mag_test \n";

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Travis - Those Who Say It Cannot Be Done Are Usually Interrupted by Someone Else Doing It; Give the wrong symptoms, get the wrong solutions;

 

[Courtney1306]

Yes, I saw that, and my other problem was a missing @ before field. Thanks for you help.

 

[travs69]

Are you using Text::CSV in there (I'm trying to figure out where parse_csv is coming from).

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Travis - Those Who Say It Cannot Be Done Are Usually Interrupted by Someone Else Doing It; Give the wrong symptoms, get the wrong solutions;

 

[Courtney1306]

I'm actually changing some code which was given to me. I did not write that part, but there is a sub class used to define the parse function instead of using the whole module.

 

[MillerH]

Are you using Text::CSV in there (I'm trying to figure out where parse_csv is coming from).

She's still using the "roll your own" solution provided by Hemo in this thread, even though we advised her not to:

http://www.tek-tips.com/viewthread.cfm?qid=1387418

Shrug. Some people just don't know good advice when it's offered unfortunately.

- Miller

 

[Courtney1306]

I have no control over what the company wants to use. I am using that for a specific reason. Thanks for the help.

 

[MillerH]

I suspect that the most relevant reason is simple inertia. Once you make a decision, it is often difficult to change it no matter the argument reasoning.

Anyway, I'll refrain from any more preaching. You've heard all of our advice in the earlier thread.

- Miller