Discussion Board for collaboration on QlikView Scripting.
I need to extract a detail from the below field value.
Required out put:
Hi,How about below expression?1. mid(Product ID,4)2. keepchar(Product ID,'1234567890-')3. mid(Product ID,index(Product ID,'1234567890'))4. IF(Left(Product ID,3)='HAI',Product ID,mid(Product ID,4))
The first 3 Product ID stayed the same, but others changed. Is there a logic behind what you are trying to do?
Look at my response here
Hi, Can you tell me what Qlik product you are discussing, I would like to move this to the forum specific to it as this is a general discussion forum. Thanks
As i Know Trim will drop the spaces between words (Left Trim,Right Trim,Trim..etc..)
but here your requirement will different than Trim
CLE136198-11300 o/p you are expecting like 136198-11300
so you need to be use purgechar().
so you need to use Purgechar(FieldName,'AND000200256543-11304')-- as [Test field] it will omit data from your field
now you need to do like
purgechar([Test field],'CLE') it will remove the characters from your field.
it will give result Amit
it will give result 1234