Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Highlighted
Not applicable

Getting a string out of a excel cell

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

Tags (2)
16 Replies
MVP
MVP

Re: Getting a string out of a excel cell

can you provide some more sample alongwith your required result?

MVP
MVP

Re: Getting a string out of a excel cell

Have alook at SubField() and TextBetween().

hrlinder
Honored Contributor

Re: Getting a string out of a excel cell


use

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

Not applicable

Re: Getting a string out of a excel cell

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

Not applicable

Re: Getting a string out of a excel cell

thanks... ill do some research

Not applicable

Re: Getting a string out of a excel cell

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

nizamsha
Valued Contributor II

Re: Getting a string out of a excel cell

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

nizamsha
Valued Contributor II

Re: Getting a string out of a excel cell

TableA:

LOAD * Inline [

MSG

msg="new test message"

msg="some other message"

];

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

Not applicable

Re: Getting a string out of a excel cell

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