mport scientific notation values from text file with QV10?

[Anonymous]

Hi,

Any suggestion how I can import scientific notation values from text file? To illustrate the problem, the following INFILE import in QV10 doesn't give numeric values. I dodn't remember that this problem popped with QV9.

LOAD * INLINE [

FieldSci

1E1

1E-7

1.5e-05

1.3E-03

];

[Anonymous · Accepted solution]

Vladimir,
This is how it can be done:
=subfield(upper(FieldSci), 'E',1) *pow(10,subfield(upper(FieldSci), 'E',2))

[Anonymous]

Thanks, Michael.

I have put this tweak into $ expansion:

set SciHandle=if(FindOneOf($1,'eE')>0,subfield(upper($1), 'E',1) *pow(10,subfield(upper($1), 'E',2)),$1);

then

$(SciHandle(FieldSci))

works

Although I hoped for a more "native" solution. In practice, I don't known if a field contains scientific notation numbers. Meaning I need to apply the fix to every numeric field...

Best

Vlad