Number to String

[Anonymous]

Hi,

I have a field 'COV' which has values like this:  51 , 85 > 2M.

When i apply num#(COV) as COV in script, I got result 51 but not getting 85 > 2M as this is a string.

How can i get both values here?

Thanks

[pradosh_thakur · Accepted solution]

No it is not

LOAD *,ALT(NUM(COV),NUM(LEFT(TEXT(COV),INDEX(COV,' ',1)))) AS COV_RESULTS;
load * inline [
item,COV
a,51
b, 85 > 2M
];

[Anonymous]

Ok thanks a lot!