Parsing The Data

[shashank_shukla]

Hello,

Scenario:-  I am fetching one column from database which contains the Comments and from the comments I have to only fetch the specifics words and order of the words is not fixed only base of some keywords I have to fetch the data.

Ex:- 

Input	Output1	output2
I am working on [Issue:0] and the result is [Invalidreason:Not submitted]	0	Not submitted
I am working on [Issue:1] and the result is [Invalidreason:Resolved]	1	Resolved
I am working on [Invalidreason:Transfer]  and the result is [Issue:3]	3	Transfer

The example is mention the same way I am getting the data. The order of [Issue:...] and [invalidreason:......] is not fixed.

Can anyone help me to find out the solution.

If possible kindly attach the sample solution as well.

Thanks And Regards,

SHASHANK R. SHUKLA

[shashank_shukla]

Thanks @OllieClarke ,

For your quick response its means a lot.

Your solution is working fine for me.

[OllieClarke]

@shashank_shukla Great to hear :)