This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion Board for collaboration related to QlikView App Development.
I have a field name as Section where my data is like:
Now i want to take only the name before the . in the field ex:
AA_D_B and BB_S_D from the section field in my Qv Apps.
Kindly please suggest me a solution
Pari solution is helpful but if i use it it also take '.' at last, so to remove '.' from the fileds
i have modified the solution a bit
its like left(filename(),index(filename(),'.') -1)
View solution in original post
try whis : left(filename( ),6)
or if length isn't constans
If i am using you solution
left(filename(),index(filename(),'.')) because length isn't constant in my data.
Then the value splits and come as AA_D_B. and BB_S_D.
'.' is also coming with the filed can you tell me how to take out '.' from it.
Thanks & Regards,
Thanks for your Solution.
It works but if i use
Then it will fetch data with AA_D_B. '.' at last also.
so to take out '.' from last i have modified the script as
left(filename(),index(filename(),'.') -1 )
This works perfectly,