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]

alt(num#(COV),TEXT(COV)) AS COV

[Anonymous]

By doing this still i m getting only 51 and not 85 > 2M

[Anonymous]

Is this possible that '> 2M' would get removed from '85 > 2M' and only figure 85 would show from this?

[stigchel]

You can use subfield for that

=Alt(COV,SubField(COV,' ')) as COV

[pradosh_thakur]

Please change your code accordingly something like this ALT(NUM(COV),NUM(LEFT(TEXT(COV),INDEX(COV,' ',1)))) AS COV  below is an example

ABC:

LOAD *INLINE [

AGE

1

400 >2M

];

LOAD ALT(NUM(AGE),TEXT(AGE)) AS AGE1

RESIDENT ABC;    // ONE IN TEXT ONE IN NUM

LOAD ALT(NUM(AGE),NUM(LEFT(TEXT(AGE),INDEX(AGE,' ',1)))) AS AGE2

RESIDENT ABC;  // >2M REMOVED

[Anil_Babu_Samineni]

What are you need as result?

[Anonymous]

This solution is helpful and working but only for three fields.

And i have four fields where i want this result. why it is not working for my fourth field??

Thanks

[pradosh_thakur]

Hi Wajiha

you need to tell what your fields are. unless you tell them we will not be able to provide any solution.

BTW did you try my suggestion?

[Anonymous]

Yes i had tried your solution but that solution is making two different fields from a single field.

What i want is both results in a single field.

for eg:

From above example, if i select item 'A' then it would show me 51 and when i select item 'B' it would show me 85.