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

[#2]

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

[Anonymous]

Hi,

Use subfield(), read about it in the help and apply the same. Use '=' as delimiter and you are done.

[nizamsha]

post sme qvw so we can have a try

if U want to remove  msg=mean then  subfield() is enough

[#5]

ok thanks.. ill try it

[MK_QSL]

In your script... instead of message, use below...

SubField(Replace(message,'"',''),'=',2)  as message

Update :

Method 2

Mid(message,Index(message,'"',1)+1,Index(message,'"',2)-Index(message,'"',1)-1) as message,

Method 3

TextBetween(message,'"','"') as message

[#7]

Try this

=SubField('"msg="test message" "','"',3)  or 

=SubField(YourMessageField,'"',3)

[#8]

i took it as an expression rather than on load thankyou all for the support.. much appreciated