Error string to float: !OVF

[bertrand2310]

Hello,

I have a problem, when I launch a script in python, sometimes I receive this message:

Traceback (most recent call last):
File "test-Regu-V1.py", line 186, in <module>
regu_difference = regu_value - round(float(spectro_tabWatt))
ValueError: could not convert string to float: !OVF

Can you help me ?

Kevin

[PeterO]

use a "try: except:" block to catch the exception and print out offending the value of spectro_tabWatt.

PeterO

[MaxK1]

We once had a large-ish energy management system that would happily take any random garbage string and convert it floating point, store it and keep on crunching (maybe). When we reported the error, the head office said (in essence) "Don't enter invalid data"... Then we found about 20000 other "problems" with the system...

[Paeryn]

Python has already told you what it can't convert right there in the exception, spectro_tabWatt = '!OVF', you need to validate your string. Easiest way to check if it can be converted into a float as PeterO said, using exceptions to catch when it can't.

Code: Select all

def is_float(v):
    try:
        float(v)
        return True
    except ValueError:
        return False

if is_float(spectro_tabWatt):
    # it is a float, do your calculations
    regu_difference = regu_value - round(float(spectro_tabWatt))
else:
    # do whatever to handle receiving invalid data
    print('Cannot convert contents of spectro_tabWatt into a floating point number: {}'.format(spectro_tabWatt))