topic Re: How to get a specific text value from the text Box in QlikView

How to get a specific text value from the text Box

Anonymous — Fri, 20 Jun 2014 10:07:39 GMT

I have fetched the mail from outlook into the textbox. now what I want is to keep some specific text from the mail.

for eg now the textbox contains.

"Following application are failed

ABC.qvw

ggg.qvw

Xyz.qvw

yyy.qvw

thanks

Here i want to take only the apps name i.e

"ABC.qvw

ggg.qvw

Xyz.qvw

yyy.qvw"

so what I need to do is take the text after the word "failed" and before "thanks" and place it in another textbox.

Which funtion should i use to trim the text the way I want?? or i have write macro for this?

Thanks in advance

Bhumika

Re: How to get a specific text value from the text Box

shane_spencer — Fri, 20 Jun 2014 10:12:59 GMT

Use subfield

i.e.

subfield(email,'failed',2)

you can build this up in parts by using 'thanks' and ' ' (space). You may need to do 3 subfields to achieve this but it's faily easy.

Re: How to get a specific text value from the text Box

alexandros17 — Fri, 20 Jun 2014 10:15:06 GMT

=TextBetween(

'Following application are failed

ABC.qvw

ggg.qvw

Xyz.qvw

yyy.qvw

thanks'

'failed'

'thanks'

)

Re: How to get a specific text value from the text Box

MarcoWedel — Fri, 20 Jun 2014 10:33:39 GMT

Hi,

another solution:

LOAD *,
     Mid(mailBody, 35, Len(mailBody)-42) as apps;
LOAD
'Following application are failed'&chr(13)&chr(10)&'ABC.qvw'&chr(13)&chr(10)&'ggg.qvw'&chr(13)&chr(10)&'Xyz.qvw'&chr(13)&chr(10)&'yyy.qvw'&chr(13)&chr(10)&'thanks' as mailBody
AutoGenerate 1;

hope this helps

regards

Marco

Re: How to get a specific text value from the text Box

PradeepReddy — Fri, 20 Jun 2014 10:37:59 GMT

We can achieve this using SubField() also....

Subfield(subfield('"Following application are failed

ABC.qvw

ggg.qvw

Xyz.qvw

yyy.qvw

thanks

"
','failed',2),'thanks',1)

Re: How to get a specific text value from the text Box

Anonymous — Fri, 20 Jun 2014 14:22:25 GMT

Hi guys

thanks for the fast help..

Bhumika

Re: How to get a specific text value from the text Box

Anonymous — Fri, 20 Jun 2014 14:23:39 GMT

hey Alessandro

Thanks

it is working perfectly