Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
];
alt(num#(COV),TEXT(COV)) AS COV
By doing this still i m getting only 51 and not 85 > 2M
Is this possible that '> 2M' would get removed from '85 > 2M' and only figure 85 would show from this?
You can use subfield for that
=Alt(COV,SubField(COV,' ')) as COV
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
What are you need as result?
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
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?
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.