converting an engineering string to a general number

[nem]

Hi everyone,

Does any know how to convert an engineering string to a normal formated string?

Thanks

[RavensFan]

What do you mean by an "engineering string"?  What is a "normal formatted string"?

Perhaps you can give us an example of what the string looks like now and what you want it to look like.

[nem]

The engineering string outputs a number in sicentific notation (1.10E-01), where we would like to display the number as -.11.  However, this only seems to occur when the number is exported to Excel and when it is close to zero (within a fration of 1).

[Ray.R]

Do you mean Fractional / Exp to numeric Function?  which is located under the strings palette.. under String / Number Conversion.

Fract/Exp String To Number

Interprets the characters 0 through 9, plus, minus, e, E, and the decimal point (usually period) in string starting at offset as a floating-point number in engineering notation, exponential, or fractional format and returns it in number. The connector pane displays the default data types for this polymorphic function.

[RavensFan]

Example using Ray's function.  One is an actual number, the second converts that number back to a string with default precision of 6.

Message Edited by Ravens Fan on 06-10-2009 02:42 PM

[nem]

Is there any way to do this with multiple 1-D array inputs?

[GerdW]

Hi nem,

the functions shown by RavesFan also accept array inputs...

[nem]

Attached is the part of the vi  that write the data to a .txt file which is then opened in Excel, However CH2-01 in Excel reads a scientific notation format.  Trying what was said didn't work due to different source and sink types.

[GerdW · Accepted solution]

Hi nem,

in your vi there is no "CH2-01". Do you mean "DAQ21"?

See attachment for some minor changes (removed sequence, locals, build path a better way). Why do you split your arrays into 4 parts when you need to re-build all arrays again?

Are you sure it's not an Excel formatting problem? Did you set all numbers in the excel sheet to display as "numbers"?

When I try your vi I don't get any numbers in scientific format in Excel. (And I would suggest to transpose the data for Excel import...)

[nem]

Thanks for your help and suggestions on the block diagram, it was much appreciated.