Format codes for special handling of NaN?

[David Boyd]

Hello all-

Was having this discussion with my coworker today, and he swears he saw a clever example of this somewhere - the task at hand is to convert doubles to strings for eventual display in a table. I regularly use NaN to indicate lack of a measured value, and I was lamenting all the extra nodes it takes, to test for isNaN?, then a select node, and an empty string constant, just to suppress the 'NaN' text, which is meaningless to my end users. Plus, while I want to format multiple doubles into a row of the table, I can't use an expandable Format Into String node if I need to do this testing and selecting.

So, is there some undocumented format code to conditionally format an NaN? Or is he confusing this with Excel's conditional formatting?

Best regards,

Dave

[Michael Aivaliotis]

Why not use the Search and Replace?

[Mikkel]

Why not use the Search and Replace?

What about:

-Mikkel

[David Boyd]

Why not use the Search and Replace?

(Insert head-smack noise here.) Doh!

Michael, sometimes the obvious solution just doesn't occur to me... This method looks to be clean and 100% reliable - after all, NaN always gets converted to the string "NaN", so it's a cinch to do the fixup in the string.

Thanks a bunch!

Dave

[Aristos Queue]

Slight modification to Michael's example... I found out recently that I could connect an array of strings to Concatenate String. So to easily handle an array of doubles...

[PJM_labview]

Slight modification to Michael's example... I found out recently that I could connect an array of strings to Concatenate String. So to easily handle an array of doubles...

Nice! :thumbup:

I did not know that either.

PJM

[Ton Plomp]

Nice! :thumbup:

I did not know that either.

PJM

So that means no more shift register!!

Ton