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
what have is like this
1 msg="new test message"
2 msg="some other message"
what i want is
1 new test message
2 some other message
thank you in advance
LOAD * Inline [
msg="new test message"
msg="some other message"
LOAD Replace( SubField(MSG,'=',-1),'"','') as MSG1 Resident TableA;
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="