How to get a specific text value from the text Box

[Anonymous]

Hi

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

[shane_spencer]

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.

[alexandros17 · Accepted solution]

=TextBetween(

'Following application are failed

  ABC.qvw

  ggg.qvw

  Xyz.qvw

  yyy.qvw

thanks'

,

'failed'

,

'thanks'

)

[MarcoWedel]

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

[PradeepReddy]

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)

[Anonymous]

Hi guys

thanks for the fast help..

Bhumika

[Anonymous]

hey Alessandro

Thanks

it is working perfectly