-
-
Re: String Value manipulation
Sunny Talwar Apr 16, 2018 12:43 PM (in response to Shan Ahmed)-
298398.qvw 146.8 K
-
Re: String Value manipulation
Shan Ahmed Apr 16, 2018 1:07 PM (in response to Sunny Talwar )Hi Sunny,
Your solution looks very good. But if the Value is not just two words i.e kind of variable in nature in that case what would be the solution?
Example value:
ABC
Xyz
Very Much
Like Sports Too
The number of words in the field value Varies here.
Thanks & Regards
-
Re: String Value manipulation
Sunny Talwar Apr 16, 2018 1:15 PM (in response to Shan Ahmed)There needs to be some way for us to let QlikView know how many words from the end do we need.... right? What is that logic for you?
-
Re: String Value manipulation
Shan Ahmed Apr 16, 2018 1:43 PM (in response to Sunny Talwar )Hi Sunny,
Thanks for your reply again.
Lets say we have these three values for this particular field and requirements for the three different values are different.
Like,
ABC
MY_NAME_IS_XYZ -------------------> we need to extract only the last word
I_LIKE_READING_BOOKS_VERY_MUCH -------- we need to extract only the last two words
ALTHOUGH_I_LIKE_SPORTS_TOO -----------> we need to extract last three words
i.e,
ABC
Xyz
Very Much
Like Sports Too
Apologies if i creates confusion!
Thanks & regards,
-
Re: String Value manipulation
Sunny Talwar Apr 16, 2018 1:46 PM (in response to Shan Ahmed)These are the only three possible values that you field can ever have? I am just trying to understand because if the above is true, then you can do this so easily using Mapping Load or If Statement of Pick Match...
-
Re: String Value manipulation
Shan Ahmed Apr 16, 2018 2:07 PM (in response to Sunny Talwar )No There are Many values but i just provided a sample.
Thanks & regards
-
Re: String Value manipulation
Sunny Talwar Apr 16, 2018 2:09 PM (in response to Shan Ahmed)So, if the fourth line was something like this
I_AM_SUNNY_TALWAR_AND_I_LIKE_QLIKVIEW
how would I know that I need I Like QlikView or Like QlikView or just QlikView?
-
-
-
Re: String Value manipulation
Sasidhar Parupudi Apr 16, 2018 2:01 PM (in response to Shan Ahmed)how do you identify which line needs 1 piece and which line needs 3
-
-
-
-
Re: String Value manipulation
Shan Ahmed Apr 16, 2018 8:17 PM (in response to Sunny Talwar )Hi Sunny,
The solution you provided is good. Thanks for your great help and prompt replies!
Regards
-