topic Re: sub String in QlikView

sub String

NavinReddy — Thu, 18 Dec 2014 19:26:00 GMT

Dear Experts

I want to fetch a value mention in bracket,im using this expression its not working
please some one help me to fetch only "in USD"

=Mid('Jan Cost (in USD)', Index('Jan Cost (in USD)', ' ') +8)

Best Regards,

Niranjan

maxgro — Thu, 18 Dec 2014 19:57:41 GMT

if your strin gis str

= mid('$(str)', Index('$(str)', '(')+1, Index('$(str)', ')')-Index('$(str)', '(')-1 )

see attachment

Anonymous — Thu, 18 Dec 2014 20:01:03 GMT

Hi,

mid('Jan Cost (in USD)',11, 1 )

mid('Jan Cost (in USD)',12, 1 ) - if there are two spaces in the string after Jan Cost

NavinReddy — Thu, 18 Dec 2014 20:17:45 GMT

Hi Massimo,

Thank you so much for your valuable response

Best Regards,

Niranjan

MarcoWedel — Fri, 19 Dec 2014 00:31:52 GMT

Hi,

one solution could be also:

TextBetween('Jan Cost    (in USD)', '(', ')')

hope this helps

regards

Marco

NavinReddy — Mon, 22 Dec 2014 12:59:09 GMT

Hi Marco,

Thanks Again

Best Regards,

Niranjan