Getting a string out of a excel cell

[#1]

hey i'm kind of new to qlikview, so any help would be much appreciated.

What i want to do is get a string out of a cell in a uploaded excel sheet. for example there is feild saying "msg="test message" " the length of the message is different every time....

what i want to do is get the "test message part".. thankyou in advance.. cheers

[MK_QSL]

can you provide some more sample alongwith your required result?

[tresesco]

Have alook at SubField() and TextBetween().

[Anonymous]

use

subfield('msg=test','=',2)

[#5]

what have is like this

cell1      message

1           msg="new test message"

2           msg="some other message"

what i want is

cell1          message

1               new test message

2               some other message

thank you in advance

[#6]

thanks... ill do some research

[#7]

thanks... ill do some research.. subField() should work, im tring it out...

[nizamsha]

=Replace( SubField(' msg="new test message"','=',-1),'"','')

[nizamsha]

TableA:

LOAD * Inline [

MSG

msg="new test message"

msg="some other message"

];

LOAD Replace( SubField(MSG,'=',-1),'"','') as MSG1 Resident TableA;

[#10]

new test message and some other message are samples mate... those are not the actual data...

what i basically want to do is get the value after "msg="

thanks anyway

cheers