Help with finding value in text

[SanWWWWW]

Hi,

I need some help with finding values in text. Right now I have table 1, and I want table 2 as result. 

Thnx in advance!

Table 1:

idAction	Action	Description
123456	Question 1	<text>
123458	Question 2	<text>
123459	Question Follow Up	<text> action 123456 <text>
123460	Question Closed	<text> action 123459 <text> action 123456 <text>
123461	Question Closed	<text> action 123458 <text>

Table 2:

idAction	Action	Description	Question Closed?
123456	Question 1	<text>	Yes - id 123460
123458	Question 2	<text>	Yes - id 123461
123459	Question Follow Up	<text> action 123456 <text>	-
123460	Question Closed	<text> action 123459 <text> action 123456 <text>	-
123461	Question Closed	<text> action 123458 <text>	-

[StarinieriG]

Hi,

maybe you could try something like this

TABLE:
LOAD *,
KeepChar(If(Index(Action,'Closed')>0,SubField(Description,'<text>',-2)),'1234567890') as idActionClosed
;
....
;

Left Join
LOAD
idActionClosed as idAction,
'Yes - id ' & idAction as [Question Closed?]
Resident TABLE;

[SanWWWWW]

 Thank you for your quick response, unfortunately it doenst work..

Maybe my question was wrong. Basically i wanna search, per combination of "action" (just text) and the id of a question (idAction), so "action idAction", in the description of 'Question Closed'. 

And the '<text>' in my tables is actually text, it is not displayed as <text>.

[StarinieriG]

Instead of text what do you have? Spaces?

In that case, probably this could work:

LOAD *,
If(Index(Action,'Closed')>0,Mid(Description,Index(Description,'action',-1)+6)) as idActionClosed