Extracting piece of text from Expression

[manpri7078]

Hi all users,

I am almost a newbie to Qlikview. I have a very basic question. I have an expression in a text object which results in a text containing some url links. I want to extract that piece of information related to url links so that I can make another text object for that expression.

I need your valuable guidance in this regard.

Regards,

Manish Prasad

[its_anandrjs]

Use subfield function for that like

Eg:-

SubField(Fieldname,';',1)

what is your field

[its_anandrjs · Accepted solution]

Look at the example

Suppose your text field like www.google.com

when you use you get google

SubField('www.google.com','.',2) = google

[manpri7078]

Dear Anand,

Attached herewith is the sample qvw document. The text object contains some information which also contains the link to external image path. I want to extract just that path from the whole string.

I hope I have more clearly clarified my problem.

Your guidance in this regard will be appreciated.

Regards,

Manish Prasad

[its_anandrjs]

You mean to say you want to get image source like

"http://static.ibnlive.in.com/pix/labs/sitepix/04_2014/11-april-rahul_90x6.jpg"

[its_anandrjs]

If you have to extract path use below code for description field you can get this.

=SubField(description,'"',2)

or in text box write a code

=SubField(TextBetween(IF(title=GetFieldSelections(title),description),'','>'),'"',2)