Discussion Board for collaboration on QlikView Scripting.
I'm having data in this format
but i want in this format
Please take a look at the attachment.
Use Replace Function in your script..
Replace(YourFieldName,'-','') as YourFieldName
replace (Field,'-','') as NewField
You can use Purgechar function anything that has to be take it off in your script '-'
so try like these
=purgechar ( Youfieldname,'-' )
For replace function works like below it good to use purgechar for best optimization
replace('abccde','cc','xyz') returns 'abxyzde'
but i dnt Vc44c i want Vc4c4 in this way others also
Can you please elaborate a little bit more. The above example is different from your original example.
Can you create a table and put the two fields side by side with like 5,6 records as to how you want the result to be.
if(index(ddd,'-')>0, subfield(ddd,'-',1)&right(subfield(ddd,'-',2),1)&left(subfield(ddd,'-',2),len(subfield(ddd,'-',2))-1),ddd) as d2
in your load statement in the example qvw above.
Hi Snehal Mejari,
You have write following expression in your script,
Subfield(Data,'-',1)&''&PurgeChar(SubField(Data,'-',2),'1234567890')&''&KeepChar(SubField(Data,'-',2),'1234567890')*4 as newData
Which give you required as you want .
For better understanding i am attaching sample QVW
Check this It will help you,