topic Re: string function index space in QlikView

string function index space

Tue, 24 Sep 2013 13:51:01 GMT

Hi,

Quick question, I have a field within a table with a list of values as such:

500 100

600 200

800 100

20 30

10000 20000

50000 60000

2 3

I need to use a string function to only give me the numbers on the right of the space ' ' so that I end up with the following:

100

200

100

20000

60000

Can anyone help?

Thanks,

Nikki

Re: string function index space

MayilVahanan — Tue, 24 Sep 2013 14:09:13 GMT

Try like this

=SubField(Fieldname,' ',-1)

Re: string function index space

Tue, 24 Sep 2013 14:15:43 GMT

You can use subfield to get the required number.

Subfield is looking for the second value found and delimiter is a space:

Test:

LOAD * INLINE [

Numbers,

500 100,

600 200,

800 100,

20 30,

10000 20000,

50000 60000,

2 3

];

[Final]:

LOAD SubField(Numbers,' ',2) as Number

RESIDENT Test;

DROP Table Test;

Re: string function index space

Clever_Anjos — Tue, 24 Sep 2013 14:23:16 GMT

subfield(yourfield,' ',2)

Re: string function index space

tresB — Tue, 24 Sep 2013 14:24:23 GMT

Use Subfield() function, like:

Load

SubField(YourField, ' ', 2) as CorrectedValue

from <>;

Re: string function index space

rajeshvaswani77 — Tue, 24 Sep 2013 14:25:31 GMT

Hi Nikki,

Somthign likethat would do.

=mid('500 100',index('500 100',' '))

IT returns 100 for me

thanks,

Rajesh Vaswani

Re: string function index space

israrkhan — Tue, 24 Sep 2013 14:25:56 GMT

Hi,

Try below in Script Load:

=Right( YourFieldName, index( YourFieldName,' ') -1 ) as GiveFieldName

Hope to help.

Khan

Re: string function index space

Anonymous — Tue, 24 Sep 2013 14:26:52 GMT

Hai Try it....

Table1:

LOAD * INLINE [

12 313

123 33

23232 33

233 33

];

Table2:

load

subfield(F1, Chr(32) ,1) as F1

Resident Tab1;

Drop Table Table1;

Hope this helpful..

Re: string function index space

quiquegzz — Tue, 24 Sep 2013 14:27:04 GMT

Hi. Nikki.

TABLE_1;

LOAD * INLINE [
F1
500 100
600 200
800 100
20 30
10000 20000
50000 60000
2 3
];

RESULT:
LOAD
MID(F1, index(F1,' ',1),Len(F1)) AS FIELD
RESIDENT TABLE_1;

DROP TABLE TABLE_1;