Making all numbers follow scientific notation.

[cody_fretheim]

I’m trying to make all of the numbers in my table have scientific notation, X.XXEX. I’m currently using Round Double and it gives mixed results for the outputs.

[ScottF]

Hi @cody_fretheim and welcome to the forum.

When you say “mixed results for the outputs” what do you mean? Can you provide a short example?

I’ve been digging around for a way to force scientific notation and haven’t found something straightforward yet (usually folks are concerned with the opposite problem - how to get rid of it). If you can provide a bit more detail about what you’re looking for maybe we could turn it into a feature request - perhaps additional functionality for the new Number Format Manager node?

[cody_fretheim]

Here’s what my outputs look like. I want them all to look the same, ideally 1.00E1

[takbb]

Hi @cody_fretheim , you could use a “java hack” in String Manipulation to achieve this, if you are happy that the resultant output will be Strings (as it would be with Round Double)
e.g.

string(
    String.format("%e", $MyNumber$)
)

would return this:

or to specify, say, 3 significant digits, you could use

string(
	/* specify 3 significant digits */
	String.format("%.3e", $MyNumber$)
	)

[tqAkshay95]

Hello @cody_fretheim ,

You can use a string manipulation node and configure it with an expression like

“string(
String.format(”%.3e", $new$)
) "

output: