Discussion Board for collaboration related to Creating Analytics for QlikView.
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
can you provide some more sample alongwith your required result?
Have alook at SubField() and TextBetween().
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
thanks... ill do some research
thanks... ill do some research.. subField() should work, im tring it out...
=Replace( SubField(' msg="new test message"','=',-1),'"','')
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="