-
Re: String Value manipulation
try this
Table:
load *,
purgechar(Right(ABC, len( ABC ) -Index(ABC,'_', -2)),'_') as LastSecond
1;load * inline [
ABC
MY_NAME_IS_XYZ
I_LIKE_READING_BOOKS_VERY_MUCH
ALTHOUGH_I_LIKE_SPORTS_TOO
];
-
Re: String Value manipulation
May be this
Capitalize(SubField(ABC, '_', -2) & ' ' & SubField(ABC, '_', -1)) as NewABC
-
Re: String Value manipulation
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
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
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
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
No There are Many values but i just provided a sample.
Thanks & regards
-
Re: String Value manipulation
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
Hi Sunny,
The solution you provided is good. Thanks for your great help and prompt replies!
Regards
-
