topic Re: string in QlikView

string

deepakqlikview_123 — Wed, 27 May 2015 17:20:20 GMT

Below is string

S&P 500 Consumer Discretionary Sector Index = Discretionary EPS % change

Industrials EPS % change

S&P 500 Consumer Staples Sector Index = Staples EPS % change

Energy EPS % change

out of above i need to extract

S&P 500 Consumer Discretionary Sector Index = Discretionary

Industrials

S&P 500 Consumer Staples Sector Index = Staples

Energy

Respectively, can you please suggest which string function shall i use.

thanks

Re: string

Qrishna — Wed, 27 May 2015 17:28:28 GMT

If the positions of the substrings does not change in the field, then you can use

Field A

S&P 500 Consumer Discretionary Sector Index

S&P 500 Consumer Staples Sector Index

Field B

Discretionary EPS% change Industrials EPS % change

Staples EPS% change Energy EPS % change

solution:

Subfield(Field B,' ',1) & ' ' & Subfield(Field B,' ',4)

let me know if it works for you after checking.

thanks

Re: string

Clever_Anjos — Wed, 27 May 2015 17:33:04 GMT

Maybe

Subfield(Field B,'=',1) & ' ' & Subfield(Subfield(Field B,'=',2),' ',1) & ' ' & Subfield(Subfield(Field B,'=',2),' ',5)

should return what you need

Re: string

Qrishna — Wed, 27 May 2015 17:43:27 GMT

ya, if

S&P 500 Consumer Discretionary Sector Index = Discretionary EPS % change Industrials EPS % change

S&P 500 Consumer Staples Sector Index = Staples EPS % change Energy EPS % change

are data values of one single field then you can use cleveranjos‌ expression:

Subfield(Field B,'=',1) & ' ' & Subfield(Subfield(Field B,'=',2),' ',1) & ' ' & Subfield(Subfield(Field B,'=',2),' ',5)

else

if they belong to different fields

Field A

S&P 500 Consumer Discretionary Sector Index

S&P 500 Consumer Staples Sector Index

Field B

Discretionary EPS% change Industrials EPS % change

Staples EPS% change Energy EPS % change

then us expressions

solution1:

Subfield(Field B,' ',1) & ' ' & Subfield(Field B,' ',4)

let me know which one works for you after checking.

Re: string

rwunderlich — Wed, 27 May 2015 18:43:26 GMT

=TextBetween(text, '','EPS')

-Rob

http://masterssummit.com

http://robwunderlich.com

Re: string

MarcoWedel — Wed, 27 May 2015 18:49:03 GMT

=Replace(yourstring,'EPS % change','')

Re: string

MarcoWedel — Wed, 27 May 2015 18:51:49 GMT

hope this helps

regards

Marco