topic Re: Extract text in QlikView

Extract text

vijetas42 — Mon, 06 Jun 2016 07:22:33 GMT

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

Re: Extract text

Pulkit_Thukral — Mon, 06 Jun 2016 07:28:21 GMT

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.

Re: Extract text

MindaugasBacius — Mon, 06 Jun 2016 07:30:59 GMT

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?

Re: Extract text

Kushal_Chawda — Mon, 06 Jun 2016 07:32:47 GMT

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?

Re: Extract text

vijetas42 — Mon, 06 Jun 2016 07:48:52 GMT

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

Re: Extract text

MindaugasBacius — Mon, 06 Jun 2016 08:01:15 GMT

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: