Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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().
use
subfield('msg=test','=',2)
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
thanks... ill do some research
thanks... ill do some research.. subField() should work, im tring it out...
=Replace( SubField(' msg="new test message"','=',-1),'"','')
TableA:
LOAD * Inline [
MSG
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="
thanks anyway
cheers