Extract text

[vijetas42]

Hi All,

I am having one field whose values are like,

Plan:  aaaaaaa.

Owner:  abcd efghhr

Deadline:  By 01/01/2016

Status: ahdfkvcxkv

Dependancies:  adoffjskjls

so, I want to extract Status value ahdfkvcxkv till we didn't get Dependacies

[Pulkit_Thukral]

Not Sure what does the last line means and how 1 field has 5 separate sub-fields.

Can u share raw data and then explain actual requirement.

[MindaugasBacius]

Do the database table look like this?

Field
Plan:  aaaaaaa.
Owner:  abcd efghhr
Deadline:  By 01/01/2016
Status: ahdfkvcxkv
Dependancies:  adoffjskjls

What should be the outcome?

[Kushal_Chawda]

vijeta sharma wrote:

I want to extract Status value ahdfkvcxkv till we didn't get Dependacies

what does it means? can you please give one example with expected output?

[vijetas42]

   I have data like this

Issue	Plan
I1	Plan: afafasddag. Owner:  aaaaadasfaf Deadline:  By 31/04/2015 Status:  Open Dependencies: None

and I need new filed where only value of Status get stored like

Status

Open

[MindaugasBacius · Accepted solution]

LOAD Issue,
     Plan,
     TextBetween(Plan, 'Status: ', ' Dependencies:') as Status
FROM
[https://community.qlik.com/thread/219520?sr=inbox&ru=151369]
(html, codepage is 1257, embedded labels, table is @2);

The result would be: